Viewing 15 posts - 40,621 through 40,635 (of 49,571 total)
If the request is indeed for the last day of the following month, rather use this. Manipulating datetime using Dateadd and datediff is notably faster than converting pieces to string,...
March 4, 2009 at 7:19 am
As text please. There's an entry there that says "SQL resumed execution after... Reason:" but it's cut off.
The error log's just a text file. You can open it in notepad...
March 4, 2009 at 7:16 am
Chris Morris (3/4/2009)
..you're not going to ask the business reason then? 😉
Free beer means no questions asked.
March 4, 2009 at 7:13 am
GSquared (3/4/2009)
Has that thread been deleted?
Not yet
March 4, 2009 at 7:07 am
Grant Fritchey (3/4/2009)
Can I just add that I think this is the first time I've seen an active blanket party on this site.
I've seen one before. Happened when one...
March 4, 2009 at 7:05 am
Santhosh (3/4/2009)
but the requirement is1. to compare two tables
If all you're trying to do is compare two tables, have you considered using the tablediff utility that comes with SQL?
http://msdn.microsoft.com/en-us/library/ms162843(SQL.90).aspx
If...
March 4, 2009 at 6:57 am
Post that portion of the error log please?
March 4, 2009 at 6:44 am
Mangal Pardeshi (3/4/2009)
I can make out who is asking for right intention and who is just increasing his pots counts.
Can you really?
March 4, 2009 at 6:42 am
Krishna (3/4/2009)
Which one will be the victim for the dead lock agent?
Who knows?
The victim is typically the process that is cheaper to roll back. It has nothing to do with...
March 4, 2009 at 6:40 am
Check the SQL error log. There should be details in there about what SQL was doing for that time. My guess, there was a rather large transaction that it had...
March 4, 2009 at 6:36 am
Jack Corbett (3/4/2009)
The funny thing is I don't ever recall seeing the name on any other posts.
19 threads in total (including the Answered posts one), mostly a single post per...
March 4, 2009 at 6:32 am
mail2payan (3/2/2009)
I now declared a trigger, which will update DestinationTable, whenever data is being inserted in MyTable.
Actually, your trigger as written will insert into DestinationTable whenever data is been...
March 4, 2009 at 6:27 am
graham.boyle (3/4/2009)
I want to run some DBCC checks on a Database in SqlServer 2000
What DBCC checks? There are a lot of DBCC commands. Which one in particular are you talking...
March 4, 2009 at 6:25 am
iainthepitman (3/4/2009)
March 4, 2009 at 6:21 am
Viewing 15 posts - 40,621 through 40,635 (of 49,571 total)