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?