August 13, 2008 at 7:08 pm
Hi ,
I need urgent help with the issue i am having when creating a role
I had to drop User login in SQL 2000 from database
Now when I am trying to create the role again it is giving me error'
The error message is:
incorrect syntax
role already exists
The script I am trying to run is:
create role rolename
authorization dbo
appreciate all your replies !!!!!
Thanks!
August 14, 2008 at 7:34 am
A role and a login are 2 different things. If you dropped user Jack from the database and Jack was a member of the role Jack, you did not drop the role Jack from the database, so you can't recreate it.
I think you want to add a user not a role.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
August 14, 2008 at 11:12 am
hey Jack Thanks for reply
actually I had to drop a user but it was not allowing me to do that.
So i was tryng get around this problem by dropping a role and now I want to add that role back and all it says is syntax error
August 14, 2008 at 2:36 pm
If you are really using SQL Server 2000 then you should get a syntax error because Create Role was added in 2005. I think in 2000 it was sp_addrole, but I am not sure.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
August 14, 2008 at 2:46 pm
thanks jack! Yaah dats rite
sp_addrole worked!
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply