I appreciate everybody's comments. It seems obvious that this is a problem that we all experience regardless of the industry or product that we support.

swwg69 hit the nail on the...

If the database that you've replaced in the USE statement is a transactional replication subscriber then you should have an MSreplication_objects table. Maybe this error indicates that your database is...

Thank you for the reply. I realized that I didn't have any target servers setup at the time. This is why I my systargetservers table was empty.

I'm going to do...

What version of SQL and powershell was this script meant for? I've been having some trouble with the script.

1. I had to change the query in GetServers to "SELECT server_name...

I agree with Scott Rankin that there are many ways to peel this onion.

What's I've posted below has actually been ripped out of a more complex and permanent solution that...

For anyone who reads this post. I found the solution. I'm not 100% sure what the issues was but it appears to be an issue with data in a particular...

Rich and Shineboy. I tried both of your suggestions and neither worked. Thank you for your attempt, though.

Thank you for your help. I'm sure that I'm failing to express some key piece of information that matters here.

I will try the tracing as you suggested. If I find...

They are all the same but I've tried this same setup on 10 different tables and receive the error in all cases. I do not have a successful case to...

MyISAM is the engine.

MyISAM is the storage engine being used.

To be frank, I'm pretty good with MSSQL but I'm basically a MySQL noob.

If you could point out anything that I should be looking for I would gladly perform the...

I apologize for the delayed response I've been ill.

My MSDASQL settings are the same as yours.

I'm not sure if this was the information that you sought.

As seen below I'm using "MySQL ODBC 5.1 Driver".

The only things changed below is the actual Linked Server name (to match example scripts), domain, database name, and username/password.

/****** Object: ...