But the same happens every time you update ?

Also there is no BEGIN END pair on the IF UPDATED ?

Sorry I think you have to re-write the entire thing.

Start by disabling all indexes except cluster and PK then do your thing and post back.

I am sure 13 indexes on 7 column table is just wrong.

massoud.karimzadeh (2/19/2009)

---

Hi when I run the following trigger , I get an error (cited below).

Please let me know how to fix it.

Thanks.

USE [Performance]

GO

/****** Object: Trigger [dbo].[trgInsHSBCNetEPM1]...

You got that right! 😀

The only example I have "seen" such application is here[/url]

Personally I think this feature is "fragile" at best and that you are a lot better off applying post snapshot scripts...

you could use xp_delete_file and forget about all of that 😉

You can't get rid of the primary log file nor the primary data file.

For the log just back it up and issue the appropriate alter database statement

For the data move...

You can also separate the checks into parts and don't run checkdb at its full:

For example run it once with physical_only then do the checktables next time then checkalloc and...

Can't you just Right Click on the Replication Folder and Run "Configure Distribution"?

What does it has to do with replication ?

Why so many DBs?

You surely have a lot of contention on tempdb!

swmsan (2/19/2009)

---

Dear All,

I am told that database can be maximum size of 4GB.

Suppose I have 5 databases. so each database can be of 4GBs..?...

Why a Trigger and not a job?

Why even store that value if it can be calculated?

Can you be more specific on what are you trying to accomplish?

(There are > 13 indexes in for this table)

Now, That's a problem!

I like it!

I use Ubiquity (a lot) on Firefox.