I don't recommend that you get in the habit of downloading entire tables.  It may only have 10,000 records today, but a year from now, how many will it have. ...

Triggers serve best as methods to maintain low level data integrity that cannot be done through standard relational methods.  The inactivation of a major site, for example, should via trigger...

Everyone's talking differences, and they are all good points, but one very important similarity:  the "rules" for determining tables, primary and foreign keys, etc, are the same.

Thanks.

After some trial and error, I have determined the answer is

="http://...." & Fields!<fieldname>.Value

I'm trying to appending a dynamic value (field from a recordset) to the end of a URL string.  If you look at what you have, it would be similar to...

Ich kann Deutsch, aber die meisten andere Mitgleider koennen es wahrscheinlich nicht.  Kannst du bitte die auf deutschen Anweisungen uebersetzen?  Danke.

I can read German, but most of the other members probably can't.  Can...

My app isn't quite as intensive as yours, so you will need to make a few adjustments.  I make 5 log b/u's during the use cycle, and one as part...

I keep all my trans logs in one file.  The risk of damage to the file can be overstated, because if you were to have 7 seperate files, any of...

I wouldn't normally add to such a pile-on, but it IS such a bad idea, that I can't believe someone suggested it seriously.  Performance is important, but not at the...

Using Active X scripts, divide the retrieval and size check steps.  Use the File Scripting Object to check for the size of the file in the second step.  If it's...

I would put the active X script in it's own DTS package, and then run that package as the second step of a job, which runs whether the first step...

It's not tricky to restore a structured storage file.  You right click on the folder and choose open package.

I use both methods.  The downside of depending solely on a b/u...

That's a pretty slick way to do it.  I'll add it to my arsenal of tricks.

Thanks,

Phil,

How would you use your technique to have a mail message sent if a job failed?  It seems to me that your method works fine if you are sending a...