Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Renaming Procedure on Msde server
Message
General information
Forum:
Visual FoxPro
Category:
The Mere Mortals Framework
Miscellaneous
Thread ID:
00673800
Message ID:
00673838
Views:
24
Franco,

you can call the SQL-Server built-in stored procedure sp_rename like this:
sp_rename 'sp_newid', 'mm_newid', 'OBJECT'
Simply make a SQL Pass Through connection to your database and send this command via SQLEXEC().

HTH,
Armin

>Hi ,
> I have a problem with the framework when i am trying to change the data from local to remote (MSDE). When i am trying to input records with the msde backend it is giving me an error that it cannot find the procedure called mm_newid ... In the documentation i found that i have to change the procedure on the msde or sql server from sp_newid to mm_newid , but how can i do that.
>Thanks.

Armin Neudert
Regional Director (Stuttgart) of German FoxPro User Group dFPUG

MCP for Visual FoxPro

Expert/Editor of the VFP section in the German Codezone community portal
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform