30 November 2011

In SQL 2008 when we fetch counter articles


In SQL 2008  when we fetch counter articles in Speednet sometimes we may get one error that "Counter Articles not found if your using SQL 2005 please refer readme".

   This error is due to Surface Area Configuration of SQL . To solve this problem please run following query

sp_configure 'show advanced options',1
go
reconfigure
sp_configure 'Ad Hoc Distributed Queries',1
go
reconfigure

No comments: