Lynn Pettis (8/7/2014)

At...

Do you have any errors on the SQL cluster at those times? Is this an intermittent problem or does it happen every time the package runs? Have you...

Are you sure that BIDS/SSDT has been installed on the machine? If it has it sounds like a corrupted install and I'd first try to re-run the install doing...

I think it is easier to do this in PowerShell than T-SQL so I'd put it in the load. I don't have the code in front of me to...

You don't mention Source Control until the end of your post and I'd recommend starting with Source Control if you are developing standards. There are plenty of free/open source...

Here are the options I know of for what you want to do and the SQL Server version(s) it will work on:

1. DDL Triggers - all versions

2. Stored...

Are you stalking me? You seem to...

The easiest way to do this is to have a calendar table. So I'd do something like this:

DECLARE @members TABLE

(

MemberID...

I think you are out of luck as far as Xevents go. You have 2 options:

1. Configure the instance to log failed and successful logins which sends them...

I'd recommended just using MERGE. It isn't that hard to work with. Something like this:

MERGE EPSBankRef AS Target

USING ( VALUES

(

...

From BOL:

Also from BOL:

Members of the securityadmin fixed...

If you catch this soon enough you can query the default trace to find out who is disabling the triggers.

It shows as an Object:Altered Event and the ObjectName column will...

For the destination you actually have to modify the column in the table because the destination is getting it's data types from the meta data of the destination. I...

I'd add a step before 5. Restore database from backup on another machine to validate I have a good backup. Otherwise it seems okay.

That still can require some special handling as the "ALL" really just...