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.

 All Forums
 General SQL Server Forums
 Database Design and Application Architecture
 sql server on XP & concurrent multi windows logins

Author  Topic 

pristine
Starting Member

1 Post

Posted - 2011-10-27 : 14:28:29
Hi.

I have a question and could not find the answer on google (maybe i do not know how to ask it!)

I have SQL Server 2000 on Windows XP SP3. (no network. Just a local database)

Is it possible to connect to my sql database from multiple concurrent windows user profiles (accounts)?

like : connect to a sql database, then do a fast user-switch and login via a different windows user and be able to connect to the database.

Does it work? Doesn't it corrupt the database.

Thanks in advance.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-10-27 : 19:42:23
Yes you can have multiple threads. No it would not corrupt the database.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -