Posted By

pollusb on 03/26/09

Tagged

Viewed 609 times

Favorited by 0 user(s)

/ Published in: SQL

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

Expand | Embed | Plain Text

Copy this code and paste it in your HTML

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

Comment:

You need to login to post a comment.