How to get current user for a query in SQL Server 2005: SELECT SYSTEM_USER returns the name of the current context, which helps with debugging and security.
SQL SERVER – Get Permissions of My Username / Userlogin on Server / Database
Invited to review a big company’s schema, I wanted to know my own permissions without asking their DBA. fn_my_permissions shows them at server and database level.
SQL SERVER – 2005 – Fix : Error : Msg 7411, Level 16, State 1 Server is not configured for RPC
Msg 7411 says the server is not configured for RPC. A Jr. DBA I am training found the fix on his own: turn the RPC option from False to True.
Querying Active Directory From SQL Server
Querying active directory through an ADSI linked server can answer narrow questions, but its limits favor staged data for repeatable work.
SQL SERVER – Frequency of SQL Server Reboot and Restart
How often should you do a SQL Server reboot? From my experience there is no need, though our network team reboots all our servers every 15 days.
Orphaned Users After a Restore, and How to Fix Them
Find orphaned users after a SQL Server restore, compare user and login SIDs, and repair the intended mapping with ALTER USER.
SQL SERVER – 2005 – SSMS – View/Send Query Results to Text/Grid/Files
Three ways to send query results to text, grid or file in SSMS: the shortcuts CTRL+T, CTRL+D and CTRL+SHIFT+F, the toolbar, or the menu bar.