<div>
What is the problem you are trying to rid yourself of? &nbsp;
</div>


What is the problem you are trying to rid yourself of?  

<div>
did you read <a href="https://www.experts-exchange.com/questions/24325006/What-does-Reserved-space-mean.html" rel="ugc">https://www.experts-exchange.com/questions/24325006/What-does-Reserved-space-mean.html</a>&nbsp;
</div>


did you read https://www.experts-exchange.com/questions/24325006/What-does-Reserved-space-mean.html [https://www.experts-exchange.com/questions/24325006/What-does-Reserved-space-mean.html] 

<div>
No I did not. &nbsp;Now that I have, do you have a test environment?
</div>


No I did not.  Now that I have, do you have a test environment?

<div>
severval as db is over 10gb i thought best to restore on couple for testing
</div>


severval as db is over 10gb i thought best to restore on couple for testing

<div>
With these types of things, the truth of &quot;Will I benefit from this change?&quot; are typically only able to be answered by trying it out. &nbsp;Some solutions like this will benefit some but not all.
</div>


With these types of things, the truth of "Will I benefit from this change?" are typically only able to be answered by trying it out.  Some solutions like this will benefit some but not all.

<div>
I guess you will not get any benifit out of it, microsoft says &quot;Now automatically configured. Setting has no effect.&quot;<br />
<br />
have a look at <br />
<br />
<a href="http://msdn.microsoft.com/en-us/library/ms143729.aspx" rel="ugc">http://msdn.microsoft.com/en-us/library/ms143729.aspx</a><br />

</div>


I guess you will not get any benifit out of it, microsoft says "Now automatically configured. Setting has no effect."

have a look at

http://msdn.microsoft.com/en-us/library/ms143729.aspx [http://msdn.microsoft.com/en-us/library/ms143729.aspx]


<div>
that is for SQL Server 2008 not 2000
</div>


<div>
<div class="content wysiwyg-content">
Hello again been tasked with whether we can/ should change SP_CONFIGURE 'open objects'<br />
<br />
at the mo it is at 2147483647 bytes <br />
<br />
after reading <a href="http://support.microsoft.com/kb/924947" rel="ugc nofollow">http://support.microsoft.com/kb/924947</a>&nbsp;and others provided in related question, my gov thinks this will help us?<br />
<br />
I am unsure, this is for sql 2000
</div>
</div>


Hello again been tasked with whether we can/ should change SP_CONFIGURE 'open objects'

at the mo it is at 2147483647 bytes 

after reading http://support.microsoft.com/kb/924947 and others provided in related question, my gov thinks this will help us?

I am unsure, this is for sql 2000

SP_CONFIGURE

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.