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

Write the select query first and see if it returns the info you desire. If not, post it and we'll take a look. Paul and Andy provide a great solution.

Steve...

Great suggestion. I'll take it up with the founders and see. you can get a short one here:

http://www.sqlservercentral.com/other/AboutUs.asp

Steve Jones

steve@dkranch.net

Thanks for the followup.

Steve Jones

steve@dkranch.net

create table MyTable( MyID int identity( 1,1 ))

Steve Jones

steve@dkranch.net

You could let one package call another conditionally based on a global variable. The dynamic properties task can handle this and change the name of hte package to execute based...