MSSQL Upgrade Scripts (sp_rename)

I believe there is an error the MSSQL upgrade scripts at least for MSSQL 2005

the command sp_rename needs to be prefixed with exec as such: exec sp_rename

example, kraken\database\upgrade\8\gateway_sqlserver.sql

line 5 should read exec sp_rename 'gatewayRegistration', 'ofGatewayRegistration';

if run in SSMSE, the invalid command error goes away.

 

I don't think this affects current users but people upgrading from an older DB version might stumble accross this problem, i did.

Re: MSSQL Upgrade Scripts (sp_rename)

Hrm.  Very interesting.  I'd swear I had exec in there at some point.  Would you mind adding an issue with this info in it for me?  (in the issue tracker)  My dev environment is teh screwed right now.  =(