469,347 Members | 1,864 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,347 developers. It's quick & easy.

Triggers Won't Script

I'm trying to generate scrips for a database, and everything so far has
worked fine, except for the triggers. When I try and script existing
triggers, all I get is a blank file - no SQL script. I tried single
files for each object, all in one file, triggers only, the entire
database. I can't figure it out, but I know the triggers are there.

Any suggestions, or am I missing something undocumented in SQL-Server
2000?

Jul 23 '05 #1
1 1573
I think in Enterprise manager you need to have the tables selected to script
out the related triggers.

I use DBArtisan myself, where Triggers can be managed seperately.
<ti********@cciw.ca> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.com...
I'm trying to generate scrips for a database, and everything so far has
worked fine, except for the triggers. When I try and script existing
triggers, all I get is a blank file - no SQL script. I tried single
files for each object, all in one file, triggers only, the entire
database. I can't figure it out, but I know the triggers are there.

Any suggestions, or am I missing something undocumented in SQL-Server
2000?

Jul 23 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

7 posts views Thread by Sjaak van Esdonk | last post: by
1 post views Thread by jason_s_ford | last post: by
4 posts views Thread by Mark Flippin | last post: by
4 posts views Thread by Eduard Witteveen | last post: by
2 posts views Thread by Omar Vazquez | last post: by
2 posts views Thread by the other john | last post: by
3 posts views Thread by rick | last post: by
reply views Thread by zhoujie | last post: by
1 post views Thread by Marylou17 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.