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 |
|
iminore
Posting Yak Master
141 Posts |
 Posted - 2005-04-07 : 12:29:15
|
| We've used triggers before without a problem. Now on one db table an insert trigger that just writes to another table (with a literal) is causing problems. In Enterprise Manager normally when you enter a new record that record is displayed, with any defaults. This time the new record is not displayed though you can see it via query analyser and the other table record has been written. This is SQL2000.Any relevant ideas would be appreciated. |
|
|
JimL
SQL Slinging Yak Ranger
1537 Posts |
Posted - 2005-04-07 : 15:01:39
|
| Refresh ?JimUsers <> Logic |
 |
|
|
iminore
Posting Yak Master
141 Posts |
Posted - 2005-04-07 : 15:04:05
|
| We've even tried stopping and starting SQL. |
|
|
|
|
|
|
trigger sort-of locking