Server Migration Checklist II

Posted by merrillaldrich on SQL Blog See other posts from SQL Blog or by merrillaldrich
Published on Fri, 23 Apr 2010 05:18:08 GMT Indexed on 2010/04/23 5:43 UTC
Read the original article Hit count: 382

Filed under:
Easy Breezy Login Audit for your Ol’ 2000 Server In the last post on this topic I put up the preparatory steps I’ve been using for server migrations. Here I am posting some code that has worked well for us to trace who/what is connecting to our older SQL Server 2000 machines. It’s a simple audit of login events, tracing the login name, host name, database, and last login time for connections to the server, and gave us valuable insight into who was really using the machines and which databases might...(read more)

© SQL Blog or respective owner

Related posts about migration