You could use the queryresults. Better off with an ADO query.

Steve Jones

steve@dkranch.net

Interesting. I use msgboxes and debug files in DTS to write out execution to a text file.

Steve Jones

steve@dkranch.net

see other post.

Steve Jones

steve@dkranch.net

Some white papers here:

http://www.microsoft.com/sql/techinfo/BI/default.asp

Nothing on sizing, but it's proably covered in some areas.

Steve Jones

steve@dkranch.net

I think you still need the space, but you can do the reindex while hte db is on line in sql 2000. The routines have been rewritten to reduce the...

Brian has a great suggestion.

Steve Jones

steve@dkranch.net

This is almost always aformatting issue.

Steve Jones

steve@dkranch.net

Does Oracle have encryption/ decryption routines? How does it manage keys?

I think the db is a good place for encrypted data, but it is extremely difficult to manage. Plus, to...

Sorry. when my water pipe broke last week I go confused

BTW, these would be great for your fraternity brothers!!!

Steve Jones

steve@dkranch.net

I agree with Brian. don't fire it from a trigger. If you need to run it, store some flag value in a table based on the trigger and then run...

I'd produce the file, then check for records using an Active X script and then delete the file if there are no records.

Steve Jones

steve@dkranch.net

You're welcome.

Steve Jones

steve@dkranch.net

sorry. Just a US guy here. I think you will have to check with MS.

Steve Jones

steve@dkranch.net

Haven't seen it. Verified this occurs in SQL 7, does not occur in 2000.

Personally, I always avoid select into. Create the table and use insert select. It allows you the...

Agree with Paul. I've done it, but usually only with shrink wrapped apps. They tend (not always) but tend to leak memory less simply because they recieve more testing.

I'd be...