Yes you could and should re-write the trigger, but not just because of the error message, which you get whenever you have a rollback in a trigger, there's no way...

Hey, I haven't gotten the newsletter for today, has anyone else had this issue?

Not...

I believe so, since you can connect to any version of SQL Server using ADO.NET. I haven't done it and don't currently have an environment to try it...

I wouldn't expect you to get anything back form TRACESTATUS that you didn't already know about. I'm checking all my resources to see if I can find anything about...

First you need to determine if you have a good candidate for a clustered index. Check out Kimberly Tripp's blog for this. Here's the last post, http://www.sqlskills.com/BLOGS/KIMBERLY/post/The-Clustered-Index-Debate-again!.aspx in group...

Why did you run this? Running this will only get you trace flags set for the current session. If you wanted to all trace flags...

The only resource I can find that mentions this lock type is this and it says:

I'd love to be able to give you more than...

If you are calling the stored procedure and using parameters then you wouldn't need to escape the single quotes, just have the parameter types set correctly. I can't recall...

Select * from sys.databases where is_encrypted = 1 returns no rows?

If a single database is encrypted using TDE then tempdb is encrypted.

No, and it's funny you should ask about him because I was thinking of asking the same thing.

After the destination

Here's an article on how...

codebyo (3/19/2012)

---

Hi, Jack.

Great suggestions there!

But why do you need to use an IF block?

Wouldn't this work as well?

UPDATE inventory

SET Sold = Sold + 1

WHERE FlightNumber =...

Brandie Tarvin (3/16/2012)

---

Run in terror. I am back!

Book 2 of Latchkeys, The Ugly Little Bloke by Robert Greenberger is out. Links are below.

Preview the book at http://www.crazy8press.com/2012/02/24/preview-the-ugly-little-bloke/%5B/url%5D.

Buy the book on...