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?
About Tom Lasswell
about myself.Tags
blog
cacti
camera
cluster
ConfigMgr
Datacenter
datadomain
dfs
finances
fun
gx
home
iphone
isy
netapp
network
opsmgr
phone
photos
reporting
san
SCOM
script
sms2003
sql
srm
toy
uptimedevices
vmware
work
xbmc
Twitter Feed
- @kix1979 link? What's the free connector?
- @vStorage finally! been looking forward to this feature. glad it's finally there. nice writeup btw.
- @3parfarley been using that for about a year now. :) when i first used it finally got a correct pizza order. hah
Personal
Vendor
Recent Posts
- ISY Python Script for controlling media lights via xbmc
- Schedule a URL into Maintenance Mode
- First iphone 4 post
- Designing Disaster Recovery … on a budget
- OpsMgr 2007 – No graphs in emailed reports
April 3rd, 2009 - 22:37
Hi,
simple and straigt-forward query, that works just fine!!!!
thanks..