Post reply

Running Scripts

  • March 15, 2011 at 1:56 am

    #236748

    Hi Good Morning All, is it possible to write a stand-alone script using sql server 2005 or 2008. For example i have one of my staff using sql server 2005 in another location, i want to send a script to him which he double clicks and all the script does is to insert a particular value into a table in the database. I know the servername as well as the database name. Please is there a way to go about this?

    Thanks

    Timotech

  • March 15, 2011 at 4:39 am

    #1298747

    you could use the sqlcmd command line utility from within a .BAT file, presuming the user has permissions to do whatever DML you want the script to do.

    http://msdn.microsoft.com/en-us/library/ms180944%28v=SQL.90%29.aspx

    ------------------------------------------------------------------------
    Bite-sized fiction (with added teeth) [/url]

  • March 15, 2011 at 4:47 am

    #1298750

    Thanks so much the link you provided gave a lot of insights, i'll work on it and let u know of any challenges.

    Thanks

    Timotech

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply