How have you configured your default mail profile? Verify that you have the proper server name, port number, and most importantly for these types of issues...what is your needed...

SQL 2005 or 2008?

If 2005, in the Surface Area Configuration application, check the Connections, then Remote Connections section, then check to see if you have Named Pipes and TCP/IP connections...

Please post the TSQL that you've come up with thus far

For kicks and giggles...what happens when you actually include all the columns in the OPENQUERY:

Ex:

INSERT INTO table

SELECT [TableKey1],[TableKey2],[TableKey3],[Column4],[Column5],[Column6],[Column7],[Column8],[Column9],[Column10]

,'','','','','','','','','','',0,''

FROM OPENQUERY(server, 'SELECT TableKey1,TableKey2,TableKey3,Column4,Column5,Column6,Column7,Column8,Column9,Column10

FROM providerstring.library.table')

I also would wager that this would work as...

You mention that the 4-part SELECT still works (without error), but does it still work in conjunction with the INSERT?

INSERT INTO table

SELECT * FROM server.providerstring.library.table 

Are you 100% certain the schema is identical from ServerA - ServerB - this also means, there are no computed columns on this new server that's generating the errors?

It would...

I always assume those steps are performed before someone even posts to the forum :w00t:

So, at least I know that permissions are ok. Drive where UNC folder is 1TB. Total table size is less than 70 GB. So, we have plenty of space. we...

I don't believe this is possible. You could however run the statement below using linked servers to connect to each of the servers, that could give you what you...

I know this contrary to what everyone else has said but I've experienced similar behavior when a RAM module was going bad. Everything seemed fine until either the connections...

You definitely have some issues with the data in your MSDB table.

I'm pretty certain the reason your backup completes successfully but your maintenance plan job fails is because you have...

As long as your client authenticates via VPN into your network, they will be granted and assigned a local IP address on your domain...they will have all the rights that...

OP, please click here

:hehe:

Edit: I believe the actual error is SSPI Context, not content

I've got a suggestion but first need to know how large is your publication? For instance, how many articles are in this publication? A few dozen? Hundreds? How long...

The agent job will be wherever your distributor resides