I think i found the issue. My SQL Server 2000 was an RTM version with no service pack. SQL Server 2005 needs to have 2000 with SP4 for upgrade to...
An year back i did a comparison between passing an array of values in a string (comma separated) versus passing them as an xml. xml approach was much...
Adriaan, I have a partitioned database and all partitions are encapsulated behind a view. Based on check constraints, the SQL query optimizer picks...
Dinesh, If my design is working for me then you can't really say it is a problem. All i wanted to know was whether i can go beyond 256 tables or...
I chose to upgrade the default instance of SQL Server 2000 Amit
Yeah the files could be opened through SSMS but not through notepad. As i was not able to use other editors so i moved back to SQL Server 2000 QA...
Guys, Thanks for replying. Please try and not digress from the actual thread. I am doing work arounds (temp table) for not running into this issue...
Guys, I have a partitioned database and i am accessing them through view. My queries on that view do not run (they give error) if it has more then...
Hi All, In MSSQL 2000, it was not possible to nest the passing and receving of resultset (table) to multiple nested levels. Is it possible in SQL...
Hi All, SQL Server 2005 used to have a limit of 255 tables in a query. Is it same in SQL Server 2005 or it has been improved? Will appreciate any...
Hi All, I did an upgrade of SQL Server 2000 to SQL Server 2005. After install, i can still see two of them as independent entities. I am also able...
All .sql files in that folder. Some of them were not even created by SQL Server 2005 management studio. It is really horrible. Amit
Hi All, I wrote a batch (.sql file) in SQL Server 2005 Managment Studio and saved it. When i am trying to open it in any other editor (like...
Isn't it same as what Frank wrote? Amit
Yeah it is for dynamic sql. The problem here is that @a, @b, @c are decided on certain condition and i can't put CASE inside EXEC(). Neither can i...
Hi All, I want to do concatenation of strings above 8000 characters. Does anybody know how to acheive it? Amit
Hi Frank, You mentioned a hack. Could you please elaborate on that? I also heard that there is something possible after manipulating system...
Hi All, Is there any way to hide user objects? I want to hide few of my tables in the schema. Is there any bit or something in any system...
Hi All, When i open a table in Enterprise Manager, my table gets locked with lock type as TAB and mode as IS. Any idea as to how to avoid this...
Hi Merril, What is don't want is that from my table receord from 'abcd' should be returned when i query for 'abcd '. I wrote LEN for just an...
Separate names with a comma.
