"Cannot call methods on bigint" error
I had a view in my database (MS SQL 2005) with “Cast” statements.
At one point I tried modifying it, but this resulted in the following error:
“Cannot call methods on bigint“
After doing some research it turns out there was no problem with my query - the error came from the SQL 2005 management studio itself.
The fix was using T-SQL to modify the view instead of using the designer….
Category: SQL Server
April 26th, 2007 at 4:17 pm
This post saved me a lot of time. Thanks.