sp_helptext returns the wrong DDL, new SQL developer

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

punjab_tom@hotmail.com - 25 Oct 2006 14:40 GMT

I have been cutting and pasting sprocs in an ADP-- seems like a pretty
natural thing to do.
I am signed in as 'sa'.

I'm confused about why this statement returns the wrong DDL?

-----------------------------------------------------------------------------------------
sp_helptext 'QA41_AddressBook'

CREATE PROCEDURE dbo.QA40_AddressBook
AS INSERT INTO dbo.AddressBook
(OptinID, iTypeID)
SELECT OptinID, 1 AS Expr1
FROM dbo.Optin

Reply to this Message

punjab_tom@hotmail.com - 25 Oct 2006 15:56 GMT

I mean to say I cut and paste in Access Data Project and then I run
sp_helptext in Sql Server Management Studio 2005

-Tom

> I have been cutting and pasting sprocs in an ADP-- seems like a pretty
> natural thing to do.
[quoted text clipped - 10 lines]
> SELECT OptinID, 1 AS Expr1
> FROM dbo.Optin

Reply to this Message

Sylvain Lafontaine - 25 Oct 2006 16:36 GMT

sp_helptext 'QA41_AddressBook' or sp_helptext 'QA40_AddressBook' ?

Try with « sp_helptext 'dbo.QA40_AddressBook' » in case you would have
another stored procedure with the same name 'QA40_AddressBook' but for
another owner.

Signature

Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: http://cerbermail.com/?QugbLEWINF

>I mean to say I cut and paste in Access Data Project and then I run
> sp_helptext in Sql Server Management Studio 2005
[quoted text clipped - 15 lines]
>> SELECT OptinID, 1 AS Expr1
>> FROM dbo.Optin

Reply to this Message

punjab_tom@hotmail.com - 25 Oct 2006 18:36 GMT

I definitely don't have another sproc with that name

I have seen this before- sp_helptext reveals the wrong verbage... i
swear it is caused by cutting and pasting stored procedures in ADP.

I'd just love if anyone has an answer / fix for it?

Maybe a hotfix? Or a TSQL batch that will update the system tables
that sp_helptext pulls from?

-Tom

> sp_helptext 'QA41_AddressBook' or sp_helptext 'QA40_AddressBook' ?
>
[quoted text clipped - 26 lines]
> >> SELECT OptinID, 1 AS Expr1
> >> FROM dbo.Optin

Reply to this Message