What permissions are required for SET IDENTITY_INSERT ON?
Some older versions of SQL Server documentation were not very precise about the permissions required to change a table's IDENTITY_INSERT setting.
Some older versions of SQL Server documentation were not very precise about the permissions required to change a table's IDENTITY_INSERT setting.
Sometimes, Microsoft's documentation – and the occasional comment in their own code – doesn't inspire a whole lot of confidence.