Results 1 to 4 of 4
  1. #1
    Join Date
    May 2004
    Posts
    3

    Unanswered: Creating Log file & Attaching db?

    Bit of a SQL newbie, having taken over a support role for a piece of software that my firm sells. It is basically a DB that runs on MSDE or SQL Server in either desktop or enterprise scenarios.

    We do sell our software to clients who may or may not already have SQL on their machines. During installation, it searches for sqlservr.exe for existing SQL installations and if it finds nothing, will then install MSDE 1.0 to house the db files.

    My question is this -

    I can manually create a db or manually attach an existing db through sql query analyser where there is a full-blown SQL installation. Is there any way I can do the same where there is only MSDE installed? The simple solution, I guess, would be to download one of the freeware or shareware MSDE "Enterprise Managers", but this won't always be suitable for a client installation.

    Many thanks for your assistance all.


  2. #2
    Join Date
    Feb 2004
    Posts
    492
    you could use sp_attach_db to attach a sqlserver database to sqlserver. Don't know about msde though.

  3. #3
    Join Date
    May 2004
    Posts
    3

    Hmm

    Quote Originally Posted by Kaiowas
    you could use sp_attach_db to attach a sqlserver database to sqlserver. Don't know about msde though.

    Thanks

    Yep, this is what I would use if I was doing it through the SQL. Still wondering about MSDE tho.

  4. #4
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    You can look into SQL-DMO and write up a quick routine that would do the attaching.
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

Posting Permissions

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