anushahanna
asked on
sysusers & syslogins in R2?
are these views still in R2 with the same columns as in 2000?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
OK- but plain sysusers itself will fail in R2..? how about 2008? if you have that version, could you please try it for me and let me know...
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
the reason i ask is i will be sending code to someone who has R2, just wanted to confirm if sysusers will work or complain in 2008 and R2..
ASKER
in 2005,
both of the following are valid:
select * from dbo.sysusers
select * from sys.sysusers
how about 2008 & R2- does it have the 'dbo' ownership view?
both of the following are valid:
select * from dbo.sysusers
select * from sys.sysusers
how about 2008 & R2- does it have the 'dbo' ownership view?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
>>Yes. the dbo still exists in 2008 and 2008 R2
that's good to know- thanks for confirming it..
>>why don't you build your code with sys.database_principals rather than sysusers? ;)
Surely would like to, once we get rid of the 2000 environment- till then preferred to keep one query across all environments, when possible.. (not my choice)
that's good to know- thanks for confirming it..
>>why don't you build your code with sys.database_principals rather than sysusers? ;)
Surely would like to, once we get rid of the 2000 environment- till then preferred to keep one query across all environments, when possible.. (not my choice)
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks very much - that is a great idea.
I use VirtualBox for virtual machines.
it's free from oracle..it's such a great product
http://www.virtualbox.org/
it's free from oracle..it's such a great product
http://www.virtualbox.org/
ASKER
http://msdn.microsoft.com/en-us/library/aa260592%28SQL.80%29.aspx
in other words, would
select * from sysusers bring back records in R2?