home articles news code blog links search  
 
         
  Code Samples

Articles and Presentations

sqldbatips.com blog

changeloginmode

Author Jasper Smith
Created 29-07-2004
Updated 29-07-2004
Requests 271
DescriptionThis stored procedure changes the login mode of a SQL2000 or SQL2005 instance to Mixed or Windows depending on the parameter passed in. It wraps a call to xp_instance_regwrite that makes the required registry change. Useful for MSDE 2000 and SQL2005 Express Edition which currently has no graphical management tool.

Revision History

Author
Date
Description
Jasper Smith
29-07-2004
Initial Creation

View Code Download Code
 
         
© Copyright sqldbatips Ltd 2008. Contact webmaster home | news | articles | code | blog | links | search  

free tracking