Posts
Sort by recent activity
How to ignore different datatyes
We have a system with a live and an archive DB and I now need to track all changes made in the live DB in the archive DB. The problem is that a field named tst has the datatype timestamp in the liv...
CImageHelper Failed with SQLMonitor 9.1.6
For all our SQL instances controlled with SQL Monitor we get the following error message in the SQL Server Log:CImageHelper::Init () Failed load of symbol file with path = C:\Instance\MSSQL14.xxxx\...
How to remove old license admin
As a license admin I can manage our redgate user lincenses - that works as expected. Now I have to remove another license admin who has left the company, but I found no way to do that. I can invite...
SQL Monitor 2 and Deadlocks ... ?
I'm seeing some very strange behaviour here ...
After installing, I tested SQL Monitor 2 in our development and test environment. Everything looks fine there. Then I monitored two production server...
Problem with scripting of event notification
We created the following Service Broker code in one of our systems:
CREATE EVENT NOTIFICATION [PoisonMessageNotification]
ON QUEUE [dbo].[QueuePoisonMessageNotification]
FOR BROKER_QUEUE_DISABLED
T...
OutOfMemoryException
After working several days with SSMS I get the following error message when I want to commit changes on a database with > 2000 objects. Smaller databases still work with Source Control, all other f...