April 16, 2009 at 8:56 am
I would liketo know the t-sql query to find out all the user_created databases, when they got created and who created?
TIA
April 16, 2009 at 9:05 am
Just run a query on master.dbo.sysdatabases. You can sid column as an input to suser_sname function, and name and created date are already in table (crdate).
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
April 16, 2009 at 9:07 am
thx
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply