Thanks you.

We are not update with service packs. We are planning to apply the latest service pack. I hope it will solve the problem

Thanks you so much for your time.

I didn't understand fully. Please give me some more detailed explanation.

What are the access violations means? Is there any relation to this violations and...

Exception Address = 00000000777E105C Module(ntdll+000000000005105C)

2015-06-17 13:59:18.56 Server * Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION

2015-06-17 13:59:18.56 Server ...

Thank you

Please confirm

If one of the query started executing and we create index that query finish without index

First time there was no dump files but in second crash there were some dump files with access violation

We have planned hardware migration in 2 months so don't want apply SP3 now

Sorry wrong place.

The instance is Sql server 2008r2 standard edition with sp2

No I am talking about the dumpfiles

declare @dump int

select @dump= count(1)

from (SELECT * from sys.dm_server_memory_dumps

where cast(creation_time as date)=getdate() ) xx

IF @dump >...

Hi,

When we can create new index.

One of my table in subscriber db requires new index. The table in subsciber db always be in use for Reporting.

Is it ok to create...

Is there any way to get notify from sql server when the dump files are getting created?

If we add any new views in publisher db and I want to replication to subscriber, how can we do it?

Is it require adding those views as articles and take...

We didn't configured for mirroring. Only transactional Replication setup

Any suggestion on this issue!

I am getting still same errors and replication is failing.

Do I need to follow the below process even in sql 2008r2

http://www.replicationanswers.com/fti2005.asp?

I don't have clean backup.

The same database has in two servers. I run dbcc checkdb allow dataloss in one server, where we are using currently the database. We are getting...