Extract logins default db - SQL Snipplr Social Repository

Revision: 12754

at March 26, 2009 13:26 by pollusb

Initial Code

select 'exec sp_defaultdb '''+ name + ''',''' + dbname + '''' from syslogins
where dbname is not null

Initial URL

Initial Description

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

Initial Title

Extract logins default db

Initial Tags

login

Initial Language

SQL