Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
sqlfresher2k7
Aged Yak Warrior
623 Posts |
Posted - 2007-08-02 : 10:11:26
|
I need to create a Database(DDL),DML implementation scripts..Is below scripts is the correct way of creating database for the implemenation.Since i am not including the creation of primary ,transaction file since i dont know the path of user servers..IF EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE name = N'TESTDB')DROP DATABASE [TESTDB]GOCREATE DATABASE [TESTDB] |
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-02 : 23:32:46
|
It'll create db in default location on the server. |
|
|
sqlfresher2k7
Aged Yak Warrior
623 Posts |
Posted - 2007-08-03 : 09:51:07
|
Thanks rmiao !!What are the issues if it creates the database in default location.Please help me in writing the scripts to create the database on the user specified path. Thanks for your help in advance |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-03 : 11:29:31
|
Can you take user specified path as parameter and use it in the statement? |
|
|
|
|
|