Thanks Daniel,

I may be wrong, but I don't think the data source matters, where the report is deployed is what matters. You could probably deploy a 2005 rdl to a...

Hi,

Thanks man for merging this stuff into one article.

DBA's might already know these Performance Counter and most of them are using them as well but may be not quite often....

Thanks.

http://msdn.microsoft.com/en-us/library/ms188927.aspx

Well the problem was due Active transactions in "log_reuse_wait_desc"

select name, log_reuse_wait_desc

from

sys.databases

Closed the long running transaction, and then try other fix options.

If possible then drop and re-created the replication.

Thanks for your...

Relication Type is "Transactional Replication With Updatable subscriber"

Thats the problem that i am not getting any error in the Replication Monitor however i picked the following error from profiler.

The insert...

Ok Now to run the Distribution Agent again, as i understood for BOL

that i stopped and restarted "Repl-Distribution" category job

this job has 3 steps

1. Distribution agent startup message

2. run...

Please confirm again

"How to run the Distribution Agent or the Merge Agent"?

Thanks.

Hi Chris,

Sorry for early conclusion but you done a great job as well.

Chris, Mark and Jeff .... you people have shared some real exceptional work.

I really enjoyed this.

thanks for...

Thanks Jeff, Mark and SQLRNNR for providing such a great ideas. Real Champs!!!

Cheers

Sorry for late reply.

Thanks MARK's for the query. Excellent work!!!! great idea.

Yes I accept that idea came to mind from TSQL challenge 67. Thats why i have added my initial...

Additional Double quotes in the generated string was creating problem.

Thanks everyone for viewing.

WoW 😀 but Red Gate ..... Are you serious:w00t:? OR its a serious 10 points Joke?

Well lets see who is that lucky...

Excellent! yes it works. However, the next proble is sheet names in the same workbook.

They appears as sheet1, sheet2,sheet3.....

But with one individual report and export it actualy gives the...

No transaction.

No this will not stop log-shipping at all.

You can use sys.dm_dm_index_physical_status to rebuild specific index, only if avg_fragmentation_in_percent is more than 30.

Put that in job and split the index rebuild...