Now that I've seen the longer version of your trigger, I have to agree that the email should be handled outside of the trigger. And if you get rid...

If you mean the SAVE TRAN statement should...

Is your SQL Agent service running as a local system account, or a domain account?

When using Windows authentication, the package will use the credentials of the user running the package....

The tricky thing about savepoints is that after rolling back to a savepoint you still have to do a COMMIT.

-- Get the initial transaction nesting level (will be at least...

I'm using '{COMP}' and '{TBL}' as replacement tags in the template string (I changed the angle brackets to curly braces so this would post correctly). They're just text strings,...

The answer you've already got should work, but I would do it slightly differently.

I like to use REPLACE functions to do multiple substitutions in a large string template, rather than...

Whether you copy the data to a new filegroup with an INSERT/SELECT, or move it by creating and then dropping a clustered index, the entire table has to be read...

This is more of an UNPIVOT question.

SELECT ColumnName,

CASE ColumnName WHEN 'Col1' THEN col1

WHEN 'Col2' THEN col2

ELSE col3 END AS ColumnValue

FROM MyTable

CROSS JOIN (

SELECT 'Col1' AS ColumnName

UNION ALL

SELECT 'Col2'...

One approach to using config files that simplifies debugging is to include variable values instead of step properties, then define properties from those variables using expressions. This way you...

SQLCMD can run scripts that include CONNECT commands to change server connections, so you could easily write one script that ran BACKUP on one server and RESTORE on another.

You could...

The SERIALIZABLE isolation level would prevent other users from adding a record to the table in the middle of your transaction. It would lock not just the (previous) last...

I'm curious what functions you need to implement that cause you to have a bunch of junior coders writing in CLR. Datareaders force row-by-row operations, if they can be...

Storing packages in the file system is usually better for development, primarily because you can use source control. (Hopefully your source control archive is part of a regular backup.)...

In a DTS package data transformation step, you are writing VBScript rather than T-SQL. You can't use CAST or CONVERT, there are separate functions such as CDbl(), CInt(), and...

I have found WITH(NOLOCK) very useful in reporting queries against web databases.

The reports are not critical, they are summarizing user counts and page hits rather than financial or medical info....