9Sep/071
List all databases and their files on MS SQL
A quick way to check and see all databases for your MS SQL server is to run the following command using the Query Analyzer on the Master database:
select name, filename from sysdatabases
Enjoy this article?
Site5.com
Tags
blog
cacti
camera
cluster
ConfigMgr
Datacenter
datadomain
dfs
finances
fun
gx
home
iphone
isy
job
netapp
network
opsmgr
phone
photos
reporting
san
SCOM
script
sms2003
sql
srm
toy
uptimedevices
vmware
work
xbmc
- managing #facebook albums sucks, anyone know of any good tools to help manage your #pictures? 38 minutes ago
- anyone know how to get around the cisco vpn blocked local lan and running the #netapp simulator in vmware player? 1 month ago
- woot! just got the hp slate 2. now to find a case 1 month ago
- start the new job Tuesday. Excited! I'm now a Systems Engineer - #NetApp at #CDW. Let the new experiences and fun begin! 1 month ago
- New job starts next week. Going back to being a straight up NetApp engineer. Excited about new adventures. 1 month ago
Badges
Recent Posts
- NetApp Disk Shelf Model Breakdown
- Update: New Job! Systems Engineer at CDW
- More to come… but a new job is on the horizon
- New hosting provider
- SCOM: Alert Generating Rules vs Collection Rules
Archives
- January 2012
- December 2011
- September 2010
- July 2010
- April 2010
- January 2010
- October 2009
- September 2009
- August 2009
- July 2009
- May 2009
- April 2009
- November 2008
- October 2008
- September 2008
- August 2008
- July 2008
- June 2008
- May 2008
- March 2008
- February 2008
- January 2008
- October 2007
- September 2007
- August 2007
April 3rd, 2009 - 22:37
Hi,
simple and straigt-forward query, that works just fine!!!!
thanks..