Database Master Key Error After Database Restore
When restoring a database to another server, you may get a master key error if using symmetric keys
2014-03-31
29,272 reads
Derek Stanley
Removing the Linked Server 2 hop Limitation
This article talks about how you can get around the "Login Failed for user 'NT Authority\ANONYMOUS' LOGON" error when using linked servers and Windows authentication.
2013-12-17
8,625 reads
Blogs
Daily Coping 31 Jan 2023
By Steve Jones
Today’s coping tip is to take a small step towards and important goal. One...
Tales From The Field Weekly Wrap Up for the Week of 01-23-2022
By SQLBalls
Hello Dear Reader! It's been a while since I had time to sit down...
CONCAT_WS Function Truncates Text
I was writing some dynamic SQL that generates some SQL statements to load my...
Forums
SSIS Sort Alphanumeric?
Hello, I'm pretty new to SSIS, but I have an Excel source that I...
How to get number of unique months from table
Hi guys, I want some help with a code to count the number of...
Track Insert/Update/Delete Operations in Sql Server DB Table
Hi Team, I have a requirement to track any insert/update/Delete operations happened against Database...
Ask SSC