April 27, 2009 at 1:25 am
Dear All,
I have created tables and using tables i am written Procedure,view and function in Sql Server 2000 database.
Could you please guide me it is store in which location\path of the the SQL Server 2000.
Thanks in advance.
Regards
Sumanta Panda
April 27, 2009 at 1:56 am
Tables, views, functions and procedures are all stored within the database file, hence there's no path to them. Or are you looking for the location of the SQL database files themselves?
In future please post SQL 2000-related questions in the SQL 2000 forums in the future. If you post in the 2005 forums, you're very likely to get 2005-specific solutions.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 27, 2009 at 3:43 am
Yes i am looking for the location of the SQL database files themselves.
Thanks!!!
Regards
Sumanta Panda
April 27, 2009 at 4:10 am
This query, when run in the context of the DB in question, will show you where all the files associated with that database are.
select name, filename from sysfiles
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply