Besides that, there are more things that you would like to take care off. When you attach a SQL 7.0 database to SQL Server 2000, it upgrades the database and with that come some issues that you may want to check beforehand. Check out FAQ183-1781 for more details.
Two issues that a co-worker come across...
In the Connection strings to a SQL Server 7.0 database it is not necessary to specify "trusted_ connection = yes" to get a trusted connection. In 2K you have to specify that.
DTS packages containing Copy SQL Server Objects tasks, where the source and destination are both SQL Server 7.0 databases, may fail if the source server is upgraded to SQL Server 2000 and the package is executed. Check out "Copy Server Object Tasks" in MSDN for more details.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.