It would be helpful to see the actaul SP. Try adding -O (that is a capital O as an additional parameter to the osql call. That option prevents...

Without seeing the entire script I can only give a suggestion rather than a solution. First I would talk with the DBA/Developer of the SP and see if you...

It would be more helpful to see the Stored Procedure definition then the manner in which it is executed. Do you have the ability to edit the Stored Procedure?...

I'm glad I was not the only one who didn't agree with any of the answers. The only viable one was over budget. I choose answer #5 (i.e...

It's possible from a good backup, or within a transaction with Rollback 🙂

James.

What kind of summary, totals per day?  Totals per week? List of records per day?  A example table, data and the report output would be most helpful.  Otherwise lookup date...

A little more information would be helpful.  The structure of the table and a couple of test records would be even more helpful.  From your initial request a simple select...

Your probably right, it would be like trying to backup a database this is in the process of being restored.  Doesn't make much sense.

While I can't duplicate your situation easily...

Have you tried Backup and Restore operations.  After restoring to the DEV machine you could run sp_removedbreplication.  This is a lot slower than Detach and Attach but might work.

I'm an curious...

Partitioning is "like" having multiple tables, only they are transparent to the front end.  The database will handle accessing the correct table based on the data that is being added/edited/deleted. ...

I have not experimented with your exact scenerio but since you can copy the database file and logs from the Standby machine to the Development machine I would assume your...

While your premise is wildly unrealistic and does not take into account many "real" inventory questions I will answer the very specific question at the end of the post:

"Is it...

Yes you are correct SQL 2000 does not have those capabilities.  Sorry about that, I didn't pay close enough attention to the category before answering.

James.

I doubt anyone is going to be able to help if you don't post the table definition, some sample data and the criteria you would use to do the deletes...

You need SQL 2005 for this, but the following accomplishes what you want:

--This just create a table like your "Borrower" table (only in memory)

declare @borrower_ table (caseid_ int, borrowerid_ int)

--Populate...