[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 314
  • Last Modified:

SP_CONFIGURE

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
0
James Murrell
Asked:
James Murrell
  • 5
  • 3
  • 2
1 Solution
 
dan_nealCommented:
What is the problem you are trying to rid yourself of?  
0
 
James MurrellProduct SpecialistAuthor Commented:
0
 
dan_nealCommented:
No I did not.  Now that I have, do you have a test environment?
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
James MurrellProduct SpecialistAuthor Commented:
severval as db is over 10gb i thought best to restore on couple for testing
0
 
dan_nealCommented:
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.
0
 
James MurrellProduct SpecialistAuthor Commented:
Thanks any more ideas?
0
 
RiteshShahCommented:
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
0
 
James MurrellProduct SpecialistAuthor Commented:
that is for SQL Server 2008 not 2000
0
 
RiteshShahCommented:
sorry, I missed the version in question. have a look at.

http://msdn.microsoft.com/en-us/library/aa196701(SQL.80).aspx

How many database are you using on your server? are you seeing any error about 'Open Object' in your event viewer? I don't think so it will help you much
0
 
James MurrellProduct SpecialistAuthor Commented:
just as i thought
0

Featured Post

Get quick recovery of individual SharePoint items

Free tool – Veeam Explorer for Microsoft SharePoint, enables fast, easy restores of SharePoint sites, documents, libraries and lists — all with no agents to manage and no additional licenses to buy.

  • 5
  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now