Check the size of the transaction log (using Enterprise Manager, right click on the database/Properties/Transaction Log.  Check the size of the data file as well.

If the log is of a...

Make sure you have a "guest" user in both databases.  If it's missing, just add him (or her as the case may be 🙂

I believe that you'll be in violation of license if you use a single processor license on that machine.  I don't think that you can restrict SQL Server to use...

I think the guy wanted you to answer in writing so that he could take the answer to the guy who wrote the question to see if it was correct. ...

Here's the cursor code in case you need it (you shouldn't)  Change the table names in the code from newtable and oldtable to the real names.

declare @signonid int

declare c cursor...

I just thought of an easier way.

insert into newtable

(BranchID,emplID, Signin_Date, Member_Name, Member_No, Gender, empl_Pickup_Time, empl_Complete_Time, Reason1, Reason2, Reason3,Remarks, "Appointment?", Appointment_emplID)

select

BranchID,emplID, Signin_Date, Member_Name, Member_No, Gender, empl_Pickup_Time, empl_Complete_Time, Reason1, Reason2, Reason3,Remarks,...

Ok, before I create the code, please try the following on the table.

update query set signon = signon + 125000 (or change 125000 to any number you prefer)

Let me know...

Sorry, I steered you wrong on the update of the identity column, it can't be done.  If you send me the list of columns for your table, I'll send you...

I just read your post more carefully.  With column name "signon" then the proper syntax is:

set identity_insert dbo.query on

update dbo

there's a space on your SQL for the column "identity signon"  The query should be:

set identity_insert dbo.query on

update dbo