Submit My Question - Recent Questions - Recent Answer

Using Alter View in sproc?

I am getting errors when trying to write a stored procedure with alter view statements in it. Can this not be done or is my syntax just off. If it can't be done is there a common work around or different method I should consider?

Thanks

[247 byte] By [bobbye] at [2008-2-22]

«« Problem altering/saving moved MailItems in Outlook VBA
»» Is it possible to use ssas as datasource for report builder in june ctp?

# 1

Can you post the stored procedure code that you're using?

Thanks,
- Balaji

BalajiRathakrishnan at 2007-9-9 >

top of Msdn Tech,SQL Server,Transact-SQL...

# 2

You most probably have the ALTER VIEW in the body of the SP as static SQL statement. This is not possible since DDLs like ALTER VIEW, CREATE VIEW, CREATE PROCEDURE etc needs to be only DDL statement in the batch. You have to either do ALTER VIEW in it's own batch or execute it dynamically using EXECUTE or sp_executesql.

UmachandarJayachandran-MS at 2007-9-9 >

# 3

Umachandar,

I do have the ALTER VIEW statement in the body of the SP as static. I will rework the SP to execute it dynamically as you suggested.

Thanks alot

bobbye at 2007-9-9 >

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

Question about 'Using Alter View in sproc?', No.65899,Posted by bobbye

Using Alter View in sproc?

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Site Classified