I am getting the following problem on my live server but not on my localhost
[Macromedia][SQLServer JDBC Driver][SQLServer]'SCOPE_IDENTITY' is not a recognized function name. I believe the live server is MSSQL 7 and my local machine is running 2000. I am pretty sure the SCOPE_IDENTITY is the problem and was not available in 7 and we had to us @@IDENTITY. Is this a quick change or should I ask my host to upgrade us to 2005 (we have that option but I have never used 2005). I just wanna find out if anyone else has come across this before i go doing anything. -- Thank You Dan Vega [EMAIL PROTECTED] http://www.danvega.org -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Reactor for ColdFusion Mailing List [EMAIL PROTECTED] Archives at: http://www.mail-archive.com/reactor%40doughughes.net/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
