You have posted in an inappropriate forum. You would have gotten better results if you had posted in the appropriate forum.

I'm also not sure what you are asking. ...

Can you post the link to the TechNet article you read that shows a way to do this? I don't know how that would be possible because all logins...

What other activity is on the server? What is the size of the database and the log and is there free space before you start the insert? Typically...

I've never done this, so I don't know if it works, and don't necessarily think it would be the best way to handle, but you could add the specific...

Brandie,

Does anything from Database Mail work? The only issue I know of when applying SP2 was that the setting the Reply TO email did not work.

Statistics in the database could be different. Are the server specs the same? You could have less memory or slower disks.

Your first issue is that you are thinking procedurally, not in sets. SQL Server is inserting or attempting to insert ALL the rows at once, so there is nothing...

What's the primary key? What are you planning to do in the ignore error? Do you want to load the duplicates?

timothyawiseman (12/5/2008)

While I know this is a matter of opinion, I found...

Can you post the properties for the linked server?

Okay. Here are your problems.

1. You are trying to work with a Server report, but using local report code. Change the processing mode to Remote, change ReportViewer1.LocalReport.Refresh...

Duplicate post. Please post answers here

I actually think I did, but I decided not to reply because I couldn't have...

And my only vice is never having been wrong. 😛

All the OR's limit the usefullness of indexes. As...