Got the answer now in microsoft support for those who have the same problem here is the llink of why this is happening in replication

http://support.microsoft.com/kb/832902

Hope this helps....

http://www.mcse.ms/message1852894.html

Have you tried running this statement?

SELECT @@servername,serverproperty ('servername')

If the values are not equal you can use the script below

got this from http://support.microsoft.com/kb/818334

-- Use the Master database

USE master

GO

-- Declare local variables

DECLARE...

And one thing before you apply the result of the script above to the database you already restored you must delete first the orphaned users. Here is the script to...

Hope this helps i made the script few weeks ago this script will generate another script of your server/database user log-in and roles. It is in 3 parts: Generate Server...

Romain Pelissier (10/24/2007)

---

I fact the maintenance plan has been created by the application that use this db so I have not created or modifying anything.

I far as I know, the...

Thanks for the link its very helpfull (two thumbs up!!!!) 😀

If your problem is replicating data from 1 publisher to 55 subscriber i guess you can do it even by setting up 1 replication process. THe thing is that the...

Thanx for the replies guys 😀

SO as you are saying i MUST manually update or add the new views and stored procedures?? it is not automatically replicated when i created it in the publisher database??...

THanks lowell!!!!!!! found out that the table is not owned by dbo

Renuka (10/19/2007)

---

Hi,

If you want the updates on publisher should be replicated to Subscriber, you can use either Snapshot or Transactional Replication (Depending on your requirement). Only if you require the...

Yeah right thanks happycat im just double checking if i there is no connections or problems in deleting sql server registration names thankss...

Yeah thats the reason why im having lots of orphaned users but anyways i made a script that will delete orphaned users, recreate server and database logins/roles

Ok problem solved all i did is to change the server's IP with its computer name. Then on the security tab i choose Be made using this security content and...