PDA

View Full Version : How to create a Database trigger thru Script ??



sreeramg
07-31-2002, 04:01 PM
hi,

I am setting up a SQL Database thru Install Script. I need to create triggers in the SQL database thru the Install Script. Can anyone throw some light on this ?

How to create a trigger in the Database (SQL 2000) ??

TIA
-sre

pattikay
08-13-2002, 08:53 AM
This is how I ran SQL scripts using InstallShield:

Generate all the required scripts in Enterprise Manager, and save them into one or more .SQL files, as needed.

- Create .BAT files that call these .SQL files using OSQL.EXE (See BooksOnline for OSQL input parameters). This assumes that client tools are installed on the machine where setup is being run.

- Call these .BAT files from Installshield project, using the scripting interface. Installshield setup collects the server name, login, password etc. at run time and passes these as parameters to OSQL.EXE