Posted by Erland Sommarskog on 05/16/07 07:24

Jeff Kish (jeff.kish@mro.com) writes:
> As problems arise, I'll investigate dynamic sql for a solution. I assume
> you are talking about placing the alter table commands in dynamic sql
> then... right?

No, rather it's the commands that follow that you may have to put in
dynamic SQL. But you will find out if you need to.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: How to fix error 207 in ms sql server 2000
• Prev in forum: Re: Database Owner cannot connect
• Thread view: Re: approach to creating a procedure that contains dll , dml to upgrade a system

[Reply to this message]