Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Can SQL Compare handle stored procedures and functions that were renamed using sp_rename?

April 26, 2017compare functions procedures renamed sql stored

0

Posted

Can SQL Compare handle stored procedures and functions that were renamed using sp_rename?

1 Answer

0

Posted

Yes. If a database schema has become inconsistent due to the use of sp_rename, and a stored procedure or a function definition refers to a different name from what is in the system tables, SQL Compare 7 automatically fixes these inconsistencies.