Posted by primalcortex on February 21, 2008
Well as you may know I’m amnesiac… So this post is for me to remember how to relink an database user into the database server again.
The stored procedure of SQL Server that does that is: sp_change_users_login…
Check out this MS page: http://msdn2.microsoft.com/en-us/library/ms174378.aspx
Posted in Geral, Micro$oft | Tagged: restore, SQL | Leave a Comment »
Posted by primalcortex on November 15, 2007
Just a quick note:
The SQL Server command select * from master..sysprocesses shows the linkage between the Windows Process and SQL Server Process (SPID).
This useful if you want to kill the SQL command without kiling the Windows process.
By the way, the column is hostprocess for the Windows process id.
Posted in Micro$oft | Tagged: SQL, server, SPID, PID | 1 Comment »
