Hey Vampire,

I'd be interested in looking at that code! You could either eMail it to cstrong@kingston-technology.com

Or better still, maybe you could post it as a script for everyone...

Some of the things I do on a daily basis are...

Check DB's (space/size/growth)

Check Disk Space

Monitor Performance during busy periods (this is because I am after an upgrade of hardware!)

Performance Tuning...

Yes, you can run a trace using Profiler. It should be in your SQL Server application menu. If you can't find it, go to Start => Run and...

Almost forgot about this one.

Every column on the table will allow NULLS and there are 8 columns that are varchar type.

It still stumps me this one. We have not...

I have heard of this issue. From what I remember, the reorg tool in SQL Server 7 does not function correctly. When pages are freed up via deletion,...

Is your log file set for automatic growth? As you insert into your log it will continue to grow. If this is the reason, then allow sufficient space....

Hmmm I use Crystal against SQL 2000 with no issues in speed and my server is nowhere near as powerfull as yours..!

Couple of idea's...

1) If you execute the queries from...

Guess...

CREATE TRIGGER MyTrigger ON MyTable

AFTER UPDATE

AS

IF UPDATE(ColumnA)

BEGIN

--Code

END

That should fire the trigger after the UPDATE has been applied to the base table.

Never used the AFTER parameter, so I assume this will...

You can use BCP to output tables to flat files. However, as I not played with BCP too much, I'd say check out BOL...or maybe someone else can give...

That sounds like a good place to start for both data & log files. If of course you notice them filling up too quickly you can resize them manually...

Staightest answer you'll ever get!! hehe

I'd go for two statements within a transaction. That way either they both complete or none complete.

Clive Strong

clivestrong@btinternet.com

Agree with racosta. I prefer to give the data & transaction log plenty of space and if they need resizing, doing it out of hours. Fortunately, we don't...

I was going to suggest the same as Greg with regards to a SP within the trigger.

However, can a trigger be disabled?! Maybe I missed something but I figured...

Is the series of hashes in the text file itself?

If so there is a workaround within the transformation iteself.

Open up the DTS and double click on the transformation arrow between...

As prakash mentioned, you could use dynamic sql.

There is a topic in this forum (from today) called "Dynamically create tables". This should point you in the right direction to...