General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Hi Derek,
I'm sorry if I did not respond immediately. I'm on vacation and I did not check this question on the thread.
I suspect that you are using SQL Sever 2000.
Try to use set quoted_identifier as follows:
set quoted_identifier off
go
create procedure procedurename
as ...
....
Note that in SQL Server 2000 the double quote ("") can cause an Invalid column name error.
Let me know if this will correct the problem.
Rene
This doesn't work as when I try to save the code I get the error:
Error 207: Invalid column name 'select * from '.Invalid column name 'a where a.User_ID = '.
Any ideas?
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only