Search This Blog

Saturday, April 25, 2009

Utility to see Logins and users on an instance

Use below link to download it:

http://cid-2512e6af14d229c4.skydrive.live.com/self.aspx/SQL%20Server%20Utilities/Instance%20Users%20and%20Logins%20Details.zip

Description:
You can see available logins on an instance and users list in a databases, their fixed roles at server and database level, categorized as server login and database user, Object level permission details.

Pre-requistes:
.Net Framwork 2.0 installed
Only for SQL Server 2005+

Wednesday, April 15, 2009

List of Running Sessions and their Requests on an Instance

Download this free utility by clicking below link:

http://cid-2512e6af14d229c4.skydrive.live.com/self.aspx/SQL%20Server%20Utilities/Running%20Requests%20on%20an%20Instance.zip

Pre-requists:
.Net Framwork 2.0 or +
Only for SQL Server 2005+
Developed using VB .Net

Description:
This is an executable file that is available in zip formate at above link.
You can view all logins sessions and their running requests on an instance by providing SQL Server instance name or IP Address and can filter them by database by getting all db name or providing db name by writing in combo box.