- 论坛徽章:
- 0
|
For question 2:
Create a dummy table and try to turn on identity_insert for the dummy table - if identity_insert is already on for the session, the resulting error message will identify the table.
1> create table test (x numeric(12,0) identity)
2> go
1> create table dummy (x numeric(12,0) identity)
2> go
1> set identity_insert test on
2> go
1> set identity_insert dummy on
2> go
Unable to 'SET IDENTITY_INSERT' for table 'dummy' because IDENTITY_INSERT or IDENTITY_UPDATE is already ON for the table 'test' in database 'tempdb'.
You can also use dbcc pss to find it.
For question 3: sp_configure |
|