Is there a way to fetch all the Views in a database in the order of dependency. Eg: Assume there are two views View_A & View_B. View_B is used in...
Hi, Im using Sql server 2000. I wanted to know if its possible to open a cursor using an sp instead of an sqlstatement? Also I know that cursors...
Both, thanks for your response. I understood the options and syntax [H].
Hi, Im using SqlServer 2000 and I want to know if it's possible to change the location of (.mdf & .ldf) files? For eg: If it's located in...
In the above query Else statement is not required as datatime columns will be NULL Select TimeID, case when TimeFlag=1 then AllTime end as...
Thanks for the information Madhu.
The above link was very useful. Im just learning about linked servers. For Example I have two Servers A and B. After linking server A with B and if...
Hi, I want to konw if there is a way to write a query connecting to two different servers. The reason for this requirement is I had to compare the...
Apologies for the confusion Im using Sql server 2000. All the aswers pointing me again to use osql utility. Im looking for some other option.
Im not able get what this is "ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/3ec89119-7314-43ef-9e91-12e72bb63d62.htm"
You can also use XML System Stored Procedure sp_xml_preparedocument
Hi, Is there is a way to run the scripts from a file. For eg: Assume I have a folder named "Scripts"in location c: and there are files (say...
Thanks Mohammed.
Hi, Can anyone let me know how to identify the default instance name of an Sql server 2000?
Yup it worked . Thanks for your reply Ranjit.
Hi All, How do I identify the list of stored procedures which uses a column from a table? Eg. Assume EmpNo is a column in table Employee. In what way...
Separate names with a comma.
