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 Administration (2000)
 Getting an error while using sp_adduser in Sql6.5

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-09-20 : 09:17:20
vipin writes "Hi,
I need ur help on a problem which iam not able to solve for a long time. the problem is like this........
Iam using sql6.5 as my database. And iam adding users using the command sp_addusers...like
sp_addusers 'vipin '
What is happening is that the space after the name are considered as special characters and an error syaing that invalid characters exist is shown.
I tried to set the ansi_padding to off. But even that does not work.
This happens only in Sql6.5.The same sp_addusers works perfectly fine in Sql7.0, wherein the blank spaces after the name are trimmed off. Cant i do the same thing is sql6.5

Pleaseeeeeeeee help
Bye"
   

- Advertisement -