I am trying to upgrade my SQL Server from a NT4+SQL7 to Win2K+SQL2000.
Here are the steps:
Install/Work order on "virgin" double Xeon server:
1) Win2K Server
2) SP3 for Win2K
3) SQL Server 7.0
4) SP3 for SQL Server 7.0
5) Restore full backup of master database.
6) Restore full backups of 10 databases (one named Q5)
7) Installed SQL Server 2000 Upgrade
8) SP3 for SQL Server 2000
At this point I tested my apps with the several databases and all looked good. But now I need to create a transactional publication on the Q5 database named Q5Pub.
First I go with the wizard but when he gets to the point where he is "Creating the Publication" he offers me the following:
SQL Server Enterprise Manager could not create publication 'Q5Pub' from database 'Q5'.
Error 8144: Procedure or function sp_MSadd_publication has too many arguments specified.
I then try using the Query Analyzer with the following statement: