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...

When you execute the package, it runs under the context of your login and from your workstation. When it runs from the scheduler, it runs as the SQLAgent service account...

I tend to agree with Brian. I looked around, but couldn't find anything on this. Everyone mentions writing event messages, but no-one has info on changing the category. I suspect...

I believe in SQL 6.5, that you can script the procedures from Enterprise Manager. If I remember, it is in the Tools menu.

If not, you could get an eval of...