Wrox Home  
Search P2P Archive for: Go

  Return to Index  

sql_language thread: Stored procedure to change default database?


Message #1 by Ludwig Brandon-FBL017 <Brandon.Ludwig@m...> on Thu, 18 Oct 2001 12:22:11 -0400
I know there are stored procedures to add logins, grant logins, grant
access, etc. But, is there one specifically to just change the default
database? I have numerous servers where a specific SQL login exists-but the
default DB needs to be changed. Can I do this without recreating the user, &
using a built in SP? 

Thanks!

Brandon Ludwig
Brandon.Ludwig@M...



  Return to Index