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.
| Author |
Topic |
|
Ozzi
Starting Member
5 Posts |
 Posted - 2005-08-26 : 04:20:26
|
After I try creating a new login and confirm password, I get this msgbox: quote:
error 2812: could not find stored procedure 'sp_addlogin'
How can I solve this?Thanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-08-26 : 13:03:03
|
| Call it with the three part naming convention: master.dbo.sp_addloginTara |
 |
|
|
Ozzi
Starting Member
5 Posts |
Posted - 2005-08-29 : 04:51:26
|
| I am not adding the user by writing a stored procedure, so I can't use the three part naming convention. Unless I can specify it from another place? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-08-29 : 12:47:38
|
| Just because you aren't writing a stored procedure doesn't mean you can't use the three part naming convention. Did you even try it?Tara |
|
|
|
Ozzi
Starting Member
5 Posts |
Posted - 2005-09-02 : 02:51:44
|
| There is something I forgot to say! Which is the sp_addlogin is missing from the Master DB (stored procedures) ....We have a local server and an online server. It is missing from the online server. Do you think we can copy sp_addlogin from the local to the online without causing any problems? |
|
|
|
Thrasymachus
Constraint Violating Yak Guru
483 Posts |
Posted - 2005-09-02 : 08:51:13
|
| just how did you do this? I would use the code but rename the query master.dbo.sp_addlogin2.====================================================Regards,Sean Roussy"pimpin ain't easy, but someone has to do it" -- Pimpin Whitefolks(?) |
|
|
|
Ozzi
Starting Member
5 Posts |
Posted - 2005-09-07 : 03:50:08
|
| Yes this is exactly how I intend doing it. Thanks. |
|
|
|
|
|
|
New Login Error