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.

asked Feb 16 '12 at 11:52 AM in Default

Newbie Bala
293 ● 7 ● 11 ● 13

(comments are locked)

1 answer:

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.

answered Feb 16 '12 at 12:17 PM

Sacred Jewel
1.6k ● 2 ● 4 ● 5

(comments are locked)

Your answer

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Follow @Ask_SSC

Follow Ask SSC on Facebook

Find Ask SSC on Google+

Find us on LinkedIn

Topics:

sql-server-2008-r2 x394
login x73

asked: Feb 16 '12 at 11:52 AM

Seen: 412 times

Last Updated: Feb 16 '12 at 12:17 PM

sysuers in SQL 2008 R2

Follow this question

Related Questions