November 29, 2010 at 4:41 am
Hi,
i have a problem to view the list of stored procedures in a database using SSMS on sqlserver 2008.i have 100 databases with having lot of sprocs. when i click on stored procedures folder of a particular datbase , i am getting the following message as " see object explorer details for objects in this folder". I know we will get the sproc information by pressing F7 or using sysobjects. But i want to know exactly what causing this? How can i resolve this.
Thanks in advance
Regards,
Rock..
November 29, 2010 at 4:52 am
rockingadmin (11/29/2010)
i have a problem to view the list of stored procedures in a database using SSMS on sqlserver 2008.i have 100 databases with having lot of sprocs. when i click on stored procedures folder of a particular datbase , i am getting the following message as " see object explorer details for objects in this folder". I know we will get the sproc information by pressing F7 or using sysobjects. But i want to know exactly what causing this? How can i resolve this.
Do you have a huge number of procedures in offending database, don't you?
I've heard about this SS2K8 issue when number of objects exceeds certain number.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.November 29, 2010 at 5:01 am
Yes. there are around 1500 sprocs in the database.How can i resolve this one?
November 29, 2010 at 5:24 am
rockingadmin (11/29/2010)
Yes. there are around 1500 sprocs in the database.How can i resolve this one?
As I remember it this is more of a "feature" than a "bug" so there is no way to resolve it 😀
I would research Microsoft KB and apply available SPs on a test server - 1,500 storeprocs is a little low of a value for this to happen but I do remember it was related to a 64K limit on open windows.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.November 29, 2010 at 2:02 pm
Are you able to apply a filter?
November 30, 2010 at 9:36 pm
I can able to use the Filter and Search.
November 30, 2010 at 9:47 pm
What SP level are you at?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 2, 2010 at 5:27 am
are you talking about service pack? if yes then it is sp2.
December 3, 2010 at 5:59 am
any updates on this issue?
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply