Thanks

Enjoy the reading.

The question was worth two points.

How many people only respond in the forum to the question, unless they get it wrong?

When they respond because they got it wrong, they are...

BaldingLoopMan (3/4/2010)

---

heh, If it is scheduled for deprecation - I can't find it.

Maybe I'm being thick, but I am trying to see the connection between truncated data and the quote...

john.arnott (3/4/2010)

---

gaggghhhh... Seven pages of "discussion" and hardly any comments about the core learning opportunity. Did anyone besides me appreciate the mix of a new SQL feature (the CTE)...

Do you have a trigger on the table?

Any database can be set to readonly mode. Readonly means that you can only read from the database.

Standby is typically used in a log-shipping or mirroring setup. The...

Wayne and Amit are correct. Wayne has some additional options for high-availability. There are even more options that can help with high-availability. You should give us what...

ramadesai108 (3/4/2010)

---

This stored procedure and the table definition has been working since the past 2 years. I just scripted the table definition from another database and then created the table...

Are you seeing 0's in your table currently, or are you referring to @@identity returning a 0 during this proc?

According to script and table definition, you should not be inserting...

catamount - what you do with the cat after it becomes 2-d

Jeff Moden (3/4/2010)

---

It's not a common occurance, for sure, but in one company I worked in, there were some remarkable business folks who were actually very good at defining what...

Thanks. I learned something today.

cataclysmic

catatonic

Check out the following

http://blogs.msdn.com/chkoenig/archive/2008/12/01/upgrading-from-sql-2000-2005-to-2008.aspx