Solved

SQL script error  "Replay internal error"

Posted on 2001-08-24
4
537 Views
Last Modified: 2012-06-21
Hi, I have the following SQL script, but it produces an error when run in Profiler.

It gives me "Replay internal error 51 - No matching connection to execute this one"

What's wrong????

if exists (select * from sysobjects where id = object_id(N'[dbo].[ca_checkcode]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[ca_checkcode]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[ca_codes]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[ca_codes]
GO

0
Comment
Question by:hhappel
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
4 Comments
 
LVL 70

Expert Comment

by:Éric Moreau
ID: 6421656
Is this a SQL2000 script that you try to run on SQL7 server?
0
 

Author Comment

by:hhappel
ID: 6421669
No. It's created on an sql7.0 server, and I try to run it on another sql7.0 server.
0
 
LVL 30

Accepted Solution

by:
SteveGTR earned 200 total points
ID: 6422027
These is a bug for SQL 2000 that references this replay error (Q286239). It also refers to profiling. Maybe it will help:

http://support.microsoft.com/support/kb/articles/Q286/2/39.ASP?LN=EN-US&SD=gn&FR=0&qry=Q286239&rnk=1&src=DHCS_MSPSS_gn_SRCH&SPR=SQL
0
 
LVL 4

Expert Comment

by:aavictor
ID: 6424886
Does you login a right user to execute this SQL statements
such as drop table thru connection?
check the permission first
0

Featured Post

Enroll in June's Course of the Month

June's Course of the Month is now available! Every 10 seconds, a consumer gets hit with ransomware. Refresh your knowledge of ransomware best practices by enrolling in this month's complimentary course for Premium Members, Team Accounts, and Qualified Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

688 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question