Wednesday, February 29, 2012

View Login Details on MS SQL database


Some of the useful SQL syntax
Viewing logins and Databases:

SELECT * FROM sys.sql_logins;

SELECT * FROM sys.databases;
SP_helpuser:

Reports information about database-level principals in the current database.

Syntax: sp_helpuser

Naveen Mukkasa - MCTS  

SQL Server 2012 RC0 Download.

Guys am back after a long gap... Will continue blogging stuff which helps the community...

Here is the SQL Server 2012 RC0 download link...

http://www.microsoft.com/sqlserver/en/us/future-editions.aspx

Naveen Mukkasa