var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
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 ....
try to use ERROR, if you set IDENTITY ON and it is ON, it generates error....
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 ?