Viewing 15 posts - 19,861 through 19,875 (of 22,202 total)
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...
July 28, 2008 at 6:52 am
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...
July 28, 2008 at 6:44 am
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.
July 28, 2008 at 6:40 am
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...
July 28, 2008 at 6:32 am
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...
July 28, 2008 at 6:26 am
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...
July 25, 2008 at 8:23 am
And (broken record time) the execution plans for the queries that are causing you the most pain.
July 25, 2008 at 8:20 am
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...
July 25, 2008 at 8:15 am
July 25, 2008 at 7:13 am
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...
July 25, 2008 at 7:09 am
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.
July 25, 2008 at 6:36 am
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...
July 24, 2008 at 8:09 am
Thanks for that. I love these forums. I learn something new every single day.
July 24, 2008 at 8:02 am
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.
July 24, 2008 at 7:50 am
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...
July 24, 2008 at 7:47 am
Viewing 15 posts - 19,861 through 19,875 (of 22,202 total)