The only way of discovering the limits of the possible is to venture a little way past them into the impossible.

— Arthur C. Clarke               

PracticeBetter provides relevant, timely information for law firms and legal technology consultants.

 

twitterIcon
Follow us on twitter

 

Subscribe to our news feed


 

Inside Time Matters: Orphanded Database User

There is a longstanding urban legend that makes "moving a Time Matters Database" sound like a "super geek" task. I think what throws most folks off is the old requirement to "run the Orphaned User Script" that TM Support used to propagate. Truth be known, Rob Cordani and I developed that script over eight years ago for SQL Server 7. Time and SQL Server have changed... time to dispel the myth.

It can be as simple as:

 EXEC sp_change_users_login 'Auto_Fix', 'tm9user'

For more details see the Microsoft TechNet article.