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 |
|
oidldb
Starting Member
2 Posts |
 Posted - 2010-08-18 : 08:07:32
|
| Hi,I have a table in SQL Server 2000 that has a trigger that only allows me to update one row at a time. But i want to update all the rows in the table and i can't remove the trigger. How can i do that without writing 10.000 updates? It's urgent. Please help!Thanks in advance, Dani |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2010-08-18 : 08:21:57
|
| you cannot remove the trigger but can you disable it?--------------------keeping it simple... |
 |
|
|
oidldb
Starting Member
2 Posts |
Posted - 2010-08-18 : 08:37:20
|
| THANK YOU! THANK YOU! THANK YOU!I began creating a script using cursors but this is much better. |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
|
|
|
want to update all rows in tame each one at a time