Thanks for the suggestion Derrick, but that won't work. A job can't be owned by a group, it has to be owned by an individual login.

If the package works as expected from BIDS but not as a scheduled job, the first thing I would suspect is permissions.

When you execute an SSIS package from BIDS it...

Thanks for the reply Stewart.

The folder those settings are stored in seem like an unlikely folder for a developer to clean up, but I'll follow up.

Good day all,

I know I'm late to this party, but I just want to thank every one who contributed to this thread. I've been battling this behavior for weeks,...

If both schemas are owned by DBO then you get ownership chaining just like if all your SPROCs were in the same schema, but you can organize your tables into...

I do not like different schemas within the same database, since they break the ownership chain. Joining different schemas in a proc forces me to grant permssions on the underlying...

Great question and explanation.

I also got tripped up by the difference between logical and physical ordering.

Funny Mr. Fritchey is on this post. I am currently in the middle of "SQL Server 2008 Query Performance Tuning Distilled" - excellent book!

I do a lot of reading both...

IMHO the only way this a good interview question is if the answer you're looking for is "I'm not sure of the correct answer...

Thanks tstaker.

The only other services on the box are Symantec. If I can't find anything on the SQL side, I'll take a good look at Symantec.

Good find, thanks Carl.

Jeff,

The only other services of note are Symantec Critical System Protection and Symantec Endpoint Protection.

I know there's lots of discussion out there about AV on SQL boxes, ...

Thanks Jeff.

We don't really use xp's or CLR. Good suggestion on global temp tables, I believe folks know the difference between local and global temp tables, but I will investigate...

Thanks Carl.

Actually the message was this:

Error: 701, Severity: 17, State: 123.

There is insufficient system memory in resource pool 'internal' to run this query.

Of your list of suggestions to look at...

Thanks for the suggestion IT.

Interesting script, I was not aware of DBCC SHOWFILESTATS. I do wonder, though, if it has the same shortcomings as sp_spaceused - meaning you first...