Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
enak
Starting Member
34 Posts |
 Posted - 2005-03-08 : 11:41:14
|
| I have a table that has an identity column which is indexed. I was able to insert new rows into the table until I reset the identity column by deleting it and then recreating it again.Here is the error that I get when i try to insert a new record:"Server: Msg 8102, Level 16, State 1, Procedure T_tblCalendar_ITrig, Line 7Cannot update identity column 'EventID'."I have checked the permissions and they are ok.Any ideas?Thanks,enak |
|
|
TimS
Posting Yak Master
198 Posts |
Posted - 2005-03-08 : 11:43:56
|
| Verify that you are NOT using SELECT *Verify that you are using column list in the SELECT/INSERT statements.Tim S |
 |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2005-03-08 : 12:32:03
|
| Maybe if you post the code and the table ddl....Brett8-) |
|
|
|
|
|
|
I get this error and I can't get rid of it.