Ask How In .Net
Thursday, 10 May 2012
Find logical name and physical location of system databases using Sql Server
SELECT name ,physical_name AS CurrentLocation ,state_desc FROM sys.master_files WHERE database_id = DB_ID(N'EasyShopAimsLab_new_1Mar2012')
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment