Viewing 15 posts - 34,546 through 34,560 (of 49,552 total)
Gentlemen, can you drop this please. It's not appropriate for the thread's topic and I'd rather not have Steve come and lock this because it got out of hand.
Thank you.
January 20, 2010 at 1:16 pm
Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic850692-17-1.aspx
January 20, 2010 at 12:39 pm
I have a feeling that I'm confusing the issue not clarifying it.
January 20, 2010 at 12:34 pm
The trace flag. I've never noticed an impact (though there will obviously be a slight one) and you don't have to worry about whether or not the trace is running....
January 20, 2010 at 12:33 pm
That is not a native SQL backup. What tools are you using to do the backups?
January 20, 2010 at 12:32 pm
Ignacio A. Salom Rangel (1/20/2010)
Good point Lynn, but I still will restart the server first!
Depends on what the exact error is. Cases like this, where it's a file that is...
January 20, 2010 at 12:27 pm
Lynn Pettis (1/20/2010)
Having already restored the database, you were in a position to quickly "swap" it if the checkdb had come back bad.
True, but in general I would...
January 20, 2010 at 9:32 am
Just one question
h.wijnbergen (1/20/2010)
select @ordernr=ltrim(rtrim(ordernr)), @selcode=selcode, @fiattering_new=fiatteringfrom inserted
select @fiattering_old=fiattering
from deleted
What happens if there's more than one row in...
January 20, 2010 at 9:29 am
Lowell (1/20/2010)
January 20, 2010 at 9:25 am
My previous boss expected me to spend time (within reason) on the forums. He considered it an investment, His reasoning was that it was 'free' training for me (training that...
January 20, 2010 at 9:25 am
Paul_Harvey (1/20/2010)
I think I need two triggers (please correct me if I am wrong) becuase I would like the Created_By field and the Modified_By field to be maintained.
No, in that...
January 20, 2010 at 9:17 am
Nabha (1/20/2010)
Thanks Gail, I just looked at the trigger code and it was just there for 'insert' and thought default would do.
If it was just insert, it would, but the...
January 20, 2010 at 8:13 am
NewID gives a new value per row, so you can just put that in the INSERT .. SELECT statement, exactly as Lutz did in his post.
If it's something other than...
January 20, 2010 at 7:34 am
There are no free training kits that I'm aware of, and we do not support distribution of copyrighted materials on this forum. The books are not expensive, look at them...
January 20, 2010 at 7:30 am
Query sys.dm_exec_requests. It's treated exactly like any other view.
January 20, 2010 at 7:09 am
Viewing 15 posts - 34,546 through 34,560 (of 49,552 total)