Ali Saad
asked on
SET IDENTITY_INSERT ON
Hello
for some sync reasons ... i've create a trigger for Insert on a specific table and i need need to insert the same data in other database
the problem is sql server not allow to use
SET IDENTITY_INSERT ON to refer a tble in other database
how i can do that
for some sync reasons ... i've create a trigger for Insert on a specific table and i need need to insert the same data in other database
the problem is sql server not allow to use
SET IDENTITY_INSERT ON to refer a tble in other database
how i can do that
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Unrelated to your problem and in case you were not aware SET IDENTITY_INSERT requires the following permissions:
This requirement, in most shops, disqualifies its use in any user code.