Another quick one… You can run this stored procedure:
exec sp_databases
Which should yield the following output:
![image_3_2A71938E](http://crayveon.com/wp-content/uploads/2013/12/image_3_2A71938E.png)
or you could try this stored procedure:
exec sp_helpdb
Which would yield some more extended information thus:
![image_6_2A71938E](http://crayveon.com/wp-content/uploads/2013/12/image_6_2A71938E.png)
or if you just want the names, you could execute this “undocumented” stored procedure:
exec sp_msforeachdb 'print ''?'''
Which will yield this:
![image_9_2A71938E](http://crayveon.com/wp-content/uploads/2013/12/image_9_2A71938E.png)
Or you could do the manual step of executing the following select query:
select name from sys.databases
Which will yield:
![image_12_2A71938E](http://crayveon.com/wp-content/uploads/2013/12/image_12_2A71938E.png)
Cheers
C
No comments:
Post a Comment
Comments are moderated only for the purpose of keeping pesky spammers at bay.