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 |
|
lilinikco
Starting Member
28 Posts |
 Posted - 2010-09-22 : 03:42:20
|
| hi all.how to create script all trigger that exist in data base already?lili@@ |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-09-22 : 03:52:59
|
| SSMS can generate a script of all triggers in a database (provided they are not encrypted) |
 |
|
|
lilinikco
Starting Member
28 Posts |
Posted - 2010-09-22 : 03:58:58
|
| SSMS returns error and can't create script.by a store procedure help me plz.lili@@ |
|
|
|
Transact Charlie
Master Smack Fu Yak Hacker
3451 Posts |
Posted - 2010-09-22 : 04:03:23
|
| And the error returned was?????And you tried exactly????Charlie===============================================================Msg 3903, Level 16, State 1, Line 1736The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2010-09-22 : 06:41:37
|
quote:
Originally posted by lilinikco
SSMS returns error and can't create script.by a store procedure help me plz.lili@@
Did you try "Generate Script" feature from SSMS?MadhivananFailing to plan is Planning to fail |
|
|
|
lilinikco
Starting Member
28 Posts |
Posted - 2010-09-26 : 06:06:31
|
| SSMS return this error:"Exception of type 'System.OutOfMemoryException' was thrown"how do I do?plz help me.lili@@ |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2010-09-27 : 04:02:37
|
| Perhaps you are "out of memory"???Try generating the script for a single table. If that's OK try a few tables. If that's OK then do them in batches. |
|
|
|
|
|
|
script all trigger