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

  • June 3, 2008 at 12:52 am

    #823431

    Looks like your database server is case sensitive (like mine.)

    change SYSNAME to sysname and you should be ok.

    Also sp_msforeachdb will have to become sp_MSforeachdb

    Regards,

    David.