Removing all linked servers that start with 'ls'

• Quinn-793124

  SSCrazy

  Points: 2785

  More actions

  December 15, 2008 at 2:48 pm

  #195042

  I need to drop 50 linked servers that all start with 'ls'.

  I am wondering if I can do something like

  exec sp_dropserver @server = ls*

  Thanks

  Quinn

• Mr James Howard

  Ten Centuries

  Points: 1158

  More actions

  December 16, 2008 at 10:02 am

  #913280

  http://support.microsoft.com/kb/203638

  James Howard

• Quinn-793124

  SSCrazy

  Points: 2785

  More actions

  December 16, 2008 at 1:23 pm

  #913432

  That did it James.

  Thanks

  Quinn

• Mr James Howard

  Ten Centuries

  Points: 1158

  More actions

  December 17, 2008 at 4:31 am

  #913690

  excellent, glad to help 😀

  James Howard