Thanks a lot

Grant Fritchey (3/14/2011)

---

If the goal is to identify which servers or databases have a failed backup, instead of running reports, I'd suggest taking a look at setting up Policy Based...

Thanks for your reply.

I need script for report that shows backup completed.

If there is no backup (i.e Log, Differential). It suppose to display Servername, Database name, Max(backup_finish_date), Max(backup_start_date) .

But in...

LutzM (1/12/2011)

---

It also might help to preaggregate the tables commonly used in both UNION statements (e.g. using a temp table, maybe even a CTE will help) as well as considering...

Hi Gill,

I have tried with Update statistics as well but result is same.

Please let me know if you have any idea that i can try with.

Thanks

I have attached execution plan for both with SP and with Query.

It showing one missing index on both, i have tried creating missing index on both, but getting the same...

Thanks Cold Coffee

It works for me.

Gail i am going try your view as well.

Greately apprecite your help

Hi Raunak

Can you please elaborate the steps?

I have to truncate the table2 and insert into table 2 from table1. As that regular task.Data will be replicate from Production server to Development.

Here is the table definition.

I have also attaches sample data for Subscription.

Table 1 : Subscription

Columns :...

Thank you very much.

That was cool like your name ColdCoffee.

Greatly appreicate your help.

😀

Hi Dave

Yes it is a Red Gate backup.

Do you think so it might happen because of expiry of Red Gate?

Anyway i go the solution, i have declare variable twice.

Thanks a lot

Sorry, there are two triggers

Here is the one i am getting error.

Create Trigger TR_TestSmorgasbord_U on TestSmorgasbord for Update NOT FOR REPLICATION as

if (@@RowCount = 0) return

declare @AtDateTime datetime,

@LogOperation tinyint,

@UserName...

Jeferrey

Thanks for such a great explanation. Greatly appreicate your help