Thanks a lot for replying !!!

You guys mean to say upon purchasing the MSDN Licensing , they gonna provide me some credentials and based on them i need to...

But the problem is my replication synchronization job is getting failed . Message comming is : The process couldnot deliver update at the Publisher .Try Rebuilding indexes and in MSDN...

I have just checked that system table " sp_mergecleanupmetadata" is excessively large. Is this could be the reason for this failure ???

There is no space on the server to take backup. Moreover its a prodcutin server , so restart is not permitted

Can you please help remodifying the query using any of the above mentioned recommendation.

It would be great help !!!

Hi Chris

Count for 2and 3rd column are not getting correct. for qty_tested,qty_failed

Hi Chris

With this i am not getting correct results for qty_tested , dty_failed. Counts are different.

Thanks a lot for ur help Chris !!!1

One error i am getting with your code :

Invalid column name 'error_code'.

Hi Chris : Below is code as required :

Instead of sub queried , even if i reference the view name . The performance is still the same !!!!!

sbv

Hi Chris

Below is the code for test_resultt_view :

Service_nocharno6 no

salespsncharno8 yes

Recordintno410 0 no

Auto_closebitno1 ...

error is that the database backup is not schedule through the maintenance plan...

i am using following steps...

1) ight click on db maintenance plan and select new maintenance plan..

2) after that i select the db's

3)then i click next,next...

4) in specify disk backup directory...