Thanks Thom.

I've done a deny select (and I'll probably need to do some other DENYs as well) on the relevant table already.
This is part of a test...

Thanks for that.  I found one under Server objects.
It's DDL trigger from the RedGate DLM dashboard that looks like it tracks changes.

I'm going to disable it for...

We're trying to change the way we do deployments (and get databases, etc. into source control) but it's slow going.
As for deployments, there's only us lowly developers to do...

Hi Phil

We use SSDT/Visual Studio to create SSIS packages, stored procedures, etc (so we can use version control) and then we deploy/execute depending on the server name in...

Looking thorugh the log file, I've found a couple of potential issues:-
A pending restart is blocking setup from completing. Please restart the computer and run setup again.
Setup is...

I think I've got to the bottom of it.
It looks like you've got to delete all the permissions first and then delete the role as they don't cascade.

I'm not sure why it doesn't work (although the value won't convert directly using cast), but if you try:-
SELECT CAST(CAST('1.23' AS FLOAT) AS int)
that works.
Is this a...

I'm still waiting for the list of updates that were applied.
I've also asked the same team to take a clone of one of current (working) servers and apply the...

Hi again 😀

I've added a few columns to my receiving database as follows:-
SYSDateLoaded - this is when the data first appeared
SYSDateLastUpdated - This is the last...

We did something similar using event handlers to push the error messages to a table.
The start time of the package was logged in the same table (as was the...

Hi Steve

I've already mentioned about building our own in-house software (there's enough skills here to do it) but was told it would be too complex and too expensive...

It looked complicated but I couldn't see any way around it.
Thanks (again) to Steve for a brilliantly simple solution.

As for unpredictable, that's an understatement.  And as for...

We've got some code to write dynamic triggers so we'll be using some of that to put a trigger on each table (should be reasonably fast as well).
We're not...