It appears that it does not like something in the name of the object. I
have not used sql much against SQL SERVER DATABASE, the only thing I did
see is that in the error..it shows Proc in mixed case, but in your SQL
statement, it shows PROC in all caps on the object name.

Normally this is a naming issue, you have a table name wrong or a field name wrong in such fashion SQL Server cannot resolve what 'object' you want. I haven't used TOAD (loved it when I did) in years. Are you sure you are connected to your SQL Server Instance and the proper database. SQL Server often 'fall's to Master if another isn't specified. So make sure your connection is actually 'looking' at the right database within the SQL Server instance.

Copyright 1998-2015 Ziff Davis, LLC (Toolbox.com). All rights reserved. All product names are trademarks of their respective companies. Toolbox.com is not
affiliated with or endorsed by any company listed at this site.