If I change the Maximum Memory option (sp_configure or vai EM), do I need to restart the MSSQL service?
CliveNo restart of the service is required, anymore. At least in SQL 2000. If you do this via sp_configure, you will need to run reconfigure with override.|||Thank you for the quick reply.
No comments:
Post a Comment