Error 21774

When I try to go into the dependencies of a table on my SQL 2k database, I
get the following error message (twice) and then it takes me to the
dependencies screen.
Error 21774: [SQL-DMO] The ID '377104434' was not found in the Views
collection.
Can anyone help me resolve why I am getting this? Thank you.
DavidHi
Is anyone creating/deleting objects whilst you are running this process?
Have you run DBCC CHECKDB on this database?
John
"David Chase" <dlchase@.lifetimeinc.com> wrote in message
news:exrzmRwCGHA.1384@.TK2MSFTNGP11.phx.gbl...
> When I try to go into the dependencies of a table on my SQL 2k database, I
> get the following error message (twice) and then it takes me to the
> dependencies screen.
> Error 21774: [SQL-DMO] The ID '377104434' was not found in the Views
> collection.
> Can anyone help me resolve why I am getting this? Thank you.
> David
>|||Nobody was in the database except me.
I ran CHECKDB and got the message below at the end.
CHECKDB found 0 allocation errors and 0 consistency errors in database
'MCFIData'.
David
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:uh2SRbwCGHA.3920@.tk2msftngp13.phx.gbl...
> Hi
> Is anyone creating/deleting objects whilst you are running this process?
> Have you run DBCC CHECKDB on this database?
> John
> "David Chase" <dlchase@.lifetimeinc.com> wrote in message
> news:exrzmRwCGHA.1384@.TK2MSFTNGP11.phx.gbl...
>> When I try to go into the dependencies of a table on my SQL 2k database,
>> I get the following error message (twice) and then it takes me to the
>> dependencies screen.
>> Error 21774: [SQL-DMO] The ID '377104434' was not found in the Views
>> collection.
>> Can anyone help me resolve why I am getting this? Thank you.
>> David
>|||Hi David
Are these errors re-creatable?
Is there an entry in sysobjects for id = 377104434?
John
"David Chase" <dlchase@.lifetimeinc.com> wrote in message
news:e9O$wnwCGHA.2480@.TK2MSFTNGP10.phx.gbl...
> Nobody was in the database except me.
> I ran CHECKDB and got the message below at the end.
> CHECKDB found 0 allocation errors and 0 consistency errors in database
> 'MCFIData'.
> David
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:uh2SRbwCGHA.3920@.tk2msftngp13.phx.gbl...
>> Hi
>> Is anyone creating/deleting objects whilst you are running this process?
>> Have you run DBCC CHECKDB on this database?
>> John
>> "David Chase" <dlchase@.lifetimeinc.com> wrote in message
>> news:exrzmRwCGHA.1384@.TK2MSFTNGP11.phx.gbl...
>> When I try to go into the dependencies of a table on my SQL 2k database,
>> I get the following error message (twice) and then it takes me to the
>> dependencies screen.
>> Error 21774: [SQL-DMO] The ID '377104434' was not found in the Views
>> collection.
>> Can anyone help me resolve why I am getting this? Thank you.
>> David
>>
>|||> I ran CHECKDB and got the message below at the end.
Try DBCC CHECKCATALOG.
--
Happy Holidays
Dan Guzman
SQL Server MVP
"David Chase" <dlchase@.lifetimeinc.com> wrote in message
news:e9O$wnwCGHA.2480@.TK2MSFTNGP10.phx.gbl...
> Nobody was in the database except me.
> I ran CHECKDB and got the message below at the end.
> CHECKDB found 0 allocation errors and 0 consistency errors in database
> 'MCFIData'.
> David
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:uh2SRbwCGHA.3920@.tk2msftngp13.phx.gbl...
>> Hi
>> Is anyone creating/deleting objects whilst you are running this process?
>> Have you run DBCC CHECKDB on this database?
>> John
>> "David Chase" <dlchase@.lifetimeinc.com> wrote in message
>> news:exrzmRwCGHA.1384@.TK2MSFTNGP11.phx.gbl...
>> When I try to go into the dependencies of a table on my SQL 2k database,
>> I get the following error message (twice) and then it takes me to the
>> dependencies screen.
>> Error 21774: [SQL-DMO] The ID '377104434' was not found in the Views
>> collection.
>> Can anyone help me resolve why I am getting this? Thank you.
>> David
>>
>|||DBCC CHECKCATELOG was clean also.
David
"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
news:OAnbYzwCGHA.528@.TK2MSFTNGP09.phx.gbl...
>> I ran CHECKDB and got the message below at the end.
> Try DBCC CHECKCATALOG.
> --
> Happy Holidays
> Dan Guzman
> SQL Server MVP
> "David Chase" <dlchase@.lifetimeinc.com> wrote in message
> news:e9O$wnwCGHA.2480@.TK2MSFTNGP10.phx.gbl...
>> Nobody was in the database except me.
>> I ran CHECKDB and got the message below at the end.
>> CHECKDB found 0 allocation errors and 0 consistency errors in database
>> 'MCFIData'.
>> David
>> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
>> news:uh2SRbwCGHA.3920@.tk2msftngp13.phx.gbl...
>> Hi
>> Is anyone creating/deleting objects whilst you are running this process?
>> Have you run DBCC CHECKDB on this database?
>> John
>> "David Chase" <dlchase@.lifetimeinc.com> wrote in message
>> news:exrzmRwCGHA.1384@.TK2MSFTNGP11.phx.gbl...
>> When I try to go into the dependencies of a table on my SQL 2k
>> database, I get the following error message (twice) and then it takes
>> me to the dependencies screen.
>> Error 21774: [SQL-DMO] The ID '377104434' was not found in the Views
>> collection.
>> Can anyone help me resolve why I am getting this? Thank you.
>> David
>>
>>
>|||Yes, I did a SELECT * FROM sysobjects WHERE id = 377104434 and it returned a
result with information about a completely different table in the database
named PayInfoNHS. The table I got the error on is named tblMenus and has
absolutely no relationships with any tables, let alone PayInfoNHS. HTH.
David
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:Of6NEwwCGHA.528@.TK2MSFTNGP09.phx.gbl...
> Hi David
> Are these errors re-creatable?
> Is there an entry in sysobjects for id = 377104434?
> John
> "David Chase" <dlchase@.lifetimeinc.com> wrote in message
> news:e9O$wnwCGHA.2480@.TK2MSFTNGP10.phx.gbl...
>> Nobody was in the database except me.
>> I ran CHECKDB and got the message below at the end.
>> CHECKDB found 0 allocation errors and 0 consistency errors in database
>> 'MCFIData'.
>> David
>> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
>> news:uh2SRbwCGHA.3920@.tk2msftngp13.phx.gbl...
>> Hi
>> Is anyone creating/deleting objects whilst you are running this process?
>> Have you run DBCC CHECKDB on this database?
>> John
>> "David Chase" <dlchase@.lifetimeinc.com> wrote in message
>> news:exrzmRwCGHA.1384@.TK2MSFTNGP11.phx.gbl...
>> When I try to go into the dependencies of a table on my SQL 2k
>> database, I get the following error message (twice) and then it takes
>> me to the dependencies screen.
>> Error 21774: [SQL-DMO] The ID '377104434' was not found in the Views
>> collection.
>> Can anyone help me resolve why I am getting this? Thank you.
>> David
>>
>>
>|||I don't know if this helps, but every time I go into design of ANY table
using EM I get this error message.
David
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:Of6NEwwCGHA.528@.TK2MSFTNGP09.phx.gbl...
> Hi David
> Are these errors re-creatable?
> Is there an entry in sysobjects for id = 377104434?
> John
> "David Chase" <dlchase@.lifetimeinc.com> wrote in message
> news:e9O$wnwCGHA.2480@.TK2MSFTNGP10.phx.gbl...
>> Nobody was in the database except me.
>> I ran CHECKDB and got the message below at the end.
>> CHECKDB found 0 allocation errors and 0 consistency errors in database
>> 'MCFIData'.
>> David
>> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
>> news:uh2SRbwCGHA.3920@.tk2msftngp13.phx.gbl...
>> Hi
>> Is anyone creating/deleting objects whilst you are running this process?
>> Have you run DBCC CHECKDB on this database?
>> John
>> "David Chase" <dlchase@.lifetimeinc.com> wrote in message
>> news:exrzmRwCGHA.1384@.TK2MSFTNGP11.phx.gbl...
>> When I try to go into the dependencies of a table on my SQL 2k
>> database, I get the following error message (twice) and then it takes
>> me to the dependencies screen.
>> Error 21774: [SQL-DMO] The ID '377104434' was not found in the Views
>> collection.
>> Can anyone help me resolve why I am getting this? Thank you.
>> David
>>
>>
>|||Have you tried disconnecting and reconnecting? Perhaps it's an EM refresh
issue.
--
Happy Holidays
Dan Guzman
SQL Server MVP
"David Chase" <dlchase@.lifetimeinc.com> wrote in message
news:ebim3RyCGHA.3920@.tk2msftngp13.phx.gbl...
>I don't know if this helps, but every time I go into design of ANY table
>using EM I get this error message.
> David
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:Of6NEwwCGHA.528@.TK2MSFTNGP09.phx.gbl...
>> Hi David
>> Are these errors re-creatable?
>> Is there an entry in sysobjects for id = 377104434?
>> John
>> "David Chase" <dlchase@.lifetimeinc.com> wrote in message
>> news:e9O$wnwCGHA.2480@.TK2MSFTNGP10.phx.gbl...
>> Nobody was in the database except me.
>> I ran CHECKDB and got the message below at the end.
>> CHECKDB found 0 allocation errors and 0 consistency errors in database
>> 'MCFIData'.
>> David
>> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
>> news:uh2SRbwCGHA.3920@.tk2msftngp13.phx.gbl...
>> Hi
>> Is anyone creating/deleting objects whilst you are running this
>> process?
>> Have you run DBCC CHECKDB on this database?
>> John
>> "David Chase" <dlchase@.lifetimeinc.com> wrote in message
>> news:exrzmRwCGHA.1384@.TK2MSFTNGP11.phx.gbl...
>> When I try to go into the dependencies of a table on my SQL 2k
>> database, I get the following error message (twice) and then it takes
>> me to the dependencies screen.
>> Error 21774: [SQL-DMO] The ID '377104434' was not found in the Views
>> collection.
>> Can anyone help me resolve why I am getting this? Thank you.
>> David
>>
>>
>>
>|||Hi David
If you run Display Dispendecies from All Tasks on the right click menu do
you have the same error?
This runs sp_MSdependencies e.g.
exec sp_MSdependencies N'[dbo].[tblMenus]', null, 1053183
so can run this from query analyser and even debug it from the object
browser. If this does not give an error then the error is (probably) to do
with the display of the dialogue and you may want to run SQL profiler to see
if you can track it down.
John
"David Chase" <dlchase@.lifetimeinc.com> wrote in message
news:ebim3RyCGHA.3920@.tk2msftngp13.phx.gbl...
>I don't know if this helps, but every time I go into design of ANY table
>using EM I get this error message.
> David
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:Of6NEwwCGHA.528@.TK2MSFTNGP09.phx.gbl...
>> Hi David
>> Are these errors re-creatable?
>> Is there an entry in sysobjects for id = 377104434?
>> John
>> "David Chase" <dlchase@.lifetimeinc.com> wrote in message
>> news:e9O$wnwCGHA.2480@.TK2MSFTNGP10.phx.gbl...
>> Nobody was in the database except me.
>> I ran CHECKDB and got the message below at the end.
>> CHECKDB found 0 allocation errors and 0 consistency errors in database
>> 'MCFIData'.
>> David
>> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
>> news:uh2SRbwCGHA.3920@.tk2msftngp13.phx.gbl...
>> Hi
>> Is anyone creating/deleting objects whilst you are running this
>> process?
>> Have you run DBCC CHECKDB on this database?
>> John
>> "David Chase" <dlchase@.lifetimeinc.com> wrote in message
>> news:exrzmRwCGHA.1384@.TK2MSFTNGP11.phx.gbl...
>> When I try to go into the dependencies of a table on my SQL 2k
>> database, I get the following error message (twice) and then it takes
>> me to the dependencies screen.
>> Error 21774: [SQL-DMO] The ID '377104434' was not found in the Views
>> collection.
>> Can anyone help me resolve why I am getting this? Thank you.
>> David
>>
>>
>>
>|||That was it! Thanks.
David
"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
news:eUFi%23VyCGHA.2596@.TK2MSFTNGP10.phx.gbl...
> Have you tried disconnecting and reconnecting? Perhaps it's an EM refresh
> issue.
> --
> Happy Holidays
> Dan Guzman
> SQL Server MVP
> "David Chase" <dlchase@.lifetimeinc.com> wrote in message
> news:ebim3RyCGHA.3920@.tk2msftngp13.phx.gbl...
>>I don't know if this helps, but every time I go into design of ANY table
>>using EM I get this error message.
>> David
>> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
>> news:Of6NEwwCGHA.528@.TK2MSFTNGP09.phx.gbl...
>> Hi David
>> Are these errors re-creatable?
>> Is there an entry in sysobjects for id = 377104434?
>> John
>> "David Chase" <dlchase@.lifetimeinc.com> wrote in message
>> news:e9O$wnwCGHA.2480@.TK2MSFTNGP10.phx.gbl...
>> Nobody was in the database except me.
>> I ran CHECKDB and got the message below at the end.
>> CHECKDB found 0 allocation errors and 0 consistency errors in database
>> 'MCFIData'.
>> David
>> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
>> news:uh2SRbwCGHA.3920@.tk2msftngp13.phx.gbl...
>> Hi
>> Is anyone creating/deleting objects whilst you are running this
>> process?
>> Have you run DBCC CHECKDB on this database?
>> John
>> "David Chase" <dlchase@.lifetimeinc.com> wrote in message
>> news:exrzmRwCGHA.1384@.TK2MSFTNGP11.phx.gbl...
>> When I try to go into the dependencies of a table on my SQL 2k
>> database, I get the following error message (twice) and then it takes
>> me to the dependencies screen.
>> Error 21774: [SQL-DMO] The ID '377104434' was not found in the Views
>> collection.
>> Can anyone help me resolve why I am getting this? Thank you.
>> David
>>
>>
>>
>>
>