以编程方式创建新的SQL Server登录名 [英] Creating new SQL Server Login programmatically

问题描述

请帮助我！

->我要以编程方式创建新的sqlserver登录名.我自己的数据库未创建
在此服务器中.
->如何编写程序以达到此目的.
->希望您的回答.

谢谢大家.

Wynne C

Please help me!

->I want to create a new sqlserver login programmatically. My own database is not create
in this server.
->How can I write program to acheive this.
->I hope your answer.

Thanks all.

Wynne C

推荐答案

http://www.google.com/search?q=C%23+Create+SQL+Server+登录 [

http://www.google.com/search?q=C%23+Create+SQL+Server+Login[^]

Google shows plenty of results.

Declare @LoginName nvarchar(100)
Declare @Password nvarchar(100)
Declare @SQL nvarchar(max)
Begin
    Set @LoginName = 'TestAdmin'
    Set @Password = 'pass@word1'
    -- Create user
    Set @SQL = 'Create Login ' + @LoginName + ' with Password = ''' + @Password + ''''
    EXEC sp_executesql @SQL
    -- Adding user to sysadmin role
    EXEC sp_addsrvrolemember @LoginName, 'sysadmin'
    -- This will give you list of SQL Users
    select * from sys.sql_logins
End

这篇关于以编程方式创建新的SQL Server登录名的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！