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

And (broken record time) the execution plans for the queries that are causing you the most pain.

I had never heard of that before, so I did some searching around. You're not the only one to see this. From what I can see out there, it's actually...

Lookup Backup in the books online.

You might also look at this[/url].

The pro to having a single table, and I see only one, is that you don't have to worry about JOIN statements in your queries. With decent indexes and appropriate...

Make sure the other parts of the IF statement are also wrapped in BEGIN..END. You simply can't have multiple statements within an IF clause without wrapping them.

You only get one statement after an IF clause so your current code is hitting RETURN and exiting. Try this:

ELSE

BEGIN

--==== If The file does not exist...

Thanks for that. I love these forums. I learn something new every single day.

I haven't tried that yet. I suppose it will work if documentation says so. It's not one of these places I like to take chances with.

Then you have to restore to a new location, either a new database or a new server, and then move the data you need to recover from that new location...