SQL Server 2005 Dedicated Administrator Connection

Microsoft SQL Server provides a dedicated administrator connection (DAC). The DAC allows an administrator to access a running instance of SQL Server Database Engine to troubleshoot problems on the server—even when the server is unresponsive to other client connections. The DAC is available through the sqlcmd utility and SQL Server Management Studio. The connection is only allowed from a client running on the server. No network connections are permitted. Continue reading


How to fix Orphaned Users in database

FIX : Error 15023: User already exists in current database

Orphan user is a user in a SQL Server database that is not associated with a SQL Server login..

Continue reading

Grant Execute All Stored Procedures

Here I have tried to explain how we can provide permission to execute all the stored procedure in particular database. In SQL Server 2000 has fixed database roles such as db_datareader and db_datawriter that allow a user read or write access respectively to all the table is a database, no such role exists for the execution of stored procedures (a db_executor role if you will). Continue reading