Home Forums SQL Server 2005 Administering Granting select permissions on all Views, SQL error (declare scalar variable) RE: Granting select permissions on all Views, SQL error (declare scalar variable)

  • While rowid and sqlstr are column names in your table, you are also using variables @rowid and @sqlstr in your code without ever declaring them. Add the declaration for them with the same data types as the columns at the beginning and you shoud be covered.


    And then again, I might be wrong ...
    David Webb