.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

How to increase databases that will show in object explorer

Posted By:      Posted Date: April 10, 2011    Points: 0   Category :

I am using a remote database that has over 2500 databases registered on it.

Unfortunately for me I can not list the databases in the Object Explorer pane anymore.  I have to use my Object Details window for the list of databases. 

In SQL Server 2000 you could specify that you wanted to only expand a tree view of database objects from a specified node - this is missing in SQL Express 2008.  I also would like to be able to Filter the database views to only list MY database, instead of the 2500 + this server hosts.

I see the icon 'filter' on the toolbar, but it's disabled.   How can I get my database to show up again in the Object Explorer instead of the Object Details window (F7).

OR How can I increase the limit of 2500 databases that will show in the Object Explorer.   I can see why Microsoft set this limit ? But I can't see why they didn't allow any filtering OF that list.  It's just kludgy to say- anything over aggregate count of 2500 will mandate the entire list will no longer show in Object Explorer.  I'd hope to see a feature that lets me say- ONLY show databases that match by THIS pattern - or specific name.  PECULIAR I explicitly SET the database to connect to in the Options during database registration ? But that information seems to be left out of the equation on what to show

View Complete Post

More Related Resource Links

Hide inaccessible databases from object Explorer


Hi All

Does anybody know if it is possible to hide databases in the object explorer which the user doesn' t have access too

I currently connect to a shared hosting solution and can see all of the databases on the server approx 80 + and it becomes a bit of chore to find my 3 databases in this growing list .



Video: The Access Show: Managing Access Databases with SharePoint

Steve Greenberg recently gave a great talk at the SharePoint Developers Conference about how Access 2010 and Access Services enable organizations to provide better oversight of Access development. Steve and Clint walk you through the key points of this hit session. (Length: 42:57)

Video: The Access Show: Demo of Microsoft Access 2010 Services and Web Databases

Ryan McMinn and Clint Covington have a big announcement for us - Access Services is new functionality as part of SharePoint 2010 that allows users to create databases with forms and reports that run in the browser. (Length: 24:00)

Exception when login with sa in Object Explorer within MSSM Studio

Has anyone got an idea what might have caused the following. I have been able to login using SQL Server Authentication using the sa account with no problems within the object explorer. Not sure why I get an error (see below) when I try and login today. I can use the sa account via VS2010 IDE to connect to SQL Server, I can use sa account going via Database Engine Query within MSSM Studio, which uses the same SQL Server Authentication dialog. But when trying to connect via Object Explorer I get the following error. TITLE: Connect to Server ------------------------------ Cannot connect to --------- ------------------------------ ADDITIONAL INFORMATION: An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) ------------------------------ A severe error occurred on the current command.  The results, if any, should be discarded. A severe error occurred on the current command.  The results, if any, should be discarded. (Microsoft SQL Server, Error: 0) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=0&LinkId=20476 ------------------------------ BUTTONS: OK ------------------------------ The Event Log gives an error of: A user request from the session with SPID 51 generated a fatal exception. SQL Server is terminating this session. Contact Produc

Object Cache: The super user account utilized by the cache is not configured. This can increase the

Hi im having the following error in the windows event viewer Object Cache: The super user account utilized by the cache is not configured. This can increase the number of cache misses, which causes the page requests to consume unneccesary system resources.  To configure the account use the following command 'stsadm -o setproperty -propertyname portalsuperuseraccount -propertyvalue account -url webappurl'. The account should be any account that has Full Control access to the SharePoint databases but is not an application pool account.  Additional Data:  Current default super user account: SHAREPOINT\system after this the computer starts working slowly and slowly The account that the log shows is the aplication pool account of the first site collection I created   I followed the instrucctions in this link: http://technet.microsoft.com/en-us/library/ff758656.aspx I set new accounts to the superuser and super reader I also tried using the same account that the first error showed has superuser and super reader However  I always get this error when I try to access the Site Collection after performing this The user does not exist or is not unique.<nativehr>0x81020054</nativehr><nativestack></nativestack> In the sharepoint log I get this same error plus this Could not get token super user token, reverting to system account.&

How to show link file extension (lnk) in Explorer

My folders normally shows the file name extension.  But I have a folder full of window links and DOS links. I'm sure that is not the correct termioligy but it is the best I can do. I think I'm talking about .lnk and maybe .pif files. Anyway, the extension do not show in the folder listings. Can I make them show?   Thanks  

Why is 2005 EM -- Object explorer, programmability, tables locksup?

Why is 2005 EM -- Object explorer, programmability, tables locks up while rebuild index job on that database running?

Object Explorer/Server Explorer Error

I have just installed the released VS2005 as well as the released SQL2005.  When ever I try to browse my SQL Server with either the Object Explorer in MS SQL Server Management Studio or the Server Explorer in VS2005 I get the following error:

Unable to cast COM object of type 'System.__ComObject' to interface type 'Microsoft.VisualStudio.OLE.Interop.IServiceProvider'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{6D5140C1-7436-11CE-8034-00AA006009FA}' failed due to the following error: No such interface supported (Exception from HRESULT: 0x80004002 (E_NOINTERFACE)).

Does any one have possible solutions for me? Any help would be greatly appreciated.


Can execute proc but can't see it in SSMS object explorer


I have setup a user account that has limited rights to execute certain stored procedures.  I can execute these procedures but when I login into SSMS with this user I can't see these sprocs in the object explorer list.  Is there a special permission this user needs to be able to enumerate available sprocs?

I'm running SQL Server 2008 R2 x64.

SSMS/sqlwb.exe hangs when expanding indexes on table in object explorer when table has 10 or more in

Greetings, I have had an anoying problem in SSMS for some time, it seems to hang in the object explorer when I try to expand indexes on a table that has 10 or more indexes. It works fine when we have fewer indexes but when there are 10 or 12, it opens up and shows the indexes and you can work with them (script them, drop, etc.) but the "stop" button in object explorer shows red and is unresponsive as in you can't click and stop it. Eventually I will shut down SSMS and reopen to clear it, but in task manager there is still the sqlwb.exe running and its using 50% or more of the CPU and I have to end that process. I am running SQL 2005 management studio 9.00.4035.00. Any ideas on a fix out there would be appreciated.

how to make VS Intellisense show complex object's properties for result of Ajax call?



I've create a WCF webservice and created a proxy to the service using ScriptManager.

I can see the created a proxy class, and intellisense pops up the methods of the webservice (great!!). But, I can't see the properties of the method params, return types.

The webservice method:

searchResponse DBSearch.Search(searchRequest)

have comlex types as a parameter (searchRequest) and a return type (searchResponse).

Intellisense does recognize these types, but I can not see the properties (javacript does);


var _searchRequest = new DBSearch.SearchRequest; (intellisense knows type SearchRequest)

_searchRequest.query = "liver lacerations"; (intellisense doesn't know it's property 'query')

_searchRequest.searchOptions = "modality=mri";

Obviously, with javascript, var _searchRequest is not typed, but is there a way to hint intellisense into the properties of the class?



?? SSMS "Object Explorer Details" Can't Find Constraints ??


Hi everyone,

I'm using SQL Server Management Studio 2008 R2.

As you know, using the "Object Explorer Details" window (pressing F7) you can see details related to the item selected in "Object Explorer". For example, (assuming you have Northwind installed), select the Northwind database in "Object Explorer" and press F7.

Now, in the "Search" bar at the top of the"Object Explorer Window", let's search for the "DF_Orders_Frieght" constraint defined in the "Orders" table. Just type, "DF_Orders_Freight" in the Search box and press Enter. For some reason, SSMS cannot find the constraint, or any constraint, for that matter. There seems to be a similar problem is searching for column names.

The Search box is certainly a nice feature but why doesn't it find column names or constraint names? It's especially annoying when a constraint fails and we need to find out where that constraint is defined.

Thanks much

Thinking about new C# method prototypes: object as dictionary

I recently had to write a small Flickr API. I know many .Net API for Flickr already exist but I needed one for a Silverlight application. Whatever, it's only about building some querystrings so I did it by myself. It's been an opportunity to think again about a classical question: how to pass parameters to a method ?

Imagine you have a generic method to call some Flickr functions.

C# Object Oriented Programming

So far in C# Essentials we have looked at the basics of programming in C# such as variable types and flow control. Although it would be possible to write a functional program using these techniques, there is much more to becoming a proficient C# programmer. C# is, above all, an object oriented programming language and as such any C# programmer will be expected to create object-oriented applications using this language.

Object Oriented Programming

Four core concept of OOP Object Oriented Programming. 1.Inheritance, 2.Polymorphism, 3.Abstraction and 4.Encapsulation

Object-Oriented Programming Concepts

This is the first in a series of articles describing the use of object-oriented programming techniques as implemented by the C# programming language. This series follows the C# Fundamentals tutorial that beginners are advised to read first.

GridView control to show master-child or master-slave data, written in c#, asp.net

I previously made a master slave datagrid using Visual Studio 2003 .Net (original article) that would allow users to show data to clients using collapse and expand features. These features however did not carry over to gridview for many users. This tutorial will explaing how to create a collapsable/expandable gridview in frameworks 2.0 and higher
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend