Home Forums Article Discussions Article Discussions by Author Discuss content posted by Jonathan Kehayias Moving Database Files Detach/Attach or ALTER DATABASE? RE: Moving Database Files Detach/Attach or ALTER DATABASE?

  • September 24, 2010 at 10:10 am

    #1227104

    Mad Myche (9/24/2010)

    I don't get to play with all of the latest sql/os combinations yet (currently 2000 on 2003 server), but could scripting be created to integrate with CLR or Powershell to do the alterDB and the filemovements within a home rolled SProc?

    Anything is possible, but why would you want to? If you used Powershell, just use it from Powershell, why would you want it to be in a stored procedure?

    Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
    My Blog | Twitter | MVP Profile
    Training | Consulting | Become a SQLskills Insider
    Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]