Connecting to more Database

Hi ,

We have 10 web sites running and having 10 database stored in same server .
i need to check in all the 10 database that particular id has repated .
if it is repated i should not allow the user the create that id .

as it is we have 100k qry hitting the database per minute .. so have some performace issues .

if i write code to connect all the database is same file . will there be any performance issue .

or is there any other method to do that ...

Quote:

Originally Posted by rashmiks

Hi ,

We have 10 web sites running and having 10 database stored in same server .
i need to check in all the 10 database that particular id has repated .
if it is repated i should not allow the user the create that id .

as it is we have 100k qry hitting the database per minute .. so have some performace issues .

if i write code to connect all the database is same file . will there be any performance issue .

or is there any other method to do that ...

Hi there,

Kindly refer to below attached link. Please do not double post. Take care

Trigger

Connected user list to a sql server database

Hi,
Is there any way to get the list of user names connected to a particular
database? Can any one give me the T-sql statement to get the list of users.
--
VenkatHi
Here is the query
Select Loginame,spid,db_name(dbid) from master..sysprocesses where
db_name(dbid)='dbname'
best Regards,
Chandra
http://chanduas.blogspot.com/
http://groups.msn.com/SQLResource/
---
"Venkat" wrote:
> Hi,
> Is there any way to get the list of user names connected to a particular
> database? Can any one give me the T-sql statement to get the list of users.
> --
> Venkat
>
>