Difference between sql 6.5 and 7.0

Hi,
I have a sql server 7.0 with some databases with
compatibility level 6.5.
I want to "upgrade" those databases to compatibility level
7.0. What kind of problems should i expect ?
My developers are asking me for some document with the
programming differences between 6.5 and 7.0, something
that works fine in 6.5 but doesn't work in 7.0.
Thanks,
JCI think that there are about 90 pages in SQL Server 7.0 Books Online about compatibility issues
between 6.5 and 7.0. This is the place for your developers.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver
"Julio Carvalho" <jc.carvalho@.terra.com.br> wrote in message
news:0d7501c3664e$cb490b70$a301280a@.phx.gbl...
> Hi,
> I have a sql server 7.0 with some databases with
> compatibility level 6.5.
> I want to "upgrade" those databases to compatibility level
> 7.0. What kind of problems should i expect ?
> My developers are asking me for some document with the
> programming differences between 6.5 and 7.0, something
> that works fine in 6.5 but doesn't work in 7.0.
> Thanks,
> JC|||Of course, the 90 pages covers lots of issues that don't apply in this case
since the database is already in SQL Server 7.0. The issues of importance
are those covered by sp_dbcmptlevel 65, and it's a pretty small list, though
it could be a lot of work to address the issues in some applications. Books
Online is definitely the place to go for this information.
--
Hal Berenson, SQL Server MVP
True Mountain Group LLC
"Tibor Karaszi" <tibor.please_reply_to_public_forum.karaszi@.cornerstone.se>
wrote in message news:%23v4dzMlZDHA.388@.TK2MSFTNGP10.phx.gbl...
> I think that there are about 90 pages in SQL Server 7.0 Books Online about
compatibility issues
> between 6.5 and 7.0. This is the place for your developers.
> --
> Tibor Karaszi, SQL Server MVP
> Archive at: http://groups.google.com/groups?oi=djq&as
ugroup=microsoft.public.sqlserver
>
> "Julio Carvalho" <jc.carvalho@.terra.com.br> wrote in message
> news:0d7501c3664e$cb490b70$a301280a@.phx.gbl...
> > Hi,
> >
> > I have a sql server 7.0 with some databases with
> > compatibility level 6.5.
> >
> > I want to "upgrade" those databases to compatibility level
> > 7.0. What kind of problems should i expect ?
> >
> > My developers are asking me for some document with the
> > programming differences between 6.5 and 7.0, something
> > that works fine in 6.5 but doesn't work in 7.0.
> >
> > Thanks,
> >
> > JC
>|||Ahh, thanks for catching that, Hal. Somewhere I missed the fact that it was already on 7.0...
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver
"Hal Berenson" <haroldb@.truemountainconsulting.com> wrote in message
news:%23kTObZtZDHA.1492@.TK2MSFTNGP12.phx.gbl...
> Of course, the 90 pages covers lots of issues that don't apply in this case
> since the database is already in SQL Server 7.0. The issues of importance
> are those covered by sp_dbcmptlevel 65, and it's a pretty small list, though
> it could be a lot of work to address the issues in some applications. Books
> Online is definitely the place to go for this information.
> --
> Hal Berenson, SQL Server MVP
> True Mountain Group LLC
>
> "Tibor Karaszi" <tibor.please_reply_to_public_forum.karaszi@.cornerstone.se>
> wrote in message news:%23v4dzMlZDHA.388@.TK2MSFTNGP10.phx.gbl...
> > I think that there are about 90 pages in SQL Server 7.0 Books Online about
> compatibility issues
> > between 6.5 and 7.0. This is the place for your developers.
> >
> > --
> > Tibor Karaszi, SQL Server MVP
> > Archive at: http://groups.google.com/groups?oi=djq&as
> ugroup=microsoft.public.sqlserver
> >
> >
> > "Julio Carvalho" <jc.carvalho@.terra.com.br> wrote in message
> > news:0d7501c3664e$cb490b70$a301280a@.phx.gbl...
> > > Hi,
> > >
> > > I have a sql server 7.0 with some databases with
> > > compatibility level 6.5.
> > >
> > > I want to "upgrade" those databases to compatibility level
> > > 7.0. What kind of problems should i expect ?
> > >
> > > My developers are asking me for some document with the
> > > programming differences between 6.5 and 7.0, something
> > > that works fine in 6.5 but doesn't work in 7.0.
> > >
> > > Thanks,
> > >
> > > JC
> >
> >
>sql