sql server replication: We are trying to implement a warm stand-by sql server, but after initializing
a new push subscription, neither the users no the table permissions are being
transferred.

Isn't the snapshot be responsible for those (sysusers and syspermissions)
tables?

No, you have to script it out and apply it as a post snapshot command or use
sp_addscriptexec to run the script on all unc deployed subscribers.

--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
[quoted text, click to view]

As Hilary mentions, this process is manual to an extent.
I have a constantly changing environment, and in order to
save time, I generate the permissions script
automatically. The script I use is below:
SELECT 'Grant ' +
case
when action = 193 then 'SELECT'
when action = 195 then 'INSERT'
when action = 196 then 'DELETE'
when action = 197 then 'UPDATE'
when action = 224 then 'EXECUTE'
end as Grant1,
' ON [' + delivery.dbo.sysobjects.name + '] TO ' +
delivery.dbo.sysusers.name as Grant2
--,ss.srvname
--,delivery.dbo.syspublications.name AS Publication
FROM delivery.dbo.syssubscriptions
INNER JOIN delivery.dbo.sysextendedarticlesview ON
delivery.dbo.syssubscriptions.artid =
delivery.dbo.sysextendedarticlesview.artid
INNER JOIN delivery.dbo.sysobjects ON
delivery.dbo.sysextendedarticlesview.objid =
delivery.dbo.sysobjects.id
INNER JOIN delivery.dbo.syspublications ON
delivery.dbo.sysextendedarticlesview.pubid =
delivery.dbo.syspublications.pubid
INNER JOIN master..sysservers ss on ss.srvid =
delivery.dbo.syssubscriptions.srvid
left outer JOIN delivery.dbo.sysprotects on
delivery.dbo.sysprotects.id = delivery.dbo.sysobjects.id
left outer JOIN delivery.dbo.sysusers on
delivery.dbo.sysprotects.uid = delivery.dbo.sysusers.uid
where action in (193,195,196,197,224)
--and srvname = 'xxx\PDSCOPY'
and srvname = 'yyy\PDSCOPY'
order by ss.srvname, delivery.dbo.syspublications.name,
delivery.dbo.sysobjects.name, delivery.dbo.sysusers.name

You could also script out the logins and users, add this
all into a script file and then run this script
automatically either as the post-snapshot script or using
a jobstep to run sp_addscriptexec.

HTH,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

Thank you Hilary and Paul - I realized now that sysusers and syspermission
are not being replicated.

Do I need to change anything in your script to make it work besides the
"delivery." portion? If I run it, it won't return anything.

I managed to transfer the sysusers by restoring a backup from the
distribution and initializing. syspermission did not survive the
initialization.

I understand that I need to run manual scripts to make this happen. Is there
anywhere I can find proven working scripts for a warm stand-by server? I
guess that should be a common setup.

[quoted text, click to view]