The last option of maintaining two options and deciding the heirarchy looks pretty good. Thank you for your suggestion.

But for the first work around I tried to put an expression...

Obviously you will get null values in College code until you have a record in College_CutoffCodeTransition with the cutoffid and you cannot insert cuttoffid before you insert data to [College_CutoffMaster].

ie.,...

My operating system is 32 bit and i installed 32 bit upgrade as I do not know what is bit rate does sql server uses either it 32 or 64

No Gail,

I upgraded the same instance on the server.

Pallavi,

I have a couple of questions,

1 . You said there will be only one record for one cutoffid in College_CutoffCodeTransition and cutoffid is identity in [College_CutoffMaster] how...

Hello all,

I have successfully upgraded my sql server database engine from version 10.0.1600 to 10.50.2500 but when i try to open it after my upgrade , the sql server database...

Hello Pallavi,

Replace College_CutoffMaster in the select with INSERTED and see how it works and in the mean time I will look into the issue where you are going wrong.

And I...

Thank You Sean Lange

Ur welcome Pallavi.

Hello Pallavi,

Here is ur cooked item on the plate

ALTER TRIGGER trgAfterInsert ON [dbo].[Employee_Test]

AFTER INSERT

AS

BEGIN

PRINT 'AFTER INSERT trigger fired.'

INSERT INTO Employee_Test_Audit

(Emp_ID,Emp_Name,Emp_Sal,Id,Audit_Action,Audit_Timestamp)

SELECT EMP_ID,EMP_NAME,EMP_SAL,ID,'Inserted Record -- After Insert Trigger.',GETDATE()

FROMINSERTED

WHEREID = 1

END

GO

Please...

Pallavi,

I cannot find any id over there do you mean emp_id.?

Can you be a bit clear on the requirement u want .?

Maddy

Try creating after trigger on the first set of tables and writedown the logic to perform DML operations on the second set with the magic tables Inserted and Deleted it...

I suggest you write down a trigger on the database.

I have tried resotring to the qa envirnment with qa file paths and in the error it is showing the location of the dv environment file paths....

and I deleted...

There are no processes running and the database is not in use i m sure about it.. as a second check i verified too...

I am struck with the similar problem....

The scenario is something like this :

I have two instances of sql server 2008 r2 on the same server...