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
 General SQL Server Forums
 New to SQL Server Programming
 default_database

Author  Topic 

joelseverich
Starting Member

34 Posts

Posted - 2010-02-24 : 14:01:47
Hi,
Can any one please explain me how to use the default_database in the 'create login' query?

Kristen
Test

22859 Posts

Posted - 2010-02-24 : 14:06:25
EXEC sp_addlogin @loginame='MyNewServerLoginName', @passwd='MyPassword', @defdb='MyDefaultDataabseName'
Go to Top of Page
   

- Advertisement -