Search Results | SQL Server Performance Forums

Database views in the order of dependency

Thread by: bharathsivam, Mar 3, 2009, 5 replies, in forum: SQL Server 2005 General Developer Questions

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...

Opening cursors

Thread by: bharathsivam, May 19, 2008, 1 replies, in forum: Getting Started

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...

Relocating .mdf & .ldf files

Thread by: bharathsivam, May 16, 2008, 3 replies, in forum: General Developer Questions

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...

Writing Query connecting to two different servers

Thread by: bharathsivam, Apr 25, 2008, 5 replies, in forum: General Developer Questions

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...

Executing .Sql files in a folder

Thread by: bharathsivam, Mar 14, 2008, 7 replies, in forum: Getting Started

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...

Sql server default instance name

Thread by: bharathsivam, Mar 11, 2008, 2 replies, in forum: General Developer Questions

Hi, Can anyone let me know how to identify the default instance name of an Sql server 2000?

Identifying columns used in a stored procedure

Thread by: bharathsivam, Mar 5, 2008, 2 replies, in forum: General Developer Questions

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...