You've got two options. Set up TRY/CATCH and then return the error message that you want the user to see:

BEGIN TRY

RAISERROR('Major error in TRY...

And possibly introduced others.

You do know that NOLOCK can cause duplicate data to be displayed, not just data that's in flux? I think that after FAST 1, NOLOCK is...

Maybe I'm dense (ok, I am, but humor me), but if you're the one creating the temporary tables, don't you know the column names already?

Since you are new to this, please take a piece of advice.

Don't use dynamic SQL.

Especially since you're just getting started. Do the work to figure out how to...

The best thing you can do is set up regular monitoring of your data. You can get third party tools like Idera's Diagnostic Manager or the new one from SQL...

I've found that...

Your previous post scared me. I wasn't entirely kidding about sticking a fork in myself as a comarison. Using CLR is of questionable benefit in most situations. This one is...

So what do I do with these pork chops? Sharpen the bones & throw 'em like a boomarang?

Replaying Trace does work. It's a bit of a pain to set up, but it does work. However, a Trace is dependent on you already having a database and application...

I liked "DBAs of Dawn" better.

I've done a ton of testing of SQL Server 2000 and 2005. I've never tried load testing replication before, so I'm not sure of anything that would help you there.

The...

It's not normal for a single procedure to take all the resources, no. But if the query is really poorly written or designed, it certainly could happen.

I'd make sure you...

Nice post. Good set of rules. But now we'll have to refer to you as Jeff Isaac Rbar Moden. You're starting to sound like a Civil War general.

Is it safe to assume that MovementIdentifierContext, MovementIdentifier and MovementIdentifierContext, while not unique as noted, combined identify a given Movement? Or is it just the IdentifierContext and IdentifierComposite fields, those...

There's not enough information in the question to give you specfic answers, but some general thoughts I would have when faced with the general situation...

Can you test the update against...