sp_addlogin - SQL Server Forums

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)

sp_addlogin

Author

Topic

reddymade
Posting Yak Master

165 Posts

Posted - 2006-02-10 : 13:39:42

I am trying to do the following: Can you please tell me which is which:

ChatEngine is it database

What is Company

What is ChatUS


sp_addlogin 'ChatEngine', 'Company', 'chatUS'
GO

Thank you very much for the information.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2006-02-10 : 13:50:37

Please look up sp_addlogin in SQL Server Books Online. It will show what each parameter is.

Tara Kizer
aka tduggan

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2006-02-10 : 19:11:46

Refer to Books Online

sp_addlogin
Creates a new Microsoft® SQL Server™ login that allows a user to connect to an instance of SQL Server using SQL Server Authentication.

Syntax
sp_addlogin [ @loginame = ] 'login' 
    [ , [ @passwd = ] 'password' ] 
    [ , [ @defdb = ] 'database' ] 
    [ , [ @deflanguage = ] 'language' ] 
    [ , [ @sid = ] sid ] 
    [ , [ @encryptopt = ] 'encryption_option' ]

or use sp_help on sp_addlogin in master

use master
go
sp_help sp_addlogin

----------------------------------
'KH'
everything that has a beginning has an end

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources