"Mary Bray" <reply@tonewsgroup.com.NOSPAMPLEASE> wrote in message
news:uM0iEUS0EHA.2676@TK2MSFTNGP12.phx.gbl...
> Have a look to see if there are any triggers or foreign key constraints
that
> are causing this.
>
> --
>
> Mary Bray [SQL Server MVP]
> Please reply only to newsgroups
>
> "djc" <noone@nowhere.com> wrote in message
> news:Oyrj0tnzEHA.3840@tk2msftngp13.phx.gbl...
> > Windows 2000 Server sp4, SQL Server 2000 sp3
> >
> > I get the error below when attempting to delete a record from a table
> > called
> > Monitor directly from Enterprise Manager GUI.
> > error:
> > [Microsoft][ODBC SQL Server Driver][SQL Server][Invalid Object Name]
> > 'tsvw_KJDKFAJDFKJAKLFDJKLAJDFKJASKFDJKAJDF'
> > [Microsoft][ODBC SQL Server Driver][SQL Server][Invalid Object
> > Name]UserA.Monitor
> > [Microsoft][ODBC SQL Server Driver][SQL Server][Invalid Object Name]
> > 'ctsv_DKFJDKJFKDJFKDKFJDKJFIEJIEJIEJFIEJFKJDKJ'
> >
> > The KDJFKDJFKJDF above is obviously not exact. The actual error
contains
> > a
> > long string of random characters though.. If i'm not mistaken these are
> > system generated names for views related to replication.
> >
> > 1) could this be replication related?
> >
> > 2) Important note: UserA is NOT the current owner of the Monitor table!
> > UserA used to own the table but due to replication issues the owner was
> > changed to dbo a long time ago. ?? Can I safely run the
> > sp_changeobjectowner
> > procedure specifying dbo again or would I need to drop the merge
> > replication
> > in order to do that?
> >
> > 3) I verified that the tsvw_ect... and the ctsv_ect... do not exist in
the
> > database?
> >
> > any suggestions about how to get to the bottom of this would be GREATLY
> > appreciated. Thanks.
> >
> >
>
>

"djc" <noone@nowhere.com> wrote in message
news:Oyrj0tnzEHA.3840@tk2msftngp13.phx.gbl...
> Windows 2000 Server sp4, SQL Server 2000 sp3
>
> I get the error below when attempting to delete a record from a table
> called
> Monitor directly from Enterprise Manager GUI.
> error:
> [Microsoft][ODBC SQL Server Driver][SQL Server][Invalid Object Name]
> 'tsvw_KJDKFAJDFKJAKLFDJKLAJDFKJASKFDJKAJDF'
> [Microsoft][ODBC SQL Server Driver][SQL Server][Invalid Object
> Name]UserA.Monitor
> [Microsoft][ODBC SQL Server Driver][SQL Server][Invalid Object Name]
> 'ctsv_DKFJDKJFKDJFKDKFJDKJFIEJIEJIEJFIEJFKJDKJ'
>
> The KDJFKDJFKJDF above is obviously not exact. The actual error contains
> a
> long string of random characters though.. If i'm not mistaken these are
> system generated names for views related to replication.
>
> 1) could this be replication related?
>
> 2) Important note: UserA is NOT the current owner of the Monitor table!
> UserA used to own the table but due to replication issues the owner was
> changed to dbo a long time ago. ?? Can I safely run the
> sp_changeobjectowner
> procedure specifying dbo again or would I need to drop the merge
> replication
> in order to do that?
>
> 3) I verified that the tsvw_ect... and the ctsv_ect... do not exist in the
> database?
>
> any suggestions about how to get to the bottom of this would be GREATLY
> appreciated. Thanks.
>
>