Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Script to obtain a database Files view
Message
 
To
30/03/2012 15:22:44
General information
Forum:
Microsoft SQL Server
Category:
Scripting
Environment versions
SQL Server:
SQL Server 2008
Application:
Web
Miscellaneous
Thread ID:
01539866
Message ID:
01539874
Views:
54
This message has been marked as the solution to the initial question of the thread.
>>There are built-in views..
>>
>>sys.database_files
>>
>>or see.. http://technet.microsoft.com/en-us/magazine/dd326793.aspx
>
>I am not sure if this is the proper link you wanted to paste but I do not see anything in there that is much useful for what I am trying to accomplish. I did however try to script it. When I am in that panel, there is a script option at the top. But, if I click on it, it says nothing to script.


try this for any selected database..

select * from sys.database_files


or try exec sp_helpdb databasename (substituting your databasename)
____________________________________

Don't Tread on Me

Overthrow the federal government NOW!
____________________________________
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform