sp-rename

How do I find Stored Procedures with wrong text in syscomments

There appears to be several stored procedures that were renamed with sp_rename, causing the syscomments to be left with the old proc name instead of the new proc name. Thus, my db transfers are failing to transfer correctly. Is there a way to find which procs (or any objects) have their names out of synch? Or better, a simple way to f...

Calling sp_rename on a table kills database connection in Sybase

I'm trying to rename a table using the following syntax sp_rename [oldname],[newname] but any time I run this, I get the following [using Aqua Datastudio]: Command was executed successfully Warnings: ---> W (1): The SQL Server is terminating this process. <--- [Executed: 16/08/10 11:11:10 AM] [Execution: 359ms] ...