Is there a way to check of IDENTITY_INSERT is ON OR OFF

Is there a way to check of IDENTITY_INSERT is ON OR OFF? Is there a view to check the status of it?
almask-mnAsked:
Who is Participating?
 
macentrapCommented:
HI
you cannot  check status of IDENTITY_INSERT is ON OR OFF
0
 
parthmalhanCommented:
write a tablename in sql server management studio

select its name and press ALT+F1

all the properties including identity column will be displayed.

Refer the following snapshot.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.