asked
sysuers in SQL 2008 R2
select * from sysusers where issqlrole=1 When run this statement in SQL 2000 by using both Windows Authentication and SQL Authentication the results will be same. But using this in SQL 2008 R2, the SQL Authentication gives few results and Windows Authentication gives the same result as SQL 2000. Please help with this.
The `sysuser` Microsoft SQL Server 2000 system table is included as a view for backward compatibility only. Start using `sys.database_principals` instead in SQL 2005+ environment.
3 People are following this question.
