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 |
|
ccrespo
Yak Posting Veteran
59 Posts |
 Posted - 2007-10-01 : 07:43:21
|
| I keep getting the following error when updating through a view in enterprise manager: "Insufficient key column information for updating or refreshing" Has anyone had this error before? |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-10-01 : 07:51:51
|
| Fixed in SQL2000 SP4, are you running an earlier Service Pack?Kristen |
 |
|
|
ccrespo
Yak Posting Veteran
59 Posts |
Posted - 2007-10-01 : 13:42:29
|
| No Im running SP4 and I have a primary key on that table its update. Any other suggestions? |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-10-01 : 14:40:10
|
| "I have a primary key on that table its update"Just to clarify: On the JOINED table?Actually, for that matter, it would help eliminate that if you have PKs on ALL the tables that are involved in the Query.Kristen |
|
|
|
|
|
|
Insufficient key column information