They are relative to the server that runs the package, so if you put them on your local C drive, the server versions could be on the local C drive...

Yes, it has to be the active log, but I think if you restore a database and then restore the log file, the "replayed" transaction log entries show up. ...

First, I think we are missing some of the requirements. One of the problems with a security model that has users in multiple classes or groups is what to...

There is an undocumented DBCC command "DBCC LOG" that will return transaction log information, but since you are working from a restored database I am not sure if it will...

This is technically not a CROSS JOIN:

[font="Courier New"]USE Northwind

SELECT Title, Customerid

FROM Employees

FULL OUTER JOIN Orders ON 1=1[/font]

The query optimizer found it a pretty dumb thing to do as well. ...

I don't think your logic is that great on this one.

TempDB is nothing to be afraid to use. Is it overused at times - absolutely, but many large operations...

Yes, apparently I needed another coffee when included the unnecessary sub-query.

I was not aware that the package would run through VS on the server.

Try logging into the server as the user used for the startup account for the SQL Agent...

With one of my tables, the first query here is 1/2 the cost of the second one and it looks like it will support lots of queries in the middle...

You cannot without recovering the database and making it impossible to apply more log file backups.

Both are relatively insecure. I would recommend a CLR stored procedure - it is not much more secure, but it is using the newer technology.

Is this a homework question? This seems like a rediculous restriction.

I would suggest you look at the APPLY operator.

Jeff will probably post with a solution using a tally table - which will be faster, but I did not have a tally table on my test box so I...

It is a driver compatibility issue - you should contact DataDirect. My suggestion for a workaround (and probably theirs) would be to change the data access mode dropdown in...

The bcp task is the backwards one - the file location is from the perspective of the server that the task is executing against. So, the error message is...