• Collation of paged stored procedures in sqlserver 2000 and 2005 page 1 / 3


    The paging stored procedure of SQL Server 2005 is divided into three versions, one is not optimized, the other is optimized, and the last one supports join. The paging stored procedure of SQL Server 2000 can also run on SQL Server 2005, but its performance is not as good as that of SQL Server 2005. […]

  • Solution to SQL Server 2000 9003 error (SQL2000 only)


    About sqlserver 9003 error resolution only for SQL2000: Unable to open new database ‘pos’. Create database aborted. (Microsoft SQL server, error: 9003)“ Looking at the 9003 error, I think it may be due to the log file. Looking at the database file, I think of the DBCC CHECKDB instruction The method is as follows: 1. […]

  • MSSQL 2000 Use Help (sql server concise tutorial)


    SQL SERVER 2000 Installation Tutorial: //www.jb51.net/article/37380.htm 1. If your SQL space is open, please open your local SQL server enterprise manager, as follows: 2. Click on the right button of the SQL server group and select the new SQL server registration as follows: 3. Pop up the SQL server registration wizard and click on the […]

  • SQL Server 2000 Pushes Data Graphics Tutorial to SQL Server 2008 R2


    A recent project is to get some data that exists on other servers. For security reasons, it is implemented by pushing other servers to our servers. Our servers use SQL Server 2008 R2, other “servers” use SQL Server 2000, but also run on Windows XP, the whole process encountered some problems, also referred to some […]

  • Data Conversion Method between SQL Server 2005 and SQL 2000


    In 2005, both performance and security are enhanced by SQL SERVER2000. There are many enterprises using 2005 or some users using 2000 and 2005 at the same time. Then the conversion of double data is involved in the process. Today, we will look at the implementation of the relevant methods: My implementation environment is introduced: […]