Home Forums Article Discussions Article Discussions by Author Discuss content posted by Ken Simmons Sync All Logins on a Server in a single click using SP_MSForEachDB RE: Sync All Logins on a Server in a single click using SP_MSForEachDB
Ken Simmons
SSCertifiable
Points: 7822
More actions
June 3, 2008 at 8:07 am
#823626
It looks like the formatting gets messed up when you cut and paste. This is what I got when I cut and pasted.
INSERT into ##TempSyncEXEC sp_msforeachdb @SQL (incorrect)
Make sure the line reads...
INSERT into ##TempSync
EXEC sp_msforeachdb @SQL