can you try to post the screenshot of the error?

Please do not post further in this thread

reply to this thread http://www.sqlservercentral.com/Forums/Topic810850-1291-1.aspx

You can find some of the steps to do in one my recent Blog

Downgrading SQL Server Enterprise Edition to Standard Edition

Although you are not doing the same thing, but...

You mentioned you are Interning and your company is doing a...

Thanks for that Seth

Can you give the Table structure that you are trying to update?

Also try to post the Script using the Code Tags so that it helps in more readability than this.

Why are you planning to do this, when there are tables in MSDB that store the same information (Infact more Info)

What are you planning to do with this information you...

Try Identifying the new records with a Datetime Column you have or by maintaining a record in another table let us say Maintenance Table.

Then use SSIS Packages looks at the...

You can make use of either SSIS or Replication (What type of Replications needs some understanding of the Table Sizes etc)

Well there are many ways to do it.. and all of them are easy depending on your experience with SQL Server.

Give more details in order to understand what you want...

My worry is that having 2 different types of replicated processes (mirroring and transaction replication) both running on the server, transferring the data to 2 different servers, will cause some...

I guess you cannot have transformations while publishing. Can't remember where did I read it.

Read thoroughly the Books Online and gather as much information on all the topics by reading Various Blog's and increase your knowledge, and then put in into practise. That is...

We are Using SQL 2000 / 2005 and 2008 and of Course Planning to Migrate / Upgrade SQL 2000 to 2008

In the Scheduled Job, Look at the Login it is using under Run as Column.

And see that login has admin level rights on that Instance.

Edited --- Jeffrey has already...