ALTER SQL command required - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

ALTER SQL command required

Author

Topic

Carliviris
Starting Member

9 Posts

Posted - 2008-10-23 : 18:21:51

Hi, i'm new in this database. I wanna know why this error (ALTER SQL command required)not allow me compile. I did not made this procedure but my boss want add something. What's the problem?


Use [Poncio]
GO

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[PONCIO_PAGO]

Please Help me

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-10-23 : 18:24:19

quote:
Originally posted by Carliviris

Hi, i'm new in this database. I wanna know why this error (ALTER SQL command required)not allow me compile. I did not made this procedure but my boss want add something. What's the problem?

Use [Poncio]
GO

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[PONCIO_PAGO]

----Your modification----

Please Help me

Carliviris
Starting Member

9 Posts

Posted - 2008-10-23 : 18:38:24

Man, if i delete this part:

Use [Poncio]
GO

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

All work good. The problem is in this code. Why not let me use this?

soorajtnpki
Posting Yak Master

231 Posts

Posted - 2008-10-24 : 00:28:31

hi
can u pls give us error message?
then we can easily solve...

please post ur error message..

ok thanks

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-10-24 : 01:36:54

You're sure that procedure already exists?

Carliviris
Starting Member

9 Posts

Posted - 2008-10-24 : 10:08:18

Yes, the procedure exist. The error message is ALTER SQL command required

Lumbago
Norsk Yak Master

3271 Posts

Posted - 2008-10-24 : 10:26:08

This doesn't make sense...show us all the code and we'll be able to help you, or at least show the error message.

- Lumbago

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2008-10-24 : 10:41:14

I think that you are missing something...
After you are typing ALTER PROCEDURE [dbo].[PONCIO_PAGO]
you are waiting for source code of this procedure to appear on the screen so that you can modify?
It isn't so!
Somewhere you will have the source code in a file.
Maybe in source code it begins with CREATE PROCEDURE.
In this source code there comes a lot of code...
Add your "something"-code and change CREATE PROCEDURE by ALTER PROCEDURE and execute it.
Then save the modified source code to file for the next time your boss want's you to add something.

Or get the source by executing sp_helptext PONCIO_PAGO

Webfred

No, you're never too old to Yak'n'Roll if you're too young to die.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources