Thanks. ...

And she still won't arrive until Monday!:-P

Thanks to all for comments on my daughter's accident. She is definitely fine. Now we have to rein her in so she doesn't over do it the next...

You are sure there is nothing else running in the database at the time you are executing the osql command? What is happening in the procedure?

Thanks guys. Made it through the night and she is fine. This is our first time with a "real" injury to our kids.

Thanks guys. She's doing pretty well. It'll be a long night.

We had a bit of a scare in my family this afternoon. My 10 year old daughter fell off a rope swing and landed on her head. She...

I really highly recommend AGAINST doing this in a trigger. It will not scale and it is rife with problems. Use Service Broker or use a trigger to insert...

I'll be there to. I'm coming in on Sunday evening and staying at the Sheraton as well.

You could change the LocaleID in the advanced properties if you have the correct locale installed.

Performance-wise you might be better off changing your select to use Union (Union ALL if you don't mind dupes) instead of OR's as you will more likely get index seeks...

I'm going to pile on here as well. A trigger should NOT be used to update data on another server or really do any action outside the database (cross...

Looks like you have some kind of connectivity problem with your SMTP server. Have you talked to your Email admin? One other issue I've seen with DBMAIL in...

Check out the 2 Cross Tab and Pivot articles linked in my signature. They give a better explanation than I could. They do apply to SQL Server 2000.

I recommend you read this article[/url] as it covers Kerberos and SQL Server pretty thoroughly and if you have any questions post them on the discussion of the article as...