Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 563
  • Last Modified:

SQL script error "Replay internal error"

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
hhappel
Asked:
hhappel
1 Solution
 
Éric MoreauSenior .Net ConsultantCommented:
Is this a SQL2000 script that you try to run on SQL7 server?
0
 
hhappelAuthor Commented:
No. It's created on an sql7.0 server, and I try to run it on another sql7.0 server.
0
 
SteveGTRCommented:
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
 
aavictorCommented:
Does you login a right user to execute this SQL statements
such as drop table thru connection?
check the permission first
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Build your data science skills into a career

Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now