Problem with In Place Upgrade of Named Instance?

I have two software products that are accessing the same MSDE Database instance. I recently upgraded the MSDE instance to SQL Express using the in place method. The upgrade runs with success. However, one scenerio is breaking both software products.

1. Product A is not installed

2. An older version of Product B which uses MSDE is intalled.

3. I upgrade the MSDE instance to SQL Express

4. An older version of Product A is installed that uses MSDE.

Note: At this point the install of product A attempts to install an MSDE named instance that is the same as the upgraded instance

5. The install of Product A fails and corrupts the registry keys

6. Now my SQL Express named instance is corrupt and product B can not find the database instance.

Question: Can MSDE and SQL Express run side by side with both having an instance with the same name? I am pretty sure that the answer is going to be No.

If not, how can I prevent this scenerio from occurring. I'm thinking that I will have to do a side by side upgrade creating a new instance with a different name. Then I will have to direct both products to the new named instance. Any ideas or suggestions?

no you can not have the 2 different database engines running with the same instance name. I personally would install the sqlexpress system using the .\SQLEXPRESS instance name as this is the default instance name when using the express or full version visual studio products.

If you do wish to install the systems on the same machine you might be able to direct the instance names by moderfiying the setup ini files on the MSDE System, or the command line tags.

problem with DB after upgrade to 2005

Hi all.
I just ran my first test upgrade from 2000 to 2005 on a system with
several db's. All of them but one seem to be fine. I get a message
that says the following when I try to expand the table list:
Value cannot be null parameter name: context (object explorer)
the details of the message are here:
===================================
Value cannot be null.
Parameter name: context (ObjectExplorer)
--
Program Location:
at
Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NodeContext..ctor(SqlOlapConnectionInfoBase
connection, String name, String context, INodeInformation parent)
at
Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItemBuilder.BuildDynamicItemWithQuery(IList
nodes, INodeInformation source, INavigableItem sourceItem, String
urnQuery, Boolean registerBuilder, Boolean registerBuiltItems)
at
Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItemBuilder.BuildDynamicItem(IList
nodes, INodeInformation source, INavigableItem sourceItem,
IFilterProvider filter)
at
Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItemBuilder.Build(INodeInformation
source, INavigableItem sourceItem, IFilterProvider filter)
at
Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NonContextFilterNavigableItemBuilder.Build(INodeInformation
source, INavigableItem sourceItem, IFilterProvider filter)
at
Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItem.GetChildren()
at
Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.SummaryView.get_Items()
at
Microsoft.SqlServer.Management.UI.VSIntegration.AppIDPackage.ListViewVirtualStorage.CopyItems(ISummaryView
summaryView)
at
Microsoft.SqlServer.Management.UI.VSIntegration.AppIDPackage.ListViewVirtualStorage..ctor(ISummaryView
summaryView, List`1 columnDescriptors)
at
Microsoft.SqlServer.Management.UI.VSIntegration.AppIDPackage.RightPaneListViewer.PopulateView()
Like i said, this is the only db out of 4 user db's that is having
this problem.
any suggestions on where to start?
MeredithHi Meredith
"mryan" wrote:
> Hi all.
> I just ran my first test upgrade from 2000 to 2005 on a system with
> several db's. All of them but one seem to be fine. I get a message
> that says the following when I try to expand the table list:
> Value cannot be null parameter name: context (object explorer)
> the details of the message are here:
> ===================================> Value cannot be null.
> Parameter name: context (ObjectExplorer)
> --
> Program Location:
> at
> Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NodeContext..ctor(SqlOlapConnectionInfoBase
> connection, String name, String context, INodeInformation parent)
> at
> Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItemBuilder.BuildDynamicItemWithQuery(IList
> nodes, INodeInformation source, INavigableItem sourceItem, String
> urnQuery, Boolean registerBuilder, Boolean registerBuiltItems)
> at
> Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItemBuilder.BuildDynamicItem(IList
> nodes, INodeInformation source, INavigableItem sourceItem,
> IFilterProvider filter)
> at
> Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItemBuilder.Build(INodeInformation
> source, INavigableItem sourceItem, IFilterProvider filter)
> at
> Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NonContextFilterNavigableItemBuilder.Build(INodeInformation
> source, INavigableItem sourceItem, IFilterProvider filter)
> at
> Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItem.GetChildren()
> at
> Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.SummaryView.get_Items()
> at
> Microsoft.SqlServer.Management.UI.VSIntegration.AppIDPackage.ListViewVirtualStorage.CopyItems(ISummaryView
> summaryView)
> at
> Microsoft.SqlServer.Management.UI.VSIntegration.AppIDPackage.ListViewVirtualStorage..ctor(ISummaryView
> summaryView, List`1 columnDescriptors)
> at
> Microsoft.SqlServer.Management.UI.VSIntegration.AppIDPackage.RightPaneListViewer.PopulateView()
>
> Like i said, this is the only db out of 4 user db's that is having
> this problem.
> any suggestions on where to start?
>
> Meredith
>
There doesn't seem to be much on this error!
http://groups.google.com/groups/search?hl=en&lr=&q=%22Parameter+name%3A+context+%28ObjectExplorer%29%22
Does this error occur for all databases (including master/tempdb or new
ones), if so it is most likely an issue with the installation or tools.
If specific databases, then can you restore a SQL 2000 backup onto the SQL
2005 server and see if it still occurs?
Check the compatibility mode of the original database and the upgraded one.
John|||I know there seems to be nothing really out there on this error. It
is only happening on one db on the server, so I find it unlikely as
well that it is an install issue - even stranger, I can expand the
views list, and other objects in that DB just fine. The compatibility
modes are the same (80). My next step is to do a restore, but I am
trying to exhaust all other options since it is a 500gig db, and the
restore is going to take 10+ hrs.
Meredith
> There doesn't seem to be much on this error!
> http://groups.google.com/groups/search?hl=en&lr=&q=%22Parameter+name%...
> Does this error occur for all databases (including master/tempdb or new
> ones), if so it is most likely an issue with the installation or tools.
> If specific databases, then can you restore a SQL 2000 backup onto the SQL
> 2005 server and see if it still occurs?
> Check the compatibility mode of the original database and the upgraded one.
> John- Hide quoted text -
> - Show quoted text -|||There really isn't much out there on this. The error is only
happening on the table list of a single user db. The compatibility
mode is the same (80), and it is happening on several different
installs of SSMS. A restore is my last hope since it is a 500gig db
and the restore will take 10+ hrs.
Meredith
> > Meredith
> There doesn't seem to be much on this error!
> http://groups.google.com/groups/search?hl=en&lr=&q=%22Parameter+name%...
> Does this error occur for all databases (including master/tempdb or new
> ones), if so it is most likely an issue with the installation or tools.
> If specific databases, then can you restore a SQL 2000 backup onto the SQL
> 2005 server and see if it still occurs?
> Check the compatibility mode of the original database and the upgraded one.
> John- Hide quoted text -
> - Show quoted text -|||On May 16, 2:26 am, John Bell <jbellnewspo...@.hotmail.com> wrote:
> Hi Meredith
>
>
> "mryan" wrote:
> > Hi all.
> > I just ran my first test upgrade from 2000 to 2005 on a system with
> > several db's. All of them but one seem to be fine. I get a message
> > that says the following when I try to expand the table list:
> > Value cannot be null parameter name: context (object explorer)
> > the details of the message are here:
> > =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D==3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
> > Value cannot be null.
> > Parameter name: context (ObjectExplorer)
> > --
> > Program Location:
> > at
> > Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NodeCont=ext.=AD.ctor(SqlOlapConnectionInfoBase
> > connection, String name, String context, INodeInformation parent)
> > at
> > Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.Navigabl=eIte=ADmBuilder.BuildDynamicItemWithQuery(IList
> > nodes, INodeInformation source, INavigableItem sourceItem, String
> > urnQuery, Boolean registerBuilder, Boolean registerBuiltItems)
> > at
> > Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.Navigabl=eIte=ADmBuilder.BuildDynamicItem(IList
> > nodes, INodeInformation source, INavigableItem sourceItem,
> > IFilterProvider filter)
> > at
> > Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.Navigabl=eIte=ADmBuilder.Build(INodeInformation
> > source, INavigableItem sourceItem, IFilterProvider filter)
> > at
> > Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NonConte=xtFi=ADlterNavigableItemBuilder.Build(INodeInformation
> > source, INavigableItem sourceItem, IFilterProvider filter)
> > at
> > Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.Navigabl=eIte=ADm.GetChildren()
> > at
> > Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.SummaryV=iew.=ADget_Items()
> > at
> > Microsoft.SqlServer.Management.UI.VSIntegration.AppIDPackage.ListViewVi=rtua=ADlStorage.CopyItems(ISummaryView
> > summaryView)
> > at
> > Microsoft.SqlServer.Management.UI.VSIntegration.AppIDPackage.ListViewVi=rtua=ADlStorage..ctor(ISummaryView
> > summaryView, List`1 columnDescriptors)
> > at
> > Microsoft.SqlServer.Management.UI.VSIntegration.AppIDPackage.RightPaneL=istV=ADiewer.PopulateView()
> > Like i said, this is the only db out of 4 user db's that is having
> > this problem.
> > any suggestions on where to start?
> > Meredith
> There doesn't seem to be much on this error!
> http://groups.google.com/groups/search?hl=3Den&lr=3D&q=3D%22Parameter+nam=
e%...
> Does this error occur for all databases (including master/tempdb or new
> ones), if so it is most likely an issue with the installation or tools.
> If specific databases, then can you restore a SQL 2000 backup onto the SQL
> 2005 server and see if it still occurs?
> Check the compatibility mode of the original database and the upgraded on=e=2E
> John- Hide quoted text -
> - Show quoted text -
I figured it out! The problem seems to be that there are two tables
in the DB not owned by dbo. When you query information_schema.tables
the table_schema value for both is NULL. Of course I can't modify
ownership or drop either table, so I am going to have to restore a new
copy of the db, with the ownership of those tables fixed.
Meredith|||Hi Meredith
"mryan" wrote:
> I figured it out! The problem seems to be that there are two tables
> in the DB not owned by dbo. When you query information_schema.tables
> the table_schema value for both is NULL. Of course I can't modify
> ownership or drop either table, so I am going to have to restore a new
> copy of the db, with the ownership of those tables fixed.
> Meredith
>
Does the user who owned the object exist in the restored system and is that
user associated to a login?
John

problem with DB after upgrade to 2005

Hi all.
I just ran my first test upgrade from 2000 to 2005 on a system with
several db's. All of them but one seem to be fine. I get a message
that says the following when I try to expand the table list:
Value cannot be null parameter name: context (object explorer)
the details of the message are here:
===================================
Value cannot be null.
Parameter name: context (ObjectExplorer)
Program Location:
at
Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NodeContext..
ctor(SqlOlapConnectionInfoBase
connection, String name, String context, INodeInformation parent)
at
Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItem
Builder.BuildDynamicItemWithQuery(IList
nodes, INodeInformation source, INavigableItem sourceItem, String
urnQuery, Boolean registerBuilder, Boolean registerBuiltItems)
at
Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItem
Builder.BuildDynamicItem(IList
nodes, INodeInformation source, INavigableItem sourceItem,
IFilterProvider filter)
at
Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItem
Builder.Build(INodeInformation
source, INavigableItem sourceItem, IFilterProvider filter)
at
Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NonContextFil
terNavigableItemBuilder.Build(INodeInformation
source, INavigableItem sourceItem, IFilterProvider filter)
at
Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItem
.GetChildren()
at
Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.SummaryView.g
et_Items()
at
Microsoft.SqlServer.Management.UI.VSIntegration.AppIDPackage.ListViewVirtual
Storage.CopyItems(ISummaryView
summaryView)
at
Microsoft.SqlServer.Management.UI.VSIntegration.AppIDPackage.ListViewVirtual
Storage..ctor(ISummaryView
summaryView, List`1 columnDescriptors)
at
Microsoft.SqlServer.Management.UI.VSIntegration.AppIDPackage.RightPaneListVi
ewer.PopulateView()
Like i said, this is the only db out of 4 user db's that is having
this problem.
any suggestions on where to start?
MeredithHi Meredith
"mryan" wrote:

> Hi all.
> I just ran my first test upgrade from 2000 to 2005 on a system with
> several db's. All of them but one seem to be fine. I get a message
> that says the following when I try to expand the table list:
> Value cannot be null parameter name: context (object explorer)
> the details of the message are here:
> ===================================
> Value cannot be null.
> Parameter name: context (ObjectExplorer)
> --
> Program Location:
> at
> Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NodeContext
.ctor(SqlOlapConnectionInfoBase
> connection, String name, String context, INodeInformation parent)
> at
> Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableIt
emBuilder.BuildDynamicItemWithQuery(IList
> nodes, INodeInformation source, INavigableItem sourceItem, String
> urnQuery, Boolean registerBuilder, Boolean registerBuiltItems)
> at
> Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableIt
emBuilder.BuildDynamicItem(IList
> nodes, INodeInformation source, INavigableItem sourceItem,
> IFilterProvider filter)
> at
> Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableIt
emBuilder.Build(INodeInformation
> source, INavigableItem sourceItem, IFilterProvider filter)
> at
> Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NonContextF
ilterNavigableItemBuilder.Build(INodeInformation
> source, INavigableItem sourceItem, IFilterProvider filter)
> at
> Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableIt
em.GetChildren()
> at
> Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.SummaryView
.get_Items()
> at
> Microsoft.SqlServer.Management.UI.VSIntegration.AppIDPackage.ListViewVirtu
alStorage.CopyItems(ISummaryView
> summaryView)
> at
> Microsoft.SqlServer.Management.UI.VSIntegration.AppIDPackage.ListViewVirtu
alStorage..ctor(ISummaryView
> summaryView, List`1 columnDescriptors)
> at
> Microsoft.SqlServer.Management.UI.VSIntegration.AppIDPackage.RightPaneList
Viewer.PopulateView()
>
> Like i said, this is the only db out of 4 user db's that is having
> this problem.
> any suggestions on where to start?
>
> Meredith
>
There doesn't seem to be much on this error!
http://groups.google.com/groups/sea...tExplorer%29%22
Does this error occur for all databases (including master/tempdb or new
ones), if so it is most likely an issue with the installation or tools.
If specific databases, then can you restore a SQL 2000 backup onto the SQL
2005 server and see if it still occurs?
Check the compatibility mode of the original database and the upgraded one.
John|||I know there seems to be nothing really out there on this error. It
is only happening on one db on the server, so I find it unlikely as
well that it is an install issue - even stranger, I can expand the
views list, and other objects in that DB just fine. The compatibility
modes are the same (80). My next step is to do a restore, but I am
trying to exhaust all other options since it is a 500gig db, and the
restore is going to take 10+ hrs.
Meredith

> There doesn't seem to be much on this error!
> http://groups.google.com/groups/sea...ameter+name%...
> Does this error occur for all databases (including master/tempdb or new
> ones), if so it is most likely an issue with the installation or tools.
> If specific databases, then can you restore a SQL 2000 backup onto the SQL
> 2005 server and see if it still occurs?
> Check the compatibility mode of the original database and the upgraded one
.
> John- Hide quoted text -
> - Show quoted text -|||There really isn't much out there on this. The error is only
happening on the table list of a single user db. The compatibility
mode is the same (80), and it is happening on several different
installs of SSMS. A restore is my last hope since it is a 500gig db
and the restore will take 10+ hrs.
Meredith

> There doesn't seem to be much on this error!
> http://groups.google.com/groups/sea...ameter+name%...
> Does this error occur for all databases (including master/tempdb or new
> ones), if so it is most likely an issue with the installation or tools.
> If specific databases, then can you restore a SQL 2000 backup onto the SQL
> 2005 server and see if it still occurs?
> Check the compatibility mode of the original database and the upgraded one
.
> John- Hide quoted text -
> - Show quoted text -|||On May 16, 2:26 am, John Bell <jbellnewspo...@.hotmail.com> wrote:
> Hi Meredith
>
>
> "mryan" wrote:
>
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D[vbc
ol=seagreen]
>
>
>
ext.=AD. ctor(SqlOlapConnectionInfoBase[vbcol=sea
green]
eIte=ADmBuilder. BuildDynamicItemWithQuery(IList[vbcol=se
agreen]
eIte=ADmBuilder.BuildDynamicItem(IList[vbcol=seagreen]
eIte=ADmBuilder.Build(INodeInformation[vbcol=seagreen]
xtFi=ADlterNavigableItemBuilder.Build(INodeInformation[vbcol=seagreen]
eIte=ADm.GetChildren()[vbcol=seagreen]
iew.=ADget_Items()[vbcol=seagreen]
rtua=ADlStorage.CopyItems(ISummaryView[vbcol=seagreen]
rtua=ADlStorage..ctor(ISummaryView[vbcol=seagreen]
istV=ADiewer.PopulateView()[vbcol=seagreen]
>
>
>
> There doesn't seem to be much on this error!
> http://groups.google.com/groups/sea...2Parameter+nam=
e%...
> Does this error occur for all databases (including master/tempdb or new
> ones), if so it is most likely an issue with the installation or tools.
> If specific databases, then can you restore a SQL 2000 backup onto the SQL
> 2005 server and see if it still occurs?
> Check the compatibility mode of the original database and the upgraded on=
e=2E
> John- Hide quoted text -
> - Show quoted text -
I figured it out! The problem seems to be that there are two tables
in the DB not owned by dbo. When you query information_schema.tables
the table_schema value for both is NULL. Of course I can't modify
ownership or drop either table, so I am going to have to restore a new
copy of the db, with the ownership of those tables fixed.
Meredith|||Hi Meredith
"mryan" wrote:
> I figured it out! The problem seems to be that there are two tables
> in the DB not owned by dbo. When you query information_schema.tables
> the table_schema value for both is NULL. Of course I can't modify
> ownership or drop either table, so I am going to have to restore a new
> copy of the db, with the ownership of those tables fixed.
> Meredith
>
Does the user who owned the object exist in the restored system and is that
user associated to a login?
John

problem with DB after upgrade to 2005

Hi all.
I just ran my first test upgrade from 2000 to 2005 on a system with
several db's. All of them but one seem to be fine. I get a message
that says the following when I try to expand the table list:
Value cannot be null parameter name: context (object explorer)
the details of the message are here:
===================================
Value cannot be null.
Parameter name: context (ObjectExplorer)
Program Location:
at
Microsoft.SqlServer.Management.UI.VSIntegration.Ob jectExplorer.NodeContext..ctor(SqlOlapConnectionIn foBase
connection, String name, String context, INodeInformation parent)
at
Microsoft.SqlServer.Management.UI.VSIntegration.Ob jectExplorer.NavigableItemBuilder.BuildDynamicItem WithQuery(IList
nodes, INodeInformation source, INavigableItem sourceItem, String
urnQuery, Boolean registerBuilder, Boolean registerBuiltItems)
at
Microsoft.SqlServer.Management.UI.VSIntegration.Ob jectExplorer.NavigableItemBuilder.BuildDynamicItem (IList
nodes, INodeInformation source, INavigableItem sourceItem,
IFilterProvider filter)
at
Microsoft.SqlServer.Management.UI.VSIntegration.Ob jectExplorer.NavigableItemBuilder.Build(INodeInfor mation
source, INavigableItem sourceItem, IFilterProvider filter)
at
Microsoft.SqlServer.Management.UI.VSIntegration.Ob jectExplorer.NonContextFilterNavigableItemBuilder. Build(INodeInformation
source, INavigableItem sourceItem, IFilterProvider filter)
at
Microsoft.SqlServer.Management.UI.VSIntegration.Ob jectExplorer.NavigableItem.GetChildren()
at
Microsoft.SqlServer.Management.UI.VSIntegration.Ob jectExplorer.SummaryView.get_Items()
at
Microsoft.SqlServer.Management.UI.VSIntegration.Ap pIDPackage.ListViewVirtualStorage.CopyItems(ISumma ryView
summaryView)
at
Microsoft.SqlServer.Management.UI.VSIntegration.Ap pIDPackage.ListViewVirtualStorage..ctor(ISummaryVi ew
summaryView, List`1 columnDescriptors)
at
Microsoft.SqlServer.Management.UI.VSIntegration.Ap pIDPackage.RightPaneListViewer.PopulateView()
Like i said, this is the only db out of 4 user db's that is having
this problem.
any suggestions on where to start?
Meredith
Hi Meredith
"mryan" wrote:

> Hi all.
> I just ran my first test upgrade from 2000 to 2005 on a system with
> several db's. All of them but one seem to be fine. I get a message
> that says the following when I try to expand the table list:
> Value cannot be null parameter name: context (object explorer)
> the details of the message are here:
> ===================================
> Value cannot be null.
> Parameter name: context (ObjectExplorer)
> --
> Program Location:
> at
> Microsoft.SqlServer.Management.UI.VSIntegration.Ob jectExplorer.NodeContext..ctor(SqlOlapConnectionIn foBase
> connection, String name, String context, INodeInformation parent)
> at
> Microsoft.SqlServer.Management.UI.VSIntegration.Ob jectExplorer.NavigableItemBuilder.BuildDynamicItem WithQuery(IList
> nodes, INodeInformation source, INavigableItem sourceItem, String
> urnQuery, Boolean registerBuilder, Boolean registerBuiltItems)
> at
> Microsoft.SqlServer.Management.UI.VSIntegration.Ob jectExplorer.NavigableItemBuilder.BuildDynamicItem (IList
> nodes, INodeInformation source, INavigableItem sourceItem,
> IFilterProvider filter)
> at
> Microsoft.SqlServer.Management.UI.VSIntegration.Ob jectExplorer.NavigableItemBuilder.Build(INodeInfor mation
> source, INavigableItem sourceItem, IFilterProvider filter)
> at
> Microsoft.SqlServer.Management.UI.VSIntegration.Ob jectExplorer.NonContextFilterNavigableItemBuilder. Build(INodeInformation
> source, INavigableItem sourceItem, IFilterProvider filter)
> at
> Microsoft.SqlServer.Management.UI.VSIntegration.Ob jectExplorer.NavigableItem.GetChildren()
> at
> Microsoft.SqlServer.Management.UI.VSIntegration.Ob jectExplorer.SummaryView.get_Items()
> at
> Microsoft.SqlServer.Management.UI.VSIntegration.Ap pIDPackage.ListViewVirtualStorage.CopyItems(ISumma ryView
> summaryView)
> at
> Microsoft.SqlServer.Management.UI.VSIntegration.Ap pIDPackage.ListViewVirtualStorage..ctor(ISummaryVi ew
> summaryView, List`1 columnDescriptors)
> at
> Microsoft.SqlServer.Management.UI.VSIntegration.Ap pIDPackage.RightPaneListViewer.PopulateView()
>
> Like i said, this is the only db out of 4 user db's that is having
> this problem.
> any suggestions on where to start?
>
> Meredith
>
There doesn't seem to be much on this error!
[url]http://groups.google.com/groups/search?hl=en&lr=&q=%22Parameter+name%3A+context+%2 8ObjectExplorer%29%22[/url]
Does this error occur for all databases (including master/tempdb or new
ones), if so it is most likely an issue with the installation or tools.
If specific databases, then can you restore a SQL 2000 backup onto the SQL
2005 server and see if it still occurs?
Check the compatibility mode of the original database and the upgraded one.
John
|||I know there seems to be nothing really out there on this error. It
is only happening on one db on the server, so I find it unlikely as
well that it is an install issue - even stranger, I can expand the
views list, and other objects in that DB just fine. The compatibility
modes are the same (80). My next step is to do a restore, but I am
trying to exhaust all other options since it is a 500gig db, and the
restore is going to take 10+ hrs.
Meredith

> There doesn't seem to be much on this error!
> http://groups.google.com/groups/search?hl=en&lr=&q=%22Parameter+name%...
> Does this error occur for all databases (including master/tempdb or new
> ones), if so it is most likely an issue with the installation or tools.
> If specific databases, then can you restore a SQL 2000 backup onto the SQL
> 2005 server and see if it still occurs?
> Check the compatibility mode of the original database and the upgraded one.
> John- Hide quoted text -
> - Show quoted text -
|||There really isn't much out there on this. The error is only
happening on the table list of a single user db. The compatibility
mode is the same (80), and it is happening on several different
installs of SSMS. A restore is my last hope since it is a 500gig db
and the restore will take 10+ hrs.
Meredith

> There doesn't seem to be much on this error!
> http://groups.google.com/groups/search?hl=en&lr=&q=%22Parameter+name%...
> Does this error occur for all databases (including master/tempdb or new
> ones), if so it is most likely an issue with the installation or tools.
> If specific databases, then can you restore a SQL 2000 backup onto the SQL
> 2005 server and see if it still occurs?
> Check the compatibility mode of the original database and the upgraded one.
> John- Hide quoted text -
> - Show quoted text -
|||On May 16, 2:26 am, John Bell <jbellnewspo...@.hotmail.com> wrote:
> Hi Meredith
>
>
> "mryan" wrote:
>
>
>
>
> There doesn't seem to be much on this error!
> http://groups.google.com/groups/search?hl=en&lr=&q=%22Parameter+name%...
> Does this error occur for all databases (including master/tempdb or new
> ones), if so it is most likely an issue with the installation or tools.
> If specific databases, then can you restore a SQL 2000 backup onto the SQL
> 2005 server and see if it still occurs?
> Check the compatibility mode of the original database and the upgraded one.
> John- Hide quoted text -
> - Show quoted text -
I figured it out! The problem seems to be that there are two tables
in the DB not owned by dbo. When you query information_schema.tables
the table_schema value for both is NULL. Of course I can't modify
ownership or drop either table, so I am going to have to restore a new
copy of the db, with the ownership of those tables fixed.
Meredith
|||Hi Meredith
"mryan" wrote:
> I figured it out! The problem seems to be that there are two tables
> in the DB not owned by dbo. When you query information_schema.tables
> the table_schema value for both is NULL. Of course I can't modify
> ownership or drop either table, so I am going to have to restore a new
> copy of the db, with the ownership of those tables fixed.
> Meredith
>
Does the user who owned the object exist in the restored system and is that
user associated to a login?
John