Hi friends,
I want to know whether IDENTITY_INSERT is on or off through an SQL Statement. Depending on whether IDENTITY_INSERT is ON or OFF i can use SET IDENTITY_INSERT ON or SET IDENTITY_INSERT OFF.
Reply ASAP ...
shanky......ASAP...
try to use ERROR, if you set IDENTITY ON and it is ON, it generates error...
see http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_set-set_7zas.asp
jiri|||Setting identity_insert on only works for a single session that is trying to set identity_insert on more than 1 table is this what you are trying to check ?
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment