The issue You are having connection problems to the database and all the permissions look correct but you cannot login.Fire up the SSMS and expand […]
SQL Server Script user with SID
The Problem When you move sql logins around servers the logins are created with an SID that uniquely identifies the login. Assume you setup two […]
T-SQL Drop temp table if it exists
The Problem I often work in SQL Server with temp tables and they can be a pain when developing as you may have code like […]
SQL Sever DB Mail Logs
If you use SQL Server Database mail sometimes you will have trouble and you want to see a log of all the emails that have […]
exec sp_executesql nvarchar(max) truncating at 4000 characters
The Problem Sometimes you may need to write dynamic SQL. One example is writing query for running over linked server connections. You might write something […]