Tuesday, July 15, 2008

Find all databases that the current user has access to

SELECT [Name] as DatabaseName from master.dbo.sysdatabases

WHERE ISNULL(HAS_DBACCESS ([Name]),0)=1

ORDER BY [Name]

No comments: