How to install SQL Server 2000 Service PAck 3a on the Active-Passive SQL Server 2000.
I tried installing through virtual server but the screen was frozen at password validation.
Can we stop the cluster Admin services and install the SP3a on the shared drive which is the virtual sql server.
I installed SP3a of SQL Server 2000 on the SQL Server.
When I executing select @@version still it is showing
SQL Server 2000 with Service Pack 3.
I believe it should be showing 3a.
Please let me know.
In our retail business environment all the DTS packages are sitting on one server as central repository where data's are moving among different applications.
Some DTS packages are such Export/Import,ActiveX script & VB Script.
We have configured as fixed memory for SQL Server on that box as COM...
I believe you have restricted the size of this database to 2GB.
Follow is procedure below to fix this error;
Right click the database and select the properties.
Then Select the data files tab.
GO To File properties and check the Automatically grow file
and select the file growth By percent as...
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.