<div>
I think the better way is to drop and recreate the publication
</div>


I think the better way is to drop and recreate the publication

<div>
Oh my god. <br />
<br />
It would take a lot of time. <br />
<br />
Ok.
</div>


Oh my god.

It would take a lot of time.

Ok.

<div>
I would be happy, if u may please have a view at<br />
<a href="https://www.experts-exchange.com/questions/21836260/Replication-and-error-message-SQL2K.html" rel="ugc">https://www.experts-exchange.com/questions/21836260/Replication-and-error-message-SQL2K.html</a>.<br />
<br />
Thanks<br />

</div>


I would be happy, if u may please have a view at
https://www.experts-exchange.com/questions/21836260/Replication-and-error-message-SQL2K.html [https://www.experts-exchange.com/questions/21836260/Replication-and-error-message-SQL2K.html].

Thanks


<div>
tell you what if you try to rename the publication without droping them you need to change it in msdb database but it is very risky. i never did it and it is not recommended. so better use the above mentioned method of generating the script.
</div>


tell you what if you try to rename the publication without droping them you need to change it in msdb database but it is very risky. i never did it and it is not recommended. so better use the above mentioned method of generating the script.

<div>
<div class="content wysiwyg-content">
SQL2K<br />
<br />
I want to rename a publication name.<br />
<br />
Publications: &nbsp; &nbsp; siddiqsons:siddiqsons (Name before : is publication name and after column is database name.<br />
<br />
I want to rename the above as [ SiddiqsonsVsProd_Dcity ] without affecting the existing articles and subscribers.
</div>
</div>


SQL2K

I want to rename a publication name.

Publications:     siddiqsons:siddiqsons (Name before : is publication name and after column is database name.

I want to rename the above as [ SiddiqsonsVsProd_Dcity ] without affecting the existing articles and subscribers.

To rename publication name

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.