|
|
|
Ошибка при добавлении роли при помощи SQLDMO
|
|||
|---|---|---|---|
|
#18+
Подскажите, кто-нибудь, почему я получаю следующую ошибку и как её избежать: Microsoft SQL-DMO: [SQL-DMO]This object is already in a collection. SQLServer.LoginSecure = True SQLServer.LoginTimeout = 10 SQLServer.Connect "(Local)" Set SQLLogin = CreateObject("SQLDMO.Login") Set BaseUser = CreateObject("SQLDMO.User") SQLLogin.Name = "HTTP" SQLLogin.Database = "HTTP" SQLLogin.SetPassword "", LCase("HTTP") SQLServer.Logins.Add SQLLogin BaseUser.Name = "HTTP" BaseUser.Login = "HTTP" SQLServer.Databases("HTTP").Users.Add BaseUser SQLServer.Databases("SES").Users.Add BaseUser SQLServer.Databases("HTTP").DatabaseRoles("db_owner").AddMember "HTTP" SQLServer.Databases("SES").DatabaseRoles("db_owner").AddMember "HTTP" Set SQLLogin = Nothing Set BaseUser = Nothing ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 09.06.2006, 15:34 |
|
||
|
|

start [/forum/topic.php?fid=60&fpage=277&tid=2165736]: |
0ms |
get settings: |
9ms |
get forum list: |
11ms |
check forum access: |
3ms |
check topic access: |
3ms |
track hit: |
54ms |
get topic data: |
10ms |
get forum data: |
2ms |
get page messages: |
44ms |
get tp. blocked users: |
1ms |
| others: | 237ms |
| total: | 374ms |

| 0 / 0 |
