More often than not, locking is handled just fine by SQL Server. Don't start adding lock hints until you run into a problem, and possibly, not even then. Usually adjusting...

Honestly, try reinstalling.

It'll take me a while to dig it out of the archives, but we found a situation a few years ago that showed it wasn't all that hard for a...

Oh man, I missed that article. Great job. Sweet solution. Here I was going to suggest possibly using XML depending on the size of the array. Never mind.

Do what...

Or, since it's not always possible to capture a transaction while it's open, use Profiler to set up a trace and capture the output from your procedures to a file....

I have not. I do know a consultant that's worked in that range. You should give Andy Novick a call. Here's his web site: http://www.novicksoftware.com/%5B/url%5D

There isn't a "right" number for a lot of these values. It really depends on the system you're on. Simply collecting one set of values is usually not enough. We...

I can't recommend enough that you develop in 2005. Work you do on a 2000 box might not work in 2005 and there are a ton of things you can...

Tons to learn then.

First, make sure you've got a good backup strategy in place. Before you worry about monitoring and all that stuff, protect your data.

Also, you should schedule a...

If you're trying to control locking through the procedure, it certainly could be the proc locking itself. Rather than try to put more and more locks on, I'd suggest putting...

There's also a section in Books Online on OUTPUT PARAMETERS specifically. It not only talks about creating them within procedures, but the syntax on how to use them to call...

If you absolutely MUST use dynamic SQL, make it parameterized instead of a concatenated string. You can then call sp_executesql and pass the appropriate paramters.

I do believe that we're making buggy whips and at some point a horseless carriage is going to drive by, but it's not in sight at the moment, despite the...

Just be sure that you're capturing them to a file and not using the GUI. If this causes your server to go down, you were already in severe trouble and...

From what you described, you're not necessarily seeing a table lock. Have you tried taking a look at sys.dm_tran_locks? That will give you a lot of information about what is...