is this a sys procedure? - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

is this a sys procedure?

Author

Topic

funketekun
Constraint Violating Yak Guru

491 Posts

Posted - 2007-09-12 : 17:21:59

I found a few SP. Just want to know whether they are sys stored procedures or not? there is not sql job calling it. Any way to find out what application is using it?

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

ALTER procedure "sp_MSdel_CUSADS"
@pkc1 char(4),
@pkc2 numeric(8,0),
@pkc3 numeric(1,0)
as
delete "CUSADS"
where "CACONO" = @pkc1 and "CACUSN" = @pkc2 and "CAADTP" = @pkc3
if @@rowcount = 0
if @@microsoftversion>0x07320000
exec sp_helptext sp_MSreplraiserror 20598

GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

=============================
http://www.sqlserverstudy.com

dinakar
Master Smack Fu Yak Hacker

2507 Posts

Posted - 2007-09-12 : 17:27:23

It is a replication related delete proc on the table CUSADS.

Dinakar Nethi
************************
Life is short. Enjoy it.
************************
http://weblogs.sqlteam.com/dinakar/

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-09-12 : 17:28:48

This looks like a replication stored procedure. When you setup replication and keep the default of sending the commands via stored procedures rather than through DML statements, it creates these objects for each article:

sp_MSdel_ObjectName
sp_MSins_ObjectName
sp_MSupd_ObjectName

Do not delete these objects unless you aren't using replication anymore.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources