Hi friends,

I have a query which is correctly working in sql 2000 generate permission error in sql2005

Query:

If not Exists (select * from sysusers where name='jometuser')
Begin
EXEC sp_adduser @loginame='jometuser',@name_in_db='jometuser'
EXEC sp_addrolemember N'db_datareader','jometuser'
EXEC sp_addrolemember N'db_datawriter','jometuser'
End
GO

I run this query logged as a user having permission 'db_owner'

SQL 2005 generates error:

Msg 15247, Level 16, State 1, Procedure sp_adduser, Line 35
User does not have permission to perform this action.

please help to identify the problem or suggest an alternative way to do the same.

Thanks,