You can't restore a backup from one version of SQL Server. The first time the 2000/2005 database is opened in 2008 the structure is changed and won't be recognised by...

That was the line for me!

I'm...

Normally when driving along, if there's been a nasty accident I just drive past (as long as I can't do anything to help) - I don't 'rubberneck' and slow down...

P Jones (4/22/2010)

---

I've got Japanese Knotweed in the garden and no weed is worse 🙁

The extra strength Roundup 3000 from the local farmers supply store is now winning but it's...

Google "sql server perfmon description". One of the hits is a presentation by Brent Ozar relating to perfmon - http://www.brentozar.com/archive/2006/12/dba-101-using-perfmon-for-sql-performance-tuning/. If that isn't sufficient then Google again.

BrainDonor.

An interesting question. I do like Paul's articles - he invariably provides good examples and explanations.

BTW, the formatting of the answer is a bit rough - it overlaps the answer...

My problem wasn't the CTE, it was the unwillingness...

This kind of thing has been discussed a few times in the past. The basic answer is no, without more work than it is probably worth.

http://www.sqlservercentral.com/Forums/Topic476826-338-1.aspx

http://www.sqlservercentral.com/Forums/Topic643902-360-1.aspx

BrainDonor.

What is the error message?

And is there a reason that you're trying to place the new column anywhere other than on the end?

BrainDonor.

What type of validation do you require? 'ISNUMERIC' and 'ISDATE' spring to mind immediately, but we don't know enough about what you require.

An example of the data would be helpful.

BrainDonor.

Bob the Mushroom (4/13/2010)

---

Speaking as someone who opted for NULL instead of UNKNOWN, that explanation was terrible. Why doesn't NULL mean NULL, and what did empty strings have to...

Funny, yet depressing at the same time.

Why do so few people understand the basic principles behind backups?

DBCC Timewarp, anyone?

BrainDonor

Restore from the latest backup that you have - that's about as current as you'll be able to get.

BrainDonor

You'd be better off posting this question in the certification forum, where I'm sure there'll be opinions aplenty.

I currently have the MS book "Microsoft SQL Server 2008 - Database Development...