I'd definitely upgrade if you can. MSSQL 7 is oooooold. On 10/26/07, Dan Vega <[EMAIL PROTECTED]> wrote: > > 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/ > -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- > -- --
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Reactor for ColdFusion Mailing List [EMAIL PROTECTED] Archives at: http://www.mail-archive.com/reactor%40doughughes.net/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
