Are the 2 schemas the same? Indexes, statistics? ...

No.

Here is the start up:

-dC:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\master.mdf;

-eC:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Log\ERRORLOG;

-lC:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\mastlog.ldf

Has there been a definitive resolution to this? I just started getting the same error message. The SQL box is a VM with 8gb memory SS2K8R2 Enterprise...

O'Brien

Lewis

Tom

Ed Wagner (10/29/2013)

---

Luis Cazares (10/29/2013)

---

If you're looking for ideas, this phrase by Jeff Moden might help you.

First step towards the paradigm shift of writing Set Based code:

Stop thinking about...

The simple answer to this problem is you are already performing an INSERT EXEC which is in the stored procedure you are calling, just as the error indicates.

Kurt

Gossamer Albatross

OTF (10/29/2013)

---

Ed Wagner (10/29/2013)

---

If you haven't been tasked with fixing the problem and are also the new guy, be careful. While you sound like you can and should bring...

This might be helpful.

http://timlaqua.com/2009/09/determining-how-long-a-database-will-be-in-recovery-sql-server-2008/

PRR.DB (10/29/2013)

---

muthukkumaran Kaliyamoorthy (10/29/2013)

---

PRR.DB (10/29/2013)

---

Hi All,

I have taken full backup of database yesterday(with Recovery Model=full ) from sql 2005

and taken differential backup today 5PM(IST)

now i am restored the full...

.. I guess my post might have been somewhat confusing... I will use temp tables, table variables, CTEs where the are the best based upon a number of things...

There is a lot of information available regarding TEMPDB. One of the best sources outside of SSC is snooping around TECHNET or MSDN. I found this article that...

What I've done is leave my folders uncompressed and invoked the database backup compression. However I'm just finishing up a backup/transaction archival process that moves my backups from their...