I am going to transfer a database project from MSSQL7 to MSSQL 2000. Can
the newer database import the MSSQL7 project easily and without one
needing to change views and stored procedures etc?
Thanks in advance,
You should have few, if any, problems migrating from SQL Server 7 to SQL
Server 2000. The section "Upgrading an Existing Installation of SQL Server"
(instsql.chm::/in_overview_2xtf.htm) in the SQL Server 2000 Books Online
discusses going from SS7 to SS2K
Please reply only to the newsgroups.
When posting, inclusion of SQL (CREATE TABLE ..., INSERT ..., etc.) which
can be cut and pasted into Query Analyzer is appreciated.
> I am going to transfer a database project from MSSQL7 to MSSQL 2000. Can
> the newer database import the MSSQL7 project easily and without one
> needing to change views and stored procedures etc?
> Thanks in advance,
> Martin Larsen
I have lately changed the server where my application was running from
a windows NT4/MSSQL7.0 to Windows 2000/MSSQL2000,
My application is made with visual c++.
Before the application was running fine, and it was accessing the
database without problems, now when I have migrated the application
sometimes fails when trying to log into the database.
I get the following error:
NULL DBPROCESS pointer encoutred.
The strange part of this case is that the problem occurs maybe 50% of
times the application connects to the database.
In an other hand I have a php application that is running on the same
server, same database, and didn't suffer from any problem.
Any help would be appretiated.