Ok first what is line for

WHERE publication_id = inserted.publication_id

and are you getting any records in the table? Also, describe what it is that should happen. From this you should get...

I work in a large corporation but the group I am in owns their own servers and I am admin over both Windows and SQL. However we have a server...

Take a look this will work.

You can effectively rename a user account but as this is messing wit the system tables I would suggest dropping and adding the user back....

There is a name column of each userdb in the sysusers table that may also need to be updated.

What datatype are Pax, Crew, and Admin and can they be NULL? What will the final report be done in and look like? And does no traffic have to apply...

I agree with Sean, one of the biggest problems you will have is database performance has ths gets larger because to ensure data order and no reoccurrance of an Observation#...

Almost anything is possible in queries, just give us some detail on the tables and how they work so we can help.

Ok I made a mistake in my statement. You can add a column but you cannot change any replicated column in any way and you will not be able to...

As long as you get the results you want and can be sure the data is what is to be expected always go with what works. You can always fine...

I would have to agree there, plus even if they don't want I would still purpose anyway as there are far more advantages to SQL 7 or 2000 as far...

You cannot make a change to any table under replication. What happens is when the table is being altered there is a temporary version created with the new settings and...

Ok I understand what you are stating but I am not talking about putting the plain text into the file. What I am talking about is putting the SQL Encypted...

Actually when you do new login on the General tab you will see Name, if it is a local group on the NT box itself then jsut type the group...

Let me restate. Go back to my original post, where I suggest doing with WITH ENCRYPTION and copy the string out into a .sql or whatever file. I merely mean...

I have never done this myself but check out http://www.sql-server-performance.com/tp_replication.asp SQL Server Replication from 6.5 to 2000. The same method should work for 7.