using SQL SERVER 2K
I have registered a server that sits on TestServer\TestInstance and I have a
bunch of Database and table creation scripts... but I didn't think it was
possible to run something like the following unless it was run from that
actual machine (while at the machine or TermServed in or in some way remotel
y
controlling the box )
Create Database MYDB on(name=N'MYDB_DATA',
filename=N'E:\SQLDATA\MYDB_DATA.MDF,...)'
I know that I can use EM to visually create each database and then script
the tables, but the scripted option would be nice and quick.Kevin,
Connect via Query Analyzer or OSQL to the TestServer\TestInstance and run
the create database script.
HTH
Jerry
"kevin" <kevin@.discussions.microsoft.com> wrote in message
news:4257D77D-4BC8-44C9-B69C-7BD9F2793E7D@.microsoft.com...
> using SQL SERVER 2K
> I have registered a server that sits on TestServer\TestInstance and I have
> a
> bunch of Database and table creation scripts... but I didn't think it was
> possible to run something like the following unless it was run from that
> actual machine (while at the machine or TermServed in or in some way
> remotely
> controlling the box )
> Create Database MYDB on(name=N'MYDB_DATA',
> filename=N'E:\SQLDATA\MYDB_DATA.MDF,...)'
> I know that I can use EM to visually create each database and then script
> the tables, but the scripted option would be nice and quick.
>|||Jerry,
I actually did that just before I begin this post, went to the john and
strolled my slow ass back and it finally completed in 15:54. This explains
why it was failing from VS, it was timing out.
"Jerry Spivey" wrote:
> Kevin,
> Connect via Query Analyzer or OSQL to the TestServer\TestInstance and run
> the create database script.
> HTH
> Jerry
> "kevin" <kevin@.discussions.microsoft.com> wrote in message
> news:4257D77D-4BC8-44C9-B69C-7BD9F2793E7D@.microsoft.com...
>
>
Tuesday, February 14, 2012
Create Database on Remote server specifying a path
Labels:
2ki,
abunch,
create,
creation,
database,
microsoft,
mysql,
oracle,
path,
registered,
remote,
scripts,
server,
sits,
specifying,
sql,
table,
testinstance,
testserver
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment