Creating Sqlserver database from asp.net webapplication

[furqanms]

Hello friends

I want to create sqlserver a database at run-time from asp.net web application. I am using visual studio 2008.Is there any library available in dotnet 3.5 for the same. And also guide me that creating database like this is feasible or not by the point of security.

Waiting for your early response.

Thanking you in advance

[kenobewan]

Hello friends

I want to create sqlserver a database at run-time from asp.net web application. I am using visual studio 2008.Is there any library available in dotnet 3.5 for the same. And also guide me that creating database like this is feasible or not by the point of security.

Waiting for your early response.

Thanking you in advance

Depends on what you mean by a database. You can create tables through stored procedures, for eg. Is it local or remote? This is more of a knowledge question. What have you tried so far?

[furqanms]

Depends on what you mean by a database. You can create tables through stored procedures, for eg. Is it local or remote? This is more of a knowledge question. What have you tried so far?

It is remote web base application. For run-time database creation in sqlserver I have got this 2 namespace SMO and DMO but still dont know how much it secure if the website is going to host on webserver and admin has given control to create database from the site.

[kenobewan]

It is remote web base application. For run-time database creation in sqlserver I have got this 2 namespace SMO and DMO but still dont know how much it secure if the website is going to host on webserver and admin has given control to create database from the site.

Doesn't sound very secure. Ideally, you want database designed on your sqlserver otherwise it may be possible for hackers to use your sqlserver as free storage. Not saying that it can't be done but is it worth it for the time and effort?