DATABASE

Question

DATABASE

susheereddy

SSC-Addicted

Points: 445
More actions
January 27, 2008 at 1:50 pm

#121908

PLEASE HELP ME OUT

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

GRE (Gethyn Ellis) SSCrazy Eights Points: 9602 More actions · Answer 1

OK well not th most detailed post but if you want to list all the uset database on a particular server then this will list them also it will provide a count of the number of user databases. hope this helps:

USE Master

GO

SELECT * FROM sys.databases

WHERE Name NOT IN ('Master','model','msdb','tempdb')

SELECT COUNT(*)as 'Number of User Databases' FROM sys.databases

WHERE Name NOT IN ('Master','model','msdb','tempdb')

Gethyn Elliswww.gethynellis.com

Steve Jones - SSC Editor SSC Guru Points: 736270 More actions · Answer 2

Please do not post in all caps and please describe your problem in the post.

Brandie Tarvin SSC Guru Points: 173068 More actions · Answer 3

And if there are error messages, don't forget to include them in your post.

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.