firstly why you need to create index on system tables for CDC , it may not be relevant .

Secondly yes you can create index on system tables

Something below will help to find relveant information .

SELECT SUM (internal_object_reserved_page_count) AS internal_pages ,

( SUM (internal_object_reserved_page_count) * 1.0 / 128...

Re boot the box , try installing from command prompt

Have you explored the option of CTE .

Have you tried SQL profiler including the execution plan

and also you can add object id of that specific index in the filter .

Aboslutely , thanks alot Sean !

Try this :

http://www.mssqltips.com/sqlservertip/1620/how-to-setup-and-use-a-sql-server-alias/

Run the below and paste the results .

Select * from sys.dm_clr_loaded_assemblies

select * from sys.dm_clr_task

Most of the CLR issues causes due to memory spike, .net DLLs supporting SQL to run...

MyDoggieJessie (7/8/2013)

This was my original thought. Perhaps...

We used the below script to set the replication . I am wondering even stopping the distribution job some batch of transactions was still in progress can cause...

Thanks a lot it worked 🙂

Hi ,

I changed the security context and tried it fails again . any other pointers please .

even with local its failing : --

The complete code is :

-------------------------------------------------------------------------------------

create Proc [dbo].[usp_ReplicationLatency_n]

as

...

same error replaced local with servername/instance

the distribution server is named istance ... xxxx/dist1..

All linked server looks good