To avoid sqlstatement-length you might consider to use text or ntext datatype for the SQLstmt-column, because when your trigger fails, your transaction fails, so your applications will be affected.

Glad I...

Now the stars point to a participation level. Don't give me a AAA-rating, because all I provide is an option, to the best in my responcetime(frame) and mondaymorning-feeling.

From what I've...

This may get messy but I'll give it a shot.

TEST-it TEST-it TEST-it and use it wizely.

It's still Monday-AM

(don't know if I would use this way in...

are you just trying to use Profiler for troubleshooting or do you want to know at all time which action(s) take place on this table ?

Regarding the sqlserver-table-triggers you could...

if you can live with gaps in these numbers you could use an identity field (check BOL)

You can retrieve the inserted value afterward with SCOPE_IDENTITY()

- you could log it using triggers

I hope you are not trying to run this on a cluster ?

Why don't you generate the osql-line in your job and then xp_cmdshell it ?

(select @sqlcmd = 'osql -E...

- are you sure nobody changed the tablestructure when you were looking at it with EM ? (You will need to refresh the tables-tab) Refreshing at the correct position in...

Whichever way you're going to do this delete-cycle. Remember to provide the propre indexes (FK) to speed it up ! Keep their columns in exact column-order(as defined on the parent-table).

...

Why perform the shrink database if you've truncated the tables and are planning to load ?

build your load-data sorted on the tables clustered index and then load.

you could also put...

1.5 ct

maybe you could try to drop/create the proc with QA at your server ?

This could solve dependant settings (that are stored with the sp)

Edited by - alzdba on 12/16/2003...

- Log Simple does mean it only keeps the log-data until commit is done.

- Maybe index b.recstatus and force the use with hint.

- To keep log-chunks low you could make...

- If you can avoid lock-escalation, do so.

So set a table lock when you start loading.

- You can have autgrowth active, but if you detect space may be allocated during...

correct.

Should be :

CREATE VIEW v_selectarticle

AS

SELECT TOP 100 PERCENT article_id, headline FROM ARTICLES

ORDER BY article_id desc

This is a long shot, but maybe you could download a trial copy of erwin(CA) or another dbcompare-tool, reverse engineer your scripted db and compare it to a reverse engineered...