prad-a-RuntimeException
8/30/2013 - 3:14 PM

Sql Subscription Server name problem

Sql Subscription Server name problem

Sql Replication troubleshooting
content_copyfile_download
sp_addserver 'DC-PRRAJU7-01\SQL2008DEV', LOCAL

-- if we get error saying name already exists

sp_dropserver 'DC-PRRAJU7-01\SQL2008DEV'
go
sp_addserver 'DC-PRRAJU7-01\SQL2008DEV', LOCAL
go


-- if error is server already exists

sp_dropserver 'WIN-FU2OUL2T9RG\SQL2008DEV'
go
sp_addserver 'DC-PRRAJU7-01\SQL2008DEV', LOCAL
go