Home Forums SQL Server 2005 Administering error while trying to move objects from dbo to new schema RE: error while trying to move objects from dbo to new schema

  • incorrect syntax near 'newschema' .expecting a doublecolon.

    Does the error message read out "expecting a doublecolon"? Why not put a GO keyword after each statement?

    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @pradeepadiga