error when trying to delete record

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.It seems you have some "invalid" merge triggers (probably from a previous
publication). Did you republish after changing your table owner name? If
you do have invalid triggers, you should consider dropping and recreating
your publication.
A. Drop the subscription
B. Drop the publication.
C. Delete the triggers that reference the non-existant views
D. Recreate the publication and subscription.
E. Run the snapshot.
reference:
How to manually remove a replication in SQL Server 2000 - ID: 324401
http://support.microsoft.com/?id=324401
Fany Vargas
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their
Microsoft software to better protect against viruses and security
vulnerabilities. The easiest way to do this is to visit the following
websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx|||Thank you! I did not completely drop and recreate the merge replication
setup but what you said is exactly what happened. I had an issue removing
repl before due to the owner of the tables not being dbo. I had to manually
clean out repl.. change table owners to dbo.. and recreate the replication.
It looks like one of the triggers from the older repl setup was still there.
I found the old trigger and deleted it. It was obvious it was old because it
referenced the old user name. There were the 3 correct triggers on the table
as well. One each for insert, update, and delete. So what was happening was
this: there was the old delete trigger on this table and it was listed first
so it executed and failed. The correct trigger never fired then. Now that
old trigger is gone and all works fine.
thanks again.
"Fany Vargas [MSFT]" <fanyv@.online.microsoft.com> wrote in message
news:Yj9qhVuzEHA.3388@.cpmsftngxa10.phx.gbl...
> It seems you have some "invalid" merge triggers (probably from a previous
> publication). Did you republish after changing your table owner name? If
> you do have invalid triggers, you should consider dropping and recreating
> your publication.
> A. Drop the subscription
> B. Drop the publication.
> C. Delete the triggers that reference the non-existant views
> D. Recreate the publication and subscription.
> E. Run the snapshot.
>
> reference:
> How to manually remove a replication in SQL Server 2000 - ID: 324401
> http://support.microsoft.com/?id=324401
> Fany Vargas
> Microsoft Corporation
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> Are you secure? For information about the Strategic Technology Protection
> Program and to order your FREE Security Tool Kit, please visit
> http://www.microsoft.com/security.
> Microsoft highly recommends that users with Internet access update their
> Microsoft software to better protect against viruses and security
> vulnerabilities. The easiest way to do this is to visit the following
> websites:
> http://www.microsoft.com/protect
> http://www.microsoft.com/security/guidance/default.mspx
>

Error stating SQL Debugger not installed

I am running a SQL 2000 server with two instances of SQL (each version
8.00.818, SP3 plus hotfixes). When I try to debug a stored procedure within
Query Analyzer (ver 8.00.760) I click the execute button and receive an error
indicating that the Debugger Interface is not installed. I've went ahead and
uninstalled the debugger component and reinstalled but still get same error.
Any idea as to what may be wrong?
Ron
Make sure you have followed all the steps in the help topic
in books online: Troubleshooting the Transact-SQL Debugger
You should also check the following knowledge base article:
INF: T-SQL Debugger Is Turned Off By Default for Earlier
Clients After You Install SQL Server 2000 Service Pack 3
http://support.microsoft.com/?id=328151
-Sue
On Wed, 16 Mar 2005 16:53:02 -0800, Ron Niederer
<RonNiederer@.discussions.microsoft.com> wrote:

>I am running a SQL 2000 server with two instances of SQL (each version
>8.00.818, SP3 plus hotfixes). When I try to debug a stored procedure within
>Query Analyzer (ver 8.00.760) I click the execute button and receive an error
>indicating that the Debugger Interface is not installed. I've went ahead and
>uninstalled the debugger component and reinstalled but still get same error.
>Any idea as to what may be wrong?
>Ron

Error stating SQL Debugger not installed

I am running a SQL 2000 server with two instances of SQL (each version
8.00.818, SP3 plus hotfixes). When I try to debug a stored procedure within
Query Analyzer (ver 8.00.760) I click the execute button and receive an erro
r
indicating that the Debugger Interface is not installed. I've went ahead an
d
uninstalled the debugger component and reinstalled but still get same error.
Any idea as to what may be wrong?
RonMake sure you have followed all the steps in the help topic
in books online: Troubleshooting the Transact-SQL Debugger
You should also check the following knowledge base article:
INF: T-SQL Debugger Is Turned Off By Default for Earlier
Clients After You Install SQL Server 2000 Service Pack 3
http://support.microsoft.com/?id=328151
-Sue
On Wed, 16 Mar 2005 16:53:02 -0800, Ron Niederer
<RonNiederer@.discussions.microsoft.com> wrote:

>I am running a SQL 2000 server with two instances of SQL (each version
>8.00.818, SP3 plus hotfixes). When I try to debug a stored procedure withi
n
>Query Analyzer (ver 8.00.760) I click the execute button and receive an err
or
>indicating that the Debugger Interface is not installed. I've went ahead a
nd
>uninstalled the debugger component and reinstalled but still get same error
.
>Any idea as to what may be wrong?
>Ron

Error stating SQL Debugger not installed

I am running a SQL 2000 server with two instances of SQL (each version
8.00.818, SP3 plus hotfixes). When I try to debug a stored procedure within
Query Analyzer (ver 8.00.760) I click the execute button and receive an error
indicating that the Debugger Interface is not installed. I've went ahead and
uninstalled the debugger component and reinstalled but still get same error.
Any idea as to what may be wrong?
RonMake sure you have followed all the steps in the help topic
in books online: Troubleshooting the Transact-SQL Debugger
You should also check the following knowledge base article:
INF: T-SQL Debugger Is Turned Off By Default for Earlier
Clients After You Install SQL Server 2000 Service Pack 3
http://support.microsoft.com/?id=328151
-Sue
On Wed, 16 Mar 2005 16:53:02 -0800, Ron Niederer
<RonNiederer@.discussions.microsoft.com> wrote:
>I am running a SQL 2000 server with two instances of SQL (each version
>8.00.818, SP3 plus hotfixes). When I try to debug a stored procedure within
>Query Analyzer (ver 8.00.760) I click the execute button and receive an error
>indicating that the Debugger Interface is not installed. I've went ahead and
>uninstalled the debugger component and reinstalled but still get same error.
>Any idea as to what may be wrong?
>Ron

error script 1 when service pack 3 install

i have sql 2000 server when i install sp3 error happend is
error script 1 and close installation
There should be an *.out file in the \INSTALL directory. This should have
additonal information. Look in the sqlstp.log file for the exact location
and file name.
Rand
This posting is provided "as is" with no warranties and confers no rights.

error script 1 when service pack 3 install

i have sql 2000 server when i install sp3 error happend is
error script 1 and close installationThere should be an *.out file in the \INSTALL directory. This should have
additonal information. Look in the sqlstp.log file for the exact location
and file name.
Rand
This posting is provided "as is" with no warranties and confers no rights.

error script 1 when service pack 3 install

i have sql 2000 server when i install sp3 error happend is
error script 1 and close installationThere should be an *.out file in the \INSTALL directory. This should have
additonal information. Look in the sqlstp.log file for the exact location
and file name.
Rand
This posting is provided "as is" with no warranties and confers no rights.

Error running script: sp1_serv_uni.sql(1), while installing SP3(sql2ksp3)

Thanks for the reply.
The link which you have given me, I went to that page but
the solution they gave is to install the latest service
pack or a work around solution, I was trying to install
the latest service pack itself not the service pack 1,the
solution they gave is for servive pack 1 not for service
pack 3, so do you have any idea what I should do.
Please mail me a response.
Regards,
Jyotshna.
--Original Message--
this error may occur if the master database files have
been moved from the
orignal installation location.
check the following link:
http://support.microsoft.com/default.aspx?scid=kb;en-
us;Q308753
regards,
Harsh.
"Jyotshna Vonguru" <jyotshna.vonguru@.icn.siemens.com>
wrote in message
news:568701c3e51c$aefe4410$a401280a@.phx.gbl...
Hello,
I am getting an error called:
Error running script: sp1_serv_uni.sql(1), while
installing service pack 3(sql2ksp3).
Could anybody tell me, how to correct this.
Is there anyway.
Please give me a quick solution.
Thank you,
Jyotshna.Please find the corresponding *.out file to see a detailed error mesage.
Thanks,
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.|||I too am getting the same problem.
The *.out file says (1 row affected)
Thats it.
This is driving me made, as I have 3 x 2003 Servers I am building with SQL 2000 on them, and am getting exactly the same error on all 3.|||I'm having the exact same problem.
No one has been able to help me.
Would I be correct in guessing that this is on a Windows 2003 Server, and
its a fresh install of SQL 2000.
Dave.|||What does the sqlstp.log say?
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.

Error running script: sp1_serv_uni.sql(1), while installing SP3(sql2ksp3)

Thanks for the reply.
The link which you have given me, I went to that page but
the solution they gave is to install the latest service
pack or a work around solution, I was trying to install
the latest service pack itself not the service pack 1,the
solution they gave is for servive pack 1 not for service
pack 3, so do you have any idea what I should do.
Please mail me a response.
Regards,
Jyotshna.
--Original Message--
this error may occur if the master database files have
been moved from the
orignal installation location.
check the following link:
http://support.microsoft.com/default.aspx?scid=kb;en-
us;Q308753
regards,
Harsh.
"Jyotshna Vonguru" <jyotshna.vonguru@.icn.siemens.com>
wrote in message
news:568701c3e51c$aefe4410$a401280a@.phx.gbl...
Hello,
I am getting an error called:
Error running script: sp1_serv_uni.sql(1), while
installing service pack 3(sql2ksp3).
Could anybody tell me, how to correct this.
Is there anyway.
Please give me a quick solution.
Thank you,
Jyotshna.Please find the corresponding *.out file to see a detailed error mesage.
Thanks,
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.|||I'm having the exact same problem.
No one has been able to help me.
Would I be correct in guessing that this is on a Windows 2003 Server, and
its a fresh install of SQL 2000.
Dave.|||I too am getting the same problem.
The *.out file says (1 row affected)
Thats it.
This is driving me made, as I have 3 x 2003 Servers I am building with SQL 2
000 on them, and am getting exactly the same error on all 3.|||What does the sqlstp.log say?
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.