The functions you are using (object_name and Objectproperty) always look in the current database.  They are not aware of the database name in the FROM.  You could try the following:

declare...

Enterprise Manager

Have you tried tools like Remote Desktop/Terminal Service, PC Anywhere, VNC ?

Using tools like EM tend to require a fair bit of network traffic because EM checks just about everything...

Don't even think about changing syscolumns UNLESS you need practice at restoring your database.  Yes, this has the column order but there is no doco on how SQL Server is...

Why don't you create an article that has a vertical filter that selects just those 5 columns ?

Yes the conflict tables are system tables but you are able to create triggers on them.  You are expected to be allowed to perform most things on these tables otherwise...

I can't think of options that require no code.  You could create a trigger on each conflict table that raises an error that you either log to the event log...

create table #devices (DeviceName varchar (100), PhysName Varchar (100), Description varchar (100), status int, cntrltype int, size int)

Insert into #devices

Exec sp_helpdevice

select * from #devices

Check the lengths of the columns in...

Have a look at sp_helpdevice.  If run with no parameters it will return a recordset containing all devices.  A status of 16 is a backup device.

You say that the "DB2 rights are correct" - I assume from this that they are correct for your windows account (i.e. you logon to the server as yourself and...

Not sure that I understand the timing of your events - I assume that you mean that the next transaction log backup is scheduled for 1PM but the server dies during...

Have you re-initialised the subscription ?  I don't think the change you made will have any impact to existing subscriptions.  This will most likely result in all data being sent...

No they do not have to be the same. 

You can change the table name if you are using transactional replication.

You may elect to publish some of the columns of...

You can join to a UDF that returns a table.   You might need to adjust your UDF to suit - I assume that the parameter for this is currently the...

The REMOTE hint has nothing to do with collations.  It tells the query optimiser to let the remote server process as much of the query as it can...this should mean...