When you connect to Replication Monitor from #2, can you right-click on "My Publishers" and add #1? Replication Monitor will automatically default to the current box, IFF the current...

Create the table outside of the Import/Export wizard and then import the data into the already created table.

517 columns could possibly hinder your database's performance though. Are you sure...

I've seen this happen once myself. Instead of tracking down what happened (unless you can check out server logs or ask your SysAdmin "what the hell?"), re-upload the reports...

I'd recommend trans rep rather than merge rep. As Roy said, is #2 is going to be read-only then you may as well do trans rep. It won't...

I'm confused. What is the issue specifically?

Why are you using a WHERE IN instead of an INNER JOIN? Generally the INNER JOIN has a better performance and looks cleaner. 🙂

Here is what MSDN said you can do:

http://msdn.microsoft.com/en-us/library/aa259130%28v=SQL.80%29.aspx

I'm not sure what you are trying to change about your primary key though (length of a column? which columns make up your...

I'd recommend a UNION of 3 separate SELECT statements to get the order that you want. You can add a SortOrder column to guarantee the order is right. Something...

Just out of curiosity, what happens when you run the job manually?

BULK INSERT only really works if you're doing a raw data dump from the CSV file into a table that has the exact same matching structure as the CSV file....

Performance improvement would be noticed in any queries against the table that involve SELECT *. You need to consider too how often that column is being queried as if...

I agree with the sentiments above. You have been misled as you definitely can use views in the FROM clause of a SELECT statement. Also, you should definitely look...

What user are you connecting to the database server as in SSMS? If it's not sa, then make sure that the user you are logging in as has permission...

You can also modify the C:\WINDOWS\system32\drivers\etc\hosts file to add a line like:

127.0.0.1 [database server name]

It'll be specific to only your local computer, but it works and faster than waiting...

Two things you can do.

1. Drop all the FK constraints on the other tables while you do what you want to do with renaming TABLE_A as TABLE_B and creating a...