80 mode

Hello everybody.
What mean if server is runninf in the default 80 mode
What are 60, 65,70 mode.
Thanks for all respond."harry" <simon_add@.op.pl> wrote in message news:d1s8fk$rbv$1@.news.onet.pl...
> Hello everybody.
> What mean if server is runninf in the default 80 mode
> What are 60, 65,70 mode.
>
They are the versions of SQL Server - 6.0, 6.5, 7.0 and 8.0 (2000). The best
bet is to look up the differences in BOL, though the most significant
changes occurred between 7.0 and 8.0 as far as I know.
Yours,
Ann-Marie|||On Wed, 23 Mar 2005 18:19:57 +0100, harry wrote:

>Hello everybody.
>What mean if server is runninf in the default 80 mode
>What are 60, 65,70 mode.
>Thanks for all respond.
>
Hi Harry,
That's the compatibility mode.
60, 65, and 70 indicate that SQL Server takes some steps to pretend to
be a SQL Server 6.0, 6.5, or 7.0 installation, rather than SQL Server
2000. Some new commands are not available in the old compatibility
modes. Some fixed bugs will reappear in the old compatibility modes. And
some discontinued functions are still avaialable in the compatibility
modes.
Note that compatibility mode is a database setting - it doesn't affect
all databases on the server, just one - but it can't be switched on an
ad-hoc basis in case you need old behaviour AND new functionality.
Also note that the compatibility is limited. Many discuontinued or
changed commands, options or functionalities remain unavailable or
changed even when running at an older compatibility level.
Best, Hugo
--
(Remove _NO_ and _SPAM_ to get my e-mail address)