Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
nomadsoul
Yak Posting Veteran
89 Posts |
 Posted - 2006-12-10 : 02:24:32
|
| I'm a bit new to the Admin scene but I did this:SELECT * FROM sysuserswhich of course gave me the results from my sysusers table perfectly.So I looked for this table and could not find it. Where is it?Thanks.Using 2005 ExpressIt is better to be prepared and not have an opportunity than to not be prepared and have an opportunity |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2006-12-10 : 03:43:45
|
quote:
So I looked for this table and could not find it. Where is it?
That is because it is not actually a table...it's a system view defined in the master database.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
nomadsoul
Yak Posting Veteran
89 Posts |
Posted - 2006-12-12 : 11:23:39
|
| Thanks, sorry to reply so late. I value your helpIt is better to be prepared and not have an opportunity than to not be prepared and have an opportunity |
|
|
|
|
|
|
Find all users and roles