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...
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...
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...
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...
Is there is a way to run the scripts from a file.
Assume I have a folder named "Scripts"in location c: and there are files (say...
Can anyone let me know how to identify the default instance name of an Sql server 2000?
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.