Post reply

Create a database on a remote SQL Server

  • October 16, 2009 at 10:58 am

    #212391

    Is it possible to create a database on a remote SQL Server? If so, how?

    I've setup a linked server, but the system doesn't like the syntax.

    create database <linked server>.<database>

    Doesn't like the period.

    TIA!

    Brian

  • October 16, 2009 at 11:57 am

    #1067085

    i may be wrong, but i thought a linked server only allows DML (data manipulation and no DDL; you can't create a temp table, nor use the "SELECT... INTO NewTable...FROM" syntax on a remote server for example, but you can call a procedure which creates a temp table.

    I'd assume the same would be true for creating a database...create a procedure on the remote server which creates a database would work.

    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!

  • October 16, 2009 at 12:04 pm

    #1067089

    Thank you, Lowell!

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply