Home Forums SQL Server 2008 SQL Server 2008 Administration Can we Create sql server instance through script? RE: Can we Create sql server instance through script?

  • July 23, 2013 at 5:19 am

    #1634881

    via TSQL, the best answer is no, you cannot install a new SQL instance via TSQL.

    it has to be done from the operating system side, with the example parameters supplied above, as a .cmd or .bat file, or simply inline in a cmd window.

    there are edge cases, where if you are running the right user for the SQL service, you could call xp_cmdshell and it might work, but it's not worth the trouble to track down all the errors and issues to make it work.

    additionally, it is exceedingly rare you need to install additional instances if you already have an instance in place, so I'm wondering what the real issue is on this question.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!