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...
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...
Hi All, I want to do concatenation of strings above 8000 characters. Does anybody know how to acheive it? Amit
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 All, When i do SELECT LEN('abcd') SELECT LEN('abcd ') i get same length. Is there any way to treat them different. Basically i am...
Hi All, What is the easiest way to check whether view has data or not. I need to do it in dynamic sql as my view name is coming at run time....
Hi All, On some machines, i am not able to connect to sql server using localhost. It works fine if i use . for server name. Any idea what could be...
Hi All, I have a small query. How to drop a database even when there are active connections open with the databse? Regards, amitm79
Hi All, Does anybody knows how to read the previous value of a column on UPDATE trigger? I want to do some action based on change in the value of a...
Hi All, I am getting the following error while trying to insert data using a view. Server: Msg 4436, Level 16, State 12, Line 2 UNION ALL view <View...
Hi All, Where can i find the details of all check constraints on a table? I want the exact check and not just the name of the constraint. Regards,...
Hi All, I need your experience about SQL server design tools. I am writing my requirements below, please let me know if you know any tool that...
Hi All, I am looking for all object names having _1I_ in sysobjects. I used WHERE name LIKE '%_1I_%'. I am also getting _41I_ as part of the result....
Hi All, I am trying to call a stored procedure from osql utility. The SP has one of the parameters as a directory path and it needs to be enclosed in...
Hi All, Could you guys please share some good knowledge share links on "RAID Configuratio"? I intend to do some RAID configuration in my...
Hi All, Does anybody know what will be the impact if i modify the view definition while its being used by another process/connection. Regards,...
Hi All, Is there any way to encrypt the source code or whole database? I don't want anybody to see the source code or the database schema. In...
Separate names with a comma.
