Results 1 to 3 of 3

Thread: Creating an SQL SERVER DB on a remote computer

  1. Nov 6th, 2002, 10:17 PM #1
    Arc
    Arc is offline

    Thread Starter
    PowerPoster Arc's Avatar
    Join Date
    Sep 2000
    Location
    Under my rock
    Posts
    2,336

    Creating an SQL SERVER DB on a remote computer

    OK i have this app i want to distribute that uses an SQL Server DB. THe users already have SQL Server on thier machine. Once this app is installed on the users machine how i do create a DB in the SQL server?


    Thanks!
    -We have enough youth. How about a fountain of "Smart"?
    -If you can read this, thank a teacher....and since it's in English, thank a soldier.
    Reply With Quote Reply With Quote
  2. Nov 7th, 2002, 02:17 AM #2
    Arc
    Arc is offline

    Thread Starter
    PowerPoster Arc's Avatar
    Join Date
    Sep 2000
    Location
    Under my rock
    Posts
    2,336
    Neeeed help. Thanks!
    -We have enough youth. How about a fountain of "Smart"?
    -If you can read this, thank a teacher....and since it's in English, thank a soldier.
    Reply With Quote Reply With Quote
  3. Nov 7th, 2002, 04:43 AM #3
    London75
    London75 is offline
    Lively Member
    Join Date
    Apr 2002
    Location
    Manchester,UK
    Posts
    94
    Create the database locally and then use enterprise manager to generate the script in one file for creating the database and all objects.

    Then distribute this script with your exe and in the installation use a program that comes with SQL Server called ISQL to run the script.

    Usually : -

    C:\MSSQL7\BINN\ISQL.exe -i <script name>

    Hope that helps.
    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