Results 1 to 3 of 3

Thread: SQL Serv 2000 excecute scpripts

  1. Jun 8th, 2004, 03:32 AM #1
    SkyCoder
    SkyCoder is offline

    Thread Starter
    Addicted Member SkyCoder's Avatar
    Join Date
    Oct 2003
    Location
    Moon Crater 25
    Posts
    183

    SQL Serv 2000 excecute scpripts

    Hi all

    I am looking for a way to excecute db scripts whithout using querie analyzer. ie from out vb as im sendinging the the end users that are ussing my app updates on a regular basis to update the database. Is this possible? The perfect senario would be to dump the db scripts into a folder and then from there to excecute them in some event (VB6).
    Reply With Quote Reply With Quote
  2. Jun 8th, 2004, 12:16 PM #2
    axion_sa
    axion_sa is offline
    Frenzied Member axion_sa's Avatar
    Join Date
    Jan 2002
    Location
    Joburg, RSA
    Posts
    1,724
    [SQL Server Install Folder]/Tools/Binn/osql.exe -?
    Reply With Quote Reply With Quote
  3. Jun 8th, 2004, 12:44 PM #3
    techgnome
    techgnome is offline
    PowerPoster techgnome's Avatar
    Join Date
    May 2002
    Posts
    34,687
    alternative....
    Use the SQLDMO object to execute the scripts.

    TG
    * I don't respond to private (PM) requests for help. It's not conducive to the general learning of others.*
    * I also don't respond to friend requests. Save a few bits and don't bother. I'll just end up rejecting anyways.*
    * How to get EFFECTIVE help: The Hitchhiker's Guide to Getting Help at VBF - Removing eels from your hovercraft *
    * How to Use Parameters * Create Disconnected ADO Recordset Clones * Set your VB6 ActiveX Compatibility * Get rid of those pesky VB Line Numbers * I swear I saved my data, where'd it run off to??? *
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width