Central Management Server vs Linked Server

• balaji.ganga

  SSCrazy

  Points: 2280

  More actions

  June 7, 2010 at 10:58 pm

  #98753

  Dear All,

  I would appreciate, if any body share with me about central management server vs linked server concepts in sqlserver 2008

  Thanks & Regards

  Balaji.G

• Henrico Bekker

  One Orange Chip

  Points: 27652

  More actions

  June 7, 2010 at 11:09 pm

  #1177306

  Linked servers are more used when you have queries running against them (instead of OPENROWSET function)

  read up to get a better and more in depth answer:

  http://sqlserverpedia.com/wiki/Central_Management_Server

  http://www.databasejournal.com/features/mssql/article.php/3085211/Linked-Servers-on-MS-SQL-Part-1.htm

  -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
  This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle