Posted By

pollusb on 03/26/09


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.