how do I create new SQL 2005 instances??

[=?Utf-8?B?Um9nZWxpbw==?=]

hey, I wanted to programatically create a different instance on my local
computer instead of
(local)\SQLEXPRESS

I want the user to be able to type in an instance, and it will be created. I
've been reading about SMO, and although it can create tables, it can't
create instances.

how would one go about doing this?

thanks.

[=?Utf-8?B?SHVzYW0gQWwtQScnYXJhag==?=]

hi,
check the following link:
http://msdn2.microsoft.com/en-us/lib...0(SQL.90).aspx

Regards,
Husam Al-Aáraj
www.aaraj.net
"Rogelio" wrote:

hey, I wanted to programatically create a different instance on my local
computer instead of
(local)\SQLEXPRESS

I want the user to be able to type in an instance, and it will be created. I
've been reading about SMO, and although it can create tables, it can't
create instances.

how would one go about doing this?

thanks.

[=?Utf-8?B?Um9nZWxpbw==?=]

thanks for that but I want to know how to do it in CODE, in visual studio, in
C#.

any help is appreciated.

"Husam Al-A''araj" wrote:

hi,
check the following link:
http://msdn2.microsoft.com/en-us/lib...0(SQL.90).aspx

Regards,
Husam Al-Aáraj
www.aaraj.net
"Rogelio" wrote:

hey, I wanted to programatically create a different instance on my local
computer instead of
(local)\SQLEXPRESS

I want the user to be able to type in an instance, and it will be created. I
've been reading about SMO, and although it can create tables, it can't
create instances.

how would one go about doing this?

thanks.

[=?Utf-8?B?UGV0ZXIgQnJvbWJlcmcgW0MjIE1WUF0=?=]

SqlConnection conn = new SqlConnection("server=(local);uid=sa;pwd=yourpass" );
SqlCommand cmd = new SqlCommand("CREATE DATABASE
MYCOOLDATABASE", conn);
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();

-- Peter
Site: http://www.eggheadcafe.com
UnBlog: http://petesbloggerama.blogspot.com
Short urls & more: http://ittyurl.net


"Rogelio" wrote:

hey, I wanted to programatically create a different instance on my local
computer instead of
(local)\SQLEXPRESS

I want the user to be able to type in an instance, and it will be created. I
've been reading about SMO, and although it can create tables, it can't
create instances.

how would one go about doing this?

thanks.

[=?UTF-8?B?QXJuZSBWYWpow7hq?=]

Peter Bromberg [C# MVP] wrote:

SqlConnection conn = new SqlConnection("server=(local);uid=sa;pwd=yourpass" );
SqlCommand cmd = new SqlCommand("CREATE DATABASE
MYCOOLDATABASE", conn);
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();

That is a new database not a new server.

Arne

[PS]

"Rogelio" <Ro*****@discussions.microsoft.comwrote in message
news:5E**********************************@microsof t.com...

hey, I wanted to programatically create a different instance on my local
computer instead of
(local)\SQLEXPRESS

I want the user to be able to type in an instance, and it will be created.
I
've been reading about SMO, and although it can create tables, it can't
create instances.

how would one go about doing this?

Are you looking to create an instance that will be used by multiple users or
just by the user that creates it? A regular instance needs to be installed
from the SQL Server setup. If you are wanting an instance that is for the
local user only then you can look at User Instances which may fit your
requirements.

PS

[=?Utf-8?B?Um9nZWxpbw==?=]

Are you looking to create an instance that will be used by multiple users

yes

>A regular instance needs to be installed from the SQL Server setup.

really? theres no way to do it in code?