Hi all, help is needed!

I'm running this query:
"INSERT INTO location (x,y) OUTPUT INSERTED.Location_ID VALUES ("+x+","+y+")"

which works fine on my SQL EXPRESS 2005 (i get the id back, which is a must).
However, my server has SQL 2000, and when i try to run the query i get an exception:
" Line 1: Incorrect syntax near 'OUTPUT' "

Anyone knows a workaround
How can you run such a query on 2000

Thanks!!!

What are you trying to output, the values of x and y or the id of the location table?

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
Technical Editor for:
Professional Search Engine Optimization with ASP.NET

Professional IIS 7 and ASP.NET Integrated Programming

================================================== =========