Home > Archive > MS SQL Server New Users > November 2005 > changes in msde triggers, and procueders









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author changes in msde triggers, and procueders
Sam

2005-11-10, 11:23 am

how can i make changes in msde triggers, and procueders
at the user machine as msde dosn't have develop tools?

can i do it with the connected access application?
if yes how?

thanks



Jens

2005-11-12, 11:23 am

I would suggest scripting them out in a text file and applying them
with OSQL.exe (a command line tool) which is installed in the BINN
Directory of the client). OSQL has a switch -i where you can specify a
input file. Remember to include the DROP statement before you CREATE a
new object in your Script (Or use the ALTER command). An Example for
calling the commadn line tool is

OSQL -E -iC:\testscript.sql

HTH, Jens Suessmeyer.

Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com