I have the following procedure that I use with VB/ADO to execute scripts and create tables. the script works great as long as I purge out the "GO" words from the scripting syntax before sending it as the SP parameter.

ALTER procedure [dbo].[SP_UpdateDBObjects]

       @str nText
AS
Exec(@str)


I want to use this SP to update views and other SPs as well, but the problem I run into is when I send the script text to my SP_UpdateDBObjects, if the GO statement is in the script then I get an error that says "Incorrect syntax near 'GO'.
If I purge out the 'GO' words from the parameter then I get an error that says 'CREATE VIEW' must be the first statement in a query batch.