Thanks all for the response.

The primary database is a heavily transactional OLTP database for a Shipping-System. Currently, the database is serving 2 major purposes: 1- routine shippping/scanning etc, and 2-...

Linson.Daniel (11/1/2009)

---

Then again....would someone tell me why would I go about generating scripts like the way that was shown when SQL server itself provides all the necessary options to create...

Select datalength(object_definition(669622570))

returns only 28700 - might be for this object with above ID.

But when I display the value of

Select object_definition(669622570)

It just gives me the first few lines from the stored...

.. All fine... but Why do I need OBJECT_DEFINITION(1234567) there...?? Is this to create the stored proc back?

If so, it may not be possible as the function OBJECT_DEFINITION(1234567) returns...

Thanks a lot guys!

The code already had the "delete" statement inside a transaction. So actually I had selects inside of the transaction - till the time transaction was running -...

Sandy,

Appreciate your reply. But it was just a type while writing the code here in forum.

I dont have that comment in code. it was just to explain here in forum.

Any...

No - Its like thta:

I am making a call to Proc X. Inside Proc X I have a cursor, with which, I get all the necessary parameters to be passed...

The problem doesn't seem to be solving yet. I am overwriting the database, while restoring.

But Still I am getting an "internal inconsistency check" erorr.

Please guide me, what could be...

Yes 'Animal Magic' , you precisely hit the problem. Server X has Databases' logical names 'Sales' and 'ABCCom'. And Server Y has the name 'Sales'. When I will backup Y.'Sales',...

I don't want to destroy/modify any of the databases on server 'X'.

I just thought of a cumbersome solution and could be better explained with normal maths (or, rather C language...