Good job, Brian. I will definitely use this.

Excellent and clearly written!

I'm always reading CTE articles and this is one of the best, because it explains a situation which is very commonly encountered.

- Paul

I'm unfamiliar with the 3rd party backup software you mentioned. If it is not specifically intended for backing up a data server, and is only meant for backing up...

I had 1 or 2 approaches to this, but now I have a whole set of them.

This is such a textbook example of what a technical blog is all about!...

Can you clarify by showing us the exact code the job is executing?  Especially important is to know if this is a regular SQL backup or third party.

As Vivien alludes...

I wonder if when you compiled your stored proc, you had a GO statement above the CREATE TABLE statement.  If that was so, only the code above GO would be...

This feature is not new to SQL 2005 - it can be done in SQL 2000 and prehaps prior versions.  My guess is that SQL 7 supports it as well.

Whenever I have a flaky connection I find that log shipping is my preferred choice.  Is that possible for your scenario?

I'm not an expert in the area of psychology but I do like to read.  Here's something I learned:

There was a study done using the Myers-Briggs Personality Indicator.  It revealed...

Excellent article, Lynda.

In my career I have had some jobs that I loved, some that I absolutely despised, and some that were so-so.  I find that whether or not it...

Thanks for the article.

I tend to avoid using the parameters collection and just concatenate a string with all the info for the stored proc.  I find this easier that wrestling...

So did the db I sent work for you?  If not, then you have a tough situation.

Next I would suggest re-applying sp1 of SQL 2005 - it has been known...

Here's all my code.  I'm using SQL 2005, developer version.

EXEC sp_addlinkedserver

@server = 'TestLinkAccess',

@Provider...

When you say the databases is secured, do you mean that it has a password?  If so, try this, where password is "yaya".  I believe the provider you are using...

Can you please show a sample of the calling code which generates that error.