As manoj said, query is more efficiant than sp_who or sp_who2

select spid, status, loginame, hostname, blocked, db_name(dbid), cmd from master..sysprocesses where db_name(dbid) = 'yourdb'

Yes...That is TRUE..

GilaMonster is right...

Is windows users are local admins or limited access users..

To transfer Windows and SQL Server Logins use the sp sp_help_revlogin

MS KB http://support.microsoft.com/kb/246133

Hey

This is the script for you.

OSQL -E -S [SQL Instance Name] -n -i [path ..c:\] >> c:\resutls.txt

The above script use Windows authentation and connectes to the sql server...

that is best option, I do the same thing...

🙂

That is right, you should have Visio Professional Edition to get the ERD.

Yes, There is a software called ER-Win

This software will connect to the database and will generage the ER diagram. Physical and logical schemas.

let me know if you...

I believe you can implement by Implementing Windows Services.

? After 5 invalid logins SQL Server / Windows Login will automatically updated by Deny Access.

Windows Login: I believe you can...

good post, I was not aware of the fact.

You file will not currupt.

Find the sp which is running BCP sp_who, find the status of the particular sp and find the root cause of the problem.

May I know the what sp is doing.

May be the sp is putting the some db's in single user mode.

Hi,

SQL Server Express Edition does not support Merge Replicaiton.

Go thrugh the below URL,

Fetures of SQL Express

http://msdn.microsoft.com/en-us/library/ms165616(SQL.90).aspx

Replication in SQL Express

http://msdn.microsoft.com/en-us/library/ms165700(SQL.90).aspx

as per my understanding, your db backup file does not have the user which is available in the restored database.

script out the users before restore the db and run...

I too agree with the above post...

Thanks all to conclude some point