var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: users do not appear in sys.sysusers
i'm using sql server 2005
as an 'sa' i wrote a script that created about 100 logins and users for a previously created database as follows:
grant create table, create view, create function, create procedure, create default to public
exec sp_addlogin 'username','password','dbName','us_english'
exec sp_grantdbaccess 'username'
afterwards i login as several different users and do all sorts of operations on dbName.
when i log in as an 'sa' and execute the following query:
select uid, name from sys.sysusers
only 3 users from the previously created ones are in the result set.
does anyone know how can i get all the users to be in sys.sysusers?