TechColumnist Storage Information Blog

Subscribe via RSS
  • Home
  • About
9
Sep/07
71http://www.techcolumnist.com/wp/2007/09/09/list-all-databases-and-their-files-on-ms-sql/List+all+databases+and+their+files+on+MS+SQL2007-09-09+06%3A32%3A05dblSHOT

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

Tagged as: sql
71 Commenthttp://www.techcolumnist.com/wp/2007/09/09/list-all-databases-and-their-files-on-ms-sql/List+all+databases+and+their+files+on+MS+SQL2007-09-09+06%3A32%3A05dblSHOT

Twitter Feed

  • I miss my #magichat but drinking a #guiness in ny in #timessquare 2010/02/04
  • @storagebod nah, tablets are old news. 2010/01/26
  • whoo, going to be in vegas this weekend. #AVN here we come. staying at the Marriott's Grand Chateau because @LasVegasHilton was booked. :( 2010/01/04

Tags

blog cacti camera cluster ConfigMgr Datacenter datadomain dfs finances fun gx home netapp network photos reporting san SCOM script sms2003 sql srm toy uptimedevices vmware work

Personal

  • Me on LinkedIn
  • Twitter

Vendor

  • 3PAR
  • Brocade
  • NetApp
  • Tek-Tools

Recent Posts

  • OpsMgr 2007 – Author Privileges
  • NetApp OnTap 8.0rc2 Filerview
  • Remotely reboot a server
  • Greyed out Domain Controllers
  • NetApp DS4243 Disk Shelves

Archives

  • 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
Copyright © 2010 TechColumnist · Powered by Wordpress and developed by Andrei Luca for you.