Posted By

pollusb on 03/26/09


Tagged

login tsql migration admin defaultdb codegen


Versions (?)

Extract logins default db


 / Published in: SQL
 

Extract logins default db settings from one server to export to another

  1. SELECT 'exec sp_defaultdb '''+ name + ''',''' + dbname + '''' FROM syslogins
  2. WHERE dbname IS NOT NULL

Report this snippet  

You need to login to post a comment.