March 18, 2005 at 8:13 am
Login Name contains -. We purchased a software package that runs on SQL 2000. The Login Name was created by the vendor as vendor-user. I cannot delete this login because it contains the - sign. I went into enterprise manager and deleted it. It appeared to remove it. It no longer displays the login name in enterprise manager but it is still there.
I have tried SP_DropUser (vendor-user) and it does not work. Does anyone have any idea on how to remove it from the database.
March 21, 2005 at 8:00 am
This was removed by the editor as SPAM
March 21, 2005 at 4:06 pm
Hi,
Join the club! Some time ago I had to work with the database where the name contained a -
I had to enclose the name in [ ] all the time. Did you try that in code?
I just tried to create a login vendor-user, add it as a user to Pubs, drop user and then drop login using sp_addlogin, sp_adduser, sp_dropuser and sp_droplogin. I used [vendor-user] for parameters. It worked without problems this way on my computer.
Yelena
Regards,Yelena Varsha
March 22, 2005 at 7:21 am
Thanks for your suggestion, after trying it I have a different problem. When I use SP_DROPUSER [Vendor-Name] it tells me that the user is not in the database. When I go into security to add the user to the database, I get a message that the user already exists in the database. Do you have any suggestions on how to correct this problem?
March 22, 2005 at 8:56 am
Hi,
do this in Query Analyzer and post here both result sets.
If you are not comfortable posting company data then send me a message by clicking on the link with my name and there clicking a link "Send a Private Message..."
USE YourDatabaseName
SELECT name, SID from sysusers where name like 'vendor%'
USE MASTER
SELECT name, SID from syslogins where name like 'vendor%'
Regards,Yelena Varsha
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply