Hi Dave,
I understand that your application used osql.exe to create the database and
you have three questions on the ownership of the created database now:
1. How to query (in .NET 2.0) if the database is with mixed authentication
mode?
2. How to get a list of all users?
3. How to create a user?
If I have misunderstood, please let me know.

For your three questions and even your creating database function, you can
fully resolve the questions by using the SQL Server SMO component for .NET
2.0.
1. You can just create a Server object like this:
//Server Name
string strConn = "(local)";
//Instantiate SMO Server Object
Server svr = new Server(strConn);
Console.Writeline(svr.Settings.LoginMode.ToString());

2. To get the list of all users, you can use:
   Database db = server.Databases["your_db_name"];
   UserCollection users = db.Users;

3. To create a user, you can use:
   //Instantiate SMO Login object
   Login l = new Login(svr, loginName);

   //If Login doesn't already exist
   if (!svr.Logins.Contains(loginName))
   {
    //Login should be of type Sql Login
    l.LoginType = LoginType.SqlLogin;
    //Create the Login on the SQL Server with password: pa$$w0rd
    l.Create("pa$$w0rd");
    //Add the login to the sysadmin role
    l.AddToRole("sysadmin");
    }
    //Instantiate a new database object
    Database db = new Database(svr, "Fizoo2");
    //Make SQL Server create the database
    db.Create();
    //Instantiate a new User object
    User u = new User(db, "SQL_Login_user");
    //associated it with the login "SQL_Login"
    u.Login = loginName;
    //Make SQL Server create the user
    u.Create();

For more information, you can refer to the following references:
User Privileges View & Create User Tool
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=840637&SiteID=1

How to: Create a Visual C# SMO Project in Visual Studio .NET  
http://msdn2.microsoft.com/it-it/library/ms162129.aspx

How to: Modify SQL Server Settings in Visual Basic .NET  
http://msdn2.microsoft.com/en-us/library/ms162131.aspx

If you have any other questions or concerns, please feel free to let me
know. It is my pleasure to be of assistance.

Sincerely yours,
Charles Wang
Microsoft Online Community Support

======================================================
When responding to posts, please "Reply to Group" via your newsreader
so that others may learn and benefit from this issue.
======================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================

It is SERVER property not a databases
SELECT SERVERPROPERTY('IsIntegratedSecurityOnly') AS
[IsIntegratedSecurityOnly]

EXEC northwind..sp_helpuser

Create Database mydb
go
use mydb
go
sp_addlogin 'mydbuser','monitor','mydb'
go
sp_adduser 'mydbuser'
go
sp_Addrolemember 'db_datawriter','mydbuser'
go
sp_Addrolemember 'db_datareader','mydbuser'
go

Hi David,
I am afraid that the database may have some synchronous problem now. Our
yesterday's replies cannot be seen from Web and we also cannot see your
replies.
So I post it again from Outlook Express and hope you could see it now. Sorry
for bringing you any inconvenience.

I understand that your application used osql.exe to create the database and
you have three questions on the ownership of the created database now:
1. How to query (in .NET 2.0) if the database is with mixed authentication
mode?
2. How to get a list of all users?
3. How to create a user?
If I have misunderstood, please let me know.

For your three questions and even your creating database function, you can
fully resolve the questions by using the SQL Server SMO component for .NET
2.0.
1. You can just create a Server object like this:
//Server Name
string strConn = "(local)";
//Instantiate SMO Server Object
Server svr = new Server(strConn);
Console.Writeline(svr.Settings.LoginMode.ToString());

2. To get the list of all users, you can use:
   Database db = server.Databases["your_db_name"];
   UserCollection users = db.Users;

3. To create a user, you can use:
   //Instantiate SMO Login object
   Login l = new Login(svr, loginName);

   //If Login doesn't already exist
   if (!svr.Logins.Contains(loginName))
   {
    //Login should be of type Sql Login
    l.LoginType = LoginType.SqlLogin;
    //Create the Login on the SQL Server with password: pa$$w0rd
    l.Create("pa$$w0rd");
    //Add the login to the sysadmin role
    l.AddToRole("sysadmin");
    }
    //Instantiate a new database object
    Database db = new Database(svr, "Fizoo2");
    //Make SQL Server create the database
    db.Create();
    //Instantiate a new User object
    User u = new User(db, "SQL_Login_user");
    //associated it with the login "SQL_Login"
    u.Login = loginName;
    //Make SQL Server create the user
    u.Create();

For more information, you can refer to the following references:
User Privileges View & Create User Tool
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=840637&SiteID=1

How to: Create a Visual C# SMO Project in Visual Studio .NET
http://msdn2.microsoft.com/it-it/library/ms162129.aspx

How to: Modify SQL Server Settings in Visual Basic .NET
http://msdn2.microsoft.com/en-us/library/ms162131.aspx

If you have any other questions or concerns, please feel free to let me
know. It is my pleasure to be of assistance.

Sincerely yours,
Charles Wang
Microsoft Online Community Support

======================================================
When responding to posts, please "Reply to Group" via your newsreader
so that others may learn and benefit from this issue.
======================================================

======================================================