Tools for which option?

I believe you can find some scripts in the scripts section of this site that will automatically generate audit triggers for...

simpson213 (8/7/2014)

---

Embarrassingly, BIDS was not installed on the machine. I'm new at this, so I'm just starting to get my sea legs with regard to writing queries in ssms and...

Solution = Container for projects. For example I have a solution that has an SSIS project, a database project, and an SSRS project that all relate to one...

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...