"mark" <markiiii@sina.com> wrote in message
news:e0q$Pdm4GHA.2464@TK2MSFTNGP06.phx.gbl...
> dim gConn as new adodb.connection
> gConn.open "...."
> strSQL = "sp_rename 'mytable', 'mytable1','OBJECT'"
> gConn.Execute strSQL, , adCmdStoredProc
>
> Why last SQL command cannot be executed?
>
>

> Leave out the word 'OBJECT' in the strSQL.
>
> strSQL = "sp_rename 'mytable', 'mytable1'"
>
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
>
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
>
>
> "mark" <markiiii@sina.com> wrote in message
> news:e0q$Pdm4GHA.2464@TK2MSFTNGP06.phx.gbl...
> > dim gConn as new adodb.connection
> > gConn.open "...."
> > strSQL = "sp_rename 'mytable', 'mytable1','OBJECT'"
> > gConn.Execute strSQL, , adCmdStoredProc
> >
> > Why last SQL command cannot be executed?
> >
> >
>
>

> dim gConn as new adodb.connection
> gConn.open "...."
> strSQL = "sp_rename 'mytable', 'mytable1','OBJECT'"
> gConn.Execute strSQL, , adCmdStoredProc
>
> Why last SQL command cannot be executed?
>
>