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.
asked Feb 16 '12 at 11:52 AM in Default
answered Feb 16 '12 at 12:17 PM