|
llinares
Starting Member
3 Posts |
 Posted - 04/05/2011 : 10:22:30
|
You need to add code to make it do that.
DECLARE @defaultdb sysname
BEGIN
IF (@@fetch_status <> -2)
BEGIN
PRINT ''
SET @tmpstr = '-- Login: ' + @name
-- ADD THIS LINE:
SELECT @defaultdb = dbname from master..syslogins where [name] = @name
PRINT @tmpstr
IF (@xstatus & 4) = 4
BEGIN -- NT authenticated account/group
Then when you set @tmpstr modify it to something like this:
SET @tmpstr = @tmpstr + @CR + 'EXEC master..sp_addlogin ''' + @name + ''', NULL, @defdb = ' + @defaultdb + ', @sid = ' + @SID_string + ', @encryptopt = '
|
 |
|
default database in transfer login script
