I'd recommend you set up some VMs (VMWare Player is free for non-commercial usage iirc), set up clustering, set up Availability Groups, set up Mirroring (one at a time) and...

Sean Lange (10/27/2014)

---

Was just going to say there is a Mexican market there that is really good. They should have plenty of choices for dried peppers. There is a really...

Statements and execution plans?

And prod needs to be read-write and to accept schema and data changes? If so, those data changes need to sync back to dev?

Mirroring wouldn't have worked anyway, the mirror...

Edit: ...

You're moving the prod database somewhere else and want something to automatically redirect requests made to dev to go to prod instead?

http://www.sqlservercentral.com/articles/Indexing/68636/

That should answer most of your questions.

Create two temp tables. Insert the results of SP1 into one of them, insert the results of SP2 into the second, then write a query that joins them on whatever...

Never tried SQL Server with the Windows Live logins, I configured my win 8 box to use a local machine login instead.

Can you find the latest errorlog file and look...

Look at the last 5 lines of what you posted. You're calling the procedure itself there. There's no check for how many times it calls itself (nor any obvious reason...

Is the service running?

What error do you get?

Without seeing the procedure, hard to say anything specific. You're getting the error because the procedure is calling itself (recursive). SQL limits recursive calls to 32 levels deep.

Take a look...

Section 2: https://www.simple-talk.com/sql/backup-and-recovery/the-sql-server-instance-that-will-not-start/

Find the latest SQL error log. Post it here (all of it)

Ref: https://www.simple-talk.com/sql/backup-and-recovery/the-sql-server-instance-that-will-not-start/

CASE WHEN office_id ('1126','1127','1128','9999') THEN 'Yes' ELSE 'No END as ID_Exists

Shouldn't be related to CheckDB, it makes no changes to the DB and you're not backing up the snapshot, you're backing up the source DB

Did you have long-running uncommitted transactions...