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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Changing database login using SQL

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-03-23 : 12:58:38
Nate writes "We are developing an application which creates new databases "on the fly".

I understand how to create a new database using SQL, but I need to know how to create a login for each new database. I notice the database I created uses "sa" as the login with a blank password.

What we want to do is create aunique login for each new database we create using a SQL stmt. We are using SQL Server 2000.

Thanks."
   

- Advertisement -