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 |
|
glennh
Starting Member
2 Posts |
 Posted - 2006-02-20 : 13:06:13
|
| Hi All,I just installed MSDE on my desktop, I'm using Windows Only authentication and I connected through enterprise manager as such (i.e. not as sa). I'm given access to SQL server via an external team and I guess they have me in a global group.Can someone tell me why I can't see an entry in sysxlogins for myself and yet I can login and create a database as myself?thanksGlenn. |
|
|
TimS
Posting Yak Master
198 Posts |
Posted - 2006-02-20 : 13:13:05
|
| You are most likely a member of window group BUILTIN\Administrators this makes you a sysadmin by default.Tim S |
 |
|
|
glennh
Starting Member
2 Posts |
Posted - 2006-02-20 : 13:54:06
|
| The SID against the database I created was different to the Built in Administrator one, and when I do a select suser_sname() it shows my user not the administrator.Glenn |
|
|
|
|
|
|
sysxlogins record not available