Re: After I update the existed sql 2000 to sql 2005. But I saw the sql is still running v8.0 (it means still running sql2000)

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

under database properties, there should be an option to run in sql2000 compatibility mode or 2005. my understanding is that if you just attach a sql2000 database, then it will stay in sql2000 compatibility mode.
you can change it to 2005 mode if you want. that may affect the readings your getting.

Benny Ng wrote:
Dear All,

After I upgraded the existed SQL SERVER2000 to SQL SERVER 2005. But I saw the SQL SERVER is still running V8.0(It means the SQL SERVER is still running the 2000 core).

But I remembered that I had selected the options to upgraded the existed SQL SERVER. (Not runs on SQL2K and SQL2K5 parallel).

Can anyone tell me how can I upgrade the existed SQL2K core to SQL2K5? I saw some helps that when I setup the SQL2K5. Add one parameters when setting up?

Thanks for your helps first,;)


Best Regards,

Benny Ng


.

Relevant Pages

  • Re: pass table-valued param to table-valued function
    ... individual database I was using was set to 80, ... "Plamen Ratchev" wrote: ... compatibility mode 80 (SQL Server 2000) then it results in the error message you posted. ...
    (microsoft.public.sqlserver.programming)
  • Re: Physical and Memory Temp Tables?
    ... and will not work if you are not in 2000 compatibility mode. ... your DTS package will not see @table for the same reason it won't see ... > Are you sure you're using SQL Server 2000? ... > (Reverse address to reply.) ...
    (microsoft.public.sqlserver.programming)
  • Re: Performance really poor if calling data from sql clients
    ... But how can I find out finally which compatibility mode the SQL server is ... Andrew J. Kelly SQL MVP ...
    (microsoft.public.sqlserver.clients)
  • Re: HELP !! Restrict db_owner from changing database properties.
    ... able to view the database properties? ... db_owner role membership, as that would grant more permissions than you ... > I have seen such existing configuration on SQL Server 7.0 ...
    (microsoft.public.sqlserver.security)
  • Re: Simple Select Question
    ... The ranking functions are supported in SQL Server 2005. ... The code will work even if you database is in compatibility mode ... Plamen Ratchev ...
    (microsoft.public.sqlserver.programming)