What is the problem?
in version 3.9 this problem was not!
p.s. Sorry for my English :oops:
SQL prompt 4.0.2.53
Microsoft SQL Server 2000 - 8.00.194 (Intel X86)
Aug 6 2000 00:57:48
Copyright (c) 1988-2000 Microsoft Corporation
Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 3)
Comments
Can you kindly send us the script of the object at support@red-gate.com?
In Management Studio right click the object and select 'Script function as --> Create to' and send us that script.
Note: Please include the link to this forum in your email.
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com
As per my email I was able to replicate the issue in SQL 2000 but it works absolutely fine with SQL 2005 and SQL 2008.
I have logged this issue (SP-2842) in our internal tracking system so that it can be looked upon by our development team.
Many thanks for your patience and co-operation to replicate this issue.
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com
We have a good news for you
We have released a patch which includes the bug SP-2842 for SQL Prompt.
Kindly check this forum link and download the installer: http://www.red-gate.com/MessageBoard/vi ... php?t=9993
Please let us know if this build fixes the issue.
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com