Jeff Moden (2/2/2010)

---

GilaMonster (2/2/2010)

---

I realised what he meant. Just the...

I should try that more often 😀

Very funny once again.

Looks like it is CTRL-Q in the doc. However, CTRL-N still works for me.

Here is the list:

http://msdn.microsoft.com/en-us/library/ms174205.aspx

thanks for posting your update.

please don't cross post. Answers and posts should be posted to

http://www.sqlservercentral.com/Forums/Topic855268-338-1.aspx#bm858349

Nature of the device. Lower end SSDs are designed more for the W.O.R.M (write once read many) type of environment. Enterprise class SSDs should have less of a...

That kind of company, they probably all invested in the business too.

What's the catch?

The mdf will need to be restored as Steve suggested.

One other possibility is piecemeal restores - if your database is segmented into filegroups.

AndrewSQLDBA (2/2/2010)

---

Easy way, no, no easy way.

You can create a SQL Script to do that. Drop the Constraint, truncate the table and create the Constraint again. Or you can script...

This link will show you how to do that.

http://msdn.microsoft.com/en-us/library/ms190255.aspx

kstjacques (2/2/2010)

---

I understand those groups were specific to 2005, however, 2008 had equivalently named groups for two of the three groups that I listed so I believe they are still...

looks to be a typo. It could be referring to a credential - but still as typed it would be a typo.

Those are 2005 groups and you will not need them with 2008.