I made a few more changes. The script now adds grants for each database and disables logins that are disabled. I also removed all temp tables and cursors and installed...

When I run your query in MS I get 'TCP'.

When I run it in the SQL job I get 'Shared memory'.

What does that mean, exactly?

This works to simplify the 'for xml path ('')' option:

select substring((Select rtrim(ltrim(','+name)) from fruit order by id for xml path('')),2,1000) as FruitList

The rtrim/ltrim function apparently removes the unprintable xml tokens,...

You can also use XP_CMDSHELL with a variable to see if the file exists, as follows:

DECLARE @Exists integer;

EXEC @Exists=XP_CMDSHELL 'DIR C:\directory\filename.ext'

If @Exists=0, then the file exists. This saves having to...

When I copy the script code into the script task, I get the following message: "The task is configured to pre-compile the script, but binary code is not found. Please...

Thanks, Matt. Have you actually tried using a trigger to change data in the table it references?

Thanks, Lowell, that was the answer.

I didn't think I had any nulls in the THINGS table, but there was ONE record ...