Execute the following T-SQL script in Microsoft SQL Server Management Studio Query Editor to check if current login can access a specific database.

use master;

select DBAccessForCurrentLogin=Has_Dbaccess('AdventureWorks2008');

go

/* Result

DBAccessForCurrentLogin

1

*/

------------