title: IDENTITY INSERT ON/OFF on an entire database
body: <p>I have a script that I need to run that has values that needs to be inserted everywhere there is null values in columns. for this to happen I need to set IDENTITY_INSERT OFF on the entire database. At the end of the script IDENTITY_INSERT needs to be switched on again. Is there a statement that can be used to set IDENTITY_INSERT ON/OFF over an entire datebase or is it only possible to do each table separately?</p>