Viewing 15 posts - 5,506 through 5,520 (of 7,191 total)
I don't think your query as it stands at the moment will work anyway. The line that begins "set @qry=" seems to end very abruptly.
Having said that, since it's...
March 11, 2011 at 1:54 am
Tim
No, they won't. As long as there are no precedence constraints between the level 3 packages, they'll all run to completion (whether that be success or failure).
John
March 8, 2011 at 5:48 am
I ran into this issue myself recently. I can't remember how I solved it, but I found some good examples by searching the web and modified those. The...
March 7, 2011 at 6:32 am
I prefer the one where you have a go at writing it yourself, and post back with what you've tried if you run into any particular problems.
John
March 7, 2011 at 6:28 am
Lakshman
Why do you want to use row locks? Is there a reason why you don't want to let SQL Server decide what locks to use, and escalate to page...
March 7, 2011 at 6:15 am
No, I think you'd need to rewrite SP1 so that it only returns one result set, then write another stored procedure to return the second result set.
John
[Edit - rewrote reply...
March 7, 2011 at 5:57 am
Actually, it's difficult, if not impossible, to know after the event what the deadlocking process was unless you had already enabled the appropriate trace flag or started a Profiler trace....
March 7, 2011 at 4:30 am
I think that the article you mention only refers to databases with TRUSTWORTHY set to ON.
I wouldn't recommend having NT AUTHORITY\SYSTEM as a database owner. If you do, any...
March 1, 2011 at 8:02 am
So is it fixed now, or do you need any more help?
John
March 1, 2011 at 2:04 am
krishusavalia (2/11/2011)
Can you guide me though how can i check that account is same or different for sql server and sql sercer agent?
when i am...
March 1, 2011 at 1:59 am
ZZartin (2/11/2011)
Does your SQL server service account have proper access to the network path?
In case you have separate accounts for your SQL Server and SQL Server Agent services, it's usually...
February 11, 2011 at 9:46 am
Wayne
There's been a lot of partisan debate about whether and how to use stored procedures, so I'll let you search for that and make your own mind up!
From my own...
February 11, 2011 at 9:12 am
Wayne
Create a stored procedure in your database that has parameter SerialNo, then write a macro in your Excel workbook that passes the parameter from the worksheet to the stored procedure...
February 11, 2011 at 8:38 am
If the original owner is, for example, a DBA who has left the company, then you shouldn't need to do anything after changing the owner. However, some databases are...
February 11, 2011 at 7:54 am
If you are changing the database owner to sa then one effect of this is to remove the original owner's access to the database. You need to make sure...
February 11, 2011 at 7:44 am
Viewing 15 posts - 5,506 through 5,520 (of 7,191 total)