472,141 Members | 1,383 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,141 software developers and data experts.

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 1667
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 leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.