Heh, I missed that, Steve. Though technically...

Greg (6/27/2008)

---

below is the trigger but when trying to execute it I get an error telling me "deleted.projectpriority" could not be found. Any help would be great.

ALTER TRIGGER [dbo].[u_priority]...

Can you post the Query that it is based on?

Search & Replace. It's Ctrl-H in most editors.

Yes, and please post your query. It seems very likely to me that you can transform your query from a series of Select's to a single select over aggregated...

Yes.

Have you partitioned the table?

You should probably exclude tables LIKE '%_Obsolete%'.

1. Table-locking? that depends on how you do it.

2. Best way: that depends a lot of the FTP files format/layout. Please post that plus some sample data.

I face this problem quite often with the procedure text that I read and script out from SQL. The solution that I came up with was to parse it...

dwagnon (6/27/2008)

---

The information is being gathered by a program that will write to the SQL database. For programming that script, it is much easier to have all DATABASE saves...

GilaMonster (6/27/2008)

---

<Shudder>

Fortunatly I don't think anyone here's...

Pretty much, jeff. I haven't been jumping in because work has been pressing the last few days...

Also, are your Service Packs up-to-date?

Please post the query and the query plans.