The graphic between "Still not great, but we also got CREATE OR ALTER. That means I can just write this code all the time." and "We should have...

I know this is an old thread, but I thought I'd ask anyway...

This script doesn't seem to produce the same output that you would get if you save the package...

Actually, the 32 bit machines ARE able to query the linked server without using OPENQUERY. It is the 64-bit that must use OPENQUERY. And I have another 64-bit...

I am using the same credentials on all three servers. The only difference with this third server is that it's a 64-bit and the others are 32. The...

Please come back and tell us what you figured out. I am having the same problem.

SS,

My original question was written incorrectly. I have revised it. It does work with the four part name, as I have corrected, above, on two of the three...

Thanks, SSC, that was very helpful. I did as you said and clicked on Build from within the script itself, and the "real" problem was that I had a...

I was excited when I saw the title of the article, I thought perhaps SQL Server was keeping it's own data on when a stored procedure was last invoked, buried...