Results 1 to 7 of 7
  1. #1
    Join Date
    Mar 2004
    Posts
    139

    Unanswered: Realllly fundamental...

    Since I'm new to SQL server I feel like I should be able to ask this with a straight face and without ridicule...

    I'm trying to change the location of log and data files, I have identified a stored procedure that will do this, but neither the book I have nor the Microsoft Knowledge base mentions where to run the stored procedure from...

    From where or what application does one call or execute a stored procedure for admin type tasks???? The article lists command line inputs...but I'm not sure where to run this from.
    Thanks,
    Bill

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Heavens, you can ask almost any question around here with a straight face. We occaisionally get some real doozies!

    Ridicule is generally reserved for the awesomely lazy louts trying to get us to do their homework, and a fair degree of abuse between those of us that hang out here... With the homework exception, we rarely abuse people before we get to know them.

    To answer your question, the easiest stored procedure that will allow you to move the data/log files around in my opinion is sp_attach_db and the corresponding sp_detach_db. They can both be executed using the SQL Query Analyzer.

    How'd I do ?

    -PatP

  3. #3
    Join Date
    Mar 2004
    Posts
    139
    You did great, thanks for the help!
    Thanks,
    Bill

  4. #4
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    What a stupid answer, Pat.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  5. #5
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Quote Originally Posted by blindman
    What a stupid answer, Pat.
    Well duh

    -PatP

  6. #6
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Oh, now you've started something buster. It's on.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  7. #7
    Join Date
    Apr 2004
    Location
    Kansas City, MO
    Posts
    734
    You guys really shouldn't do this. This is a professional forum and we need to maintain a level of integrity and professionalism corresponding to the seriousness of this environment.

    ((I can't believe these idiots!!!!!!))
    MeanOldDBA
    derrickleggett@hotmail.com
    When life gives you a lemon, fire the DBA.

Posting Permissions

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