Forum Replies Created

Viewing 3 posts - 1 through 3 (of 3 total)

  • RE: Server Registration via SQL DMO

    What is the exact error you are getting?

    Can you create trusted connection registrations to those servers individually (through Enterprise Manager)?

    --Glenn

  • RE: Server Registration via SQL DMO

    Does it register any servers, or does it crash on the first pass?

    Try re-declaring the dmoRegServer for each server, and dmoServerGroup for each group.

    Set dmoServerGroup = Wscript.CreateObject("SQLDMO.ServerGroup")

    ...

  • RE: LIKE Pattern Matching

    Do you want to explicitly check each portion? If not, you could just use one LIKE pattern to get your results:

    DECLARE @ID CHAR(12)

    DECLARE @CharPattern CHAR (96)

    ---SELECT @ID = '40065*0â007d'

    SELECT...

Viewing 3 posts - 1 through 3 (of 3 total)