By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,304 Members | 3,172 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,304 IT Pros & Developers. It's quick & easy.

Triggers Won't Script

P: n/a
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
Share this Question
Share on Google+
1 Reply


P: n/a
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.