It is a very normal setup to use AD accounts when a domain is available. Could you expound on the errors you got?

Either a significant amount of data was deleted or the backup was changed to use compression.

Steve Jones - SSC Editor (3/19/2012)

---

SQLRNNR (3/19/2012)

---

Steve Jones - SSC Editor (3/19/2012)

---

Finally read The Hunger Games on Sat since my son desparately wanted me to read it before the movie...

Nadrek (3/18/2012)

---

My answer to tabs vs. spaces, case convention, and pre vs post commas is always to let a computer do tedious, menial, purely rules based work - use a...

GilaMonster (3/19/2012)

---

The RowLock (or pageLock) hints just say what the locks should start as, nothing more. In this case they'll start as row, but once past the 5000 or so...

obligation

Steve Jones - SSC Editor (3/19/2012)

---

Finally read The Hunger Games on Sat since my son desparately wanted me to read it before the movie comes out. It was pretty good,...

green

SQL Kiwi (2/7/2010)

---

:laugh: Perfect :laugh:

My own view on the whole ISNULL...

Beaker

tempdb is automatically recreated.

Model, you can restore from backup. Alternatively you can copy the mdf and ldf into the appropriate directory

Resource, you need to make sure you have those...

Yes you can. But you should have a backup of that database available so you can bring it back online. Sounds like you are in the middle of...

Fozzy

Create different subscriptions for each email address.

http://technet.microsoft.com/en-us/sqlserver/Video/dd420576

Don't forget the hidden resource database.

I am curious why you are asking?