Reset SQL Server SA Login via Powershell
The Problem You have lost or forgotten the SA password for you SQL Server box!! The solution This is really
Continue readingCategory: SQL Server
Grant Connect SQL Server – TSQL
The issue You are having connection problems to the database and all the permissions look correct but you cannot login.
Continue readingSQL Server Management Studio on Hi Res Screen
The problem You are using SSMS on one of these new wizbang hi res screens and all the dialogs are
Continue readingSQL 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
Continue readingT-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
Continue readingTerrible Performance of SQL Server Linked Server query over WAN
The problem I have a linked server connection between 2 SQL servers approx half the world away. One server resides
Continue readingSSIS Convert between datetimeoffset and datetime
The Problem I had a sql table that was storing data in a DateTimeOffset(7) datatype, DateDeleted. I was trying to
Continue readingSQL Server Enable User
The problem You have a SQL Login created for your account usr_test Everything appears fine, but you cannot connect. When
Continue readingSQL Sever DB Mail Logs
If you use SQL Server Database mail sometimes you will have trouble and you want to see a log of
Continue readingVisual Studio SQLCompare does not Compare SQLCMD Variables correctly
The problem When using the Visual Studio SQL Compare to compare your database schema to your physical database it returns
Continue reading
Recent Comments