>Hi Cetin
>
>Tnx Again for your help!
>I have managed to copy users from one db to another through a dts package that accepts a parameter.
>
>I have also created a login screen but the problem is that i can logon to sqlserver with the same username and password more than once. Is there a way to check if a user has already logged in before i execute an sqlconnect() command?
>
>Tnx in advance
>Anthi
If he's logged in than he also has an active connection ? If so use that one.
Honestly other than that I even don't know where to get that info manually from SQL server using enterprise manager. If you know you could use SQL-NS or SQL-DMO to query it.
Cetin