Is the full error message "The row was not found at the Subscriber when applying the replicated command." I didn't have a clue what you were talking about until I...

There shouldn't be. Views are inlined when SQL runs the query. But as I often tell my developes, try both ways and see if there's a difference

Even, in terms of what? Row position based on a certain order, an identity column, something else ????

Define 'even rows'

Do you have an identity column and only want rows where the id is 2,4,6,... ?

Do you want every other row as defined by a certain order by?

Off...

I'll have a go at writing something from scratch for you, cause I can't figure out the original script.

Is going to take a while though, please be patient. 

Openquery requires that you...

select servername, serverproperty('productversion'), serverproperty('productlevel'), serverproperty('edition')

 from #t where ServerName...

That's going to return for the machine where the query is run. You're not actually reading anything from #t there, other than the...

Depends why it's unresponsive. Are you seeing lots of blocking on queries? Are you seeing logins timing out?

Check the front end, see if it has connection pooling enabled. If not,...

SQl doesn't keep its error log data for a fixed time. Rather it keeps a certain number of historical error log files.

A new log file gets created whenever SQL...

Yes, they do charge. If the crash is a result of a bug, I believe that they waiver that charge (I could be wrong)

Does your boss expect you to debug...

My comment was directed at the OP, not the reply. Sorry for the confusion.

Select * from tempdb..sysobjects where name = '#tablename' won't return anything

OK, having had a careful look at your execution plan, the actualquery doesn't much resemble the earlier examples. As far as I can see, the actual query that you're having...

Yes, but not common. It's a role I have, though I often do other stuff too. As for advice...

Read, as much as you can. Books, white papers, blogs, forums. Also...

On each server run

SELECT @@SERVERNAME AS ServerName, SERVERPROPERTY('Edition') AS Version

Of course, you cannot use object_name with this id later, since the id is from another db.

Actually, you can. At least in 2005 SP2. Object_Name has been enhanced to...

SELECT

SERVERPROPERTY('ProductVersion') AS ProductVersion,