Viewing 15 posts - 5,506 through 5,520 (of 7,187 total)
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
Or something like this:
SELECT RIGHT(' '+CAST(MyDecimal as varchar(18),18)
But really, you should be using...
February 10, 2011 at 8:14 am
Probably your best bet it to use bcp or SSIS to create your file. If you don't want to do that, please will you explain your requirement better? ...
February 10, 2011 at 6:47 am
clarmatt73 (2/10/2011)
I am trying to change a Decimal (18,2) to Char(12) which is simple enough however the figure needs to have spaces at the start instead of on the...
February 10, 2011 at 5:18 am
Thanks for taking the time to explain that, Joe. I understand what the problem is now - where you have a many-to-one relationship between the two joined tables, the...
February 2, 2011 at 4:06 am
Viewing 15 posts - 5,506 through 5,520 (of 7,187 total)