What happened while I was away on vacation?
SELECT
[databases].[name],
[server_principals].[name] AS [database_owner_name],
[databases].[create_date],
[databases].[state_desc]
FROM [master].[sys].[databases]
INNER JOIN [master].[sys].[server_principals] ON
[databases].[owner_sid] = [server_principals].[sid]
WHERE
[databases].[database_id] >= 4 AND -- Filter out system databases
[databases].[create_date] >= '2012-07-27';
No comments:
Post a Comment