Hi Frank,

Check the Model database and see if the procedures are in there. The procedures below I'm sure should have nothing to do with your new database.

HTH,
John

>Hi,
>
>I'm pretty new to SQL Server and have just noticed that a database I created has some stored procedures in it that I did not create (unless they were done behind the scene by me selecting some option).
>
>They are all called stp_?_clsedcards, where ? is I, S, D, SL and U and edcards is the name of a table in the database.
>
>Can anybody tell me what these stored procedures are about and how they got there and is it safe for me to delete them?
>
>The code for the procedures is:
>
>stp_D_clsedcards
>

>set ANSI_NULLS ON
>set QUOTED_IDENTIFIER ON
>go
>
>
>-- Procedure definition
>ALTER PROCEDURE [dbo].[stp_D_clsedcards]
>  (  @edc_pk int  )
>As DELETE [dbo].[edcards]
>WHERE (edc_pk =  @edc_pk)
>

>
>stp_I_clsedcards
>

>set ANSI_NULLS ON
>set QUOTED_IDENTIFIER ON
>go
>
>
>-- Procedure definition
>ALTER PROCEDURE [dbo].[stp_I_clsedcards](  @edc_pk int ,
>  @edc_dentry datetime ,
>  @edc_acarfk int ,
>  @edc_arrflight char (10) ,
>  @edc_surname char (40) ,
>  @edc_firstname char (40) ,
>  @edc_midname char (40) ,
>  @edc_dob datetime ,
>  @edc_brthfk int ,
>  @edc_natnfk int ,
>  @edc_passno char (20) ,
>  @edc_cardno char (20) ,
>  @edc_issfk int ,
>  @edc_issued datetime ,
>  @edc_embkfk int ,
>  @edc_occpfk int ,
>  @edc_addr1 char (40) ,
>  @edc_addr2 char (40) ,
>  @edc_ctryfk int ,
>  @edc_postcode char (40) ,
>  @edc_actpfk int ,
>  @edc_accomother char (40) ,
>  @edc_accmfk int ,
>  @edc_rsonfk int ,
>  @edc_firstvisit char (1) ,
>  @edc_staylen int ,
>  @edc_email char (100) ,
>  @edc_purpabroad char (40) ,
>  @edc_staylenabroad int ,
>  @edc_ddepart datetime ,
>  @edc_dcarfk int ,
>  @edc_depflight char (10) ,
>  @edc_batfk int ,
>  @edc_scan1 text ,
>  @edc_scan2 text ,
>  @edc_scan3 text ,
>  @edc_portfk int ,
>  @edc_typfk int ,
>  @edc_degfk int ,
>  @edc_gndrfk int ,
>  @edc_cityfk int ,
>  @edc_sttefk int ,
>  @edc_pocfk int  )
>As
>	INSERT INTO [dbo].[edcards]
>(  edc_pk ,
>  edc_dentry ,
>  edc_acarfk ,
>  edc_arrflight ,
>  edc_surname ,
>  edc_firstname ,
>  edc_midname ,
>  edc_dob ,
>  edc_brthfk ,
>  edc_natnfk ,
>  edc_passno ,
>  edc_cardno ,
>  edc_issfk ,
>  edc_issued ,
>  edc_embkfk ,
>  edc_occpfk ,
>  edc_addr1 ,
>  edc_addr2 ,
>  edc_ctryfk ,
>  edc_postcode ,
>  edc_actpfk ,
>  edc_accomother ,
>  edc_accmfk ,
>  edc_rsonfk ,
>  edc_firstvisit ,
>  edc_staylen ,
>  edc_email ,
>  edc_purpabroad ,
>  edc_staylenabroad ,
>  edc_ddepart ,
>  edc_dcarfk ,
>  edc_depflight ,
>  edc_batfk ,
>  edc_scan1 ,
>  edc_scan2 ,
>  edc_scan3 ,
>  edc_portfk ,
>  edc_typfk ,
>  edc_degfk ,
>  edc_gndrfk ,
>  edc_cityfk ,
>  edc_sttefk ,
>  edc_pocfk  )
>VALUES (  @edc_pk ,
>  @edc_dentry ,
>  @edc_acarfk ,
>  @edc_arrflight ,
>  @edc_surname ,
>  @edc_firstname ,
>  @edc_midname ,
>  @edc_dob ,
>  @edc_brthfk ,
>  @edc_natnfk ,
>  @edc_passno ,
>  @edc_cardno ,
>  @edc_issfk ,
>  @edc_issued ,
>  @edc_embkfk ,
>  @edc_occpfk ,
>  @edc_addr1 ,
>  @edc_addr2 ,
>  @edc_ctryfk ,
>  @edc_postcode ,
>  @edc_actpfk ,
>  @edc_accomother ,
>  @edc_accmfk ,
>  @edc_rsonfk ,
>  @edc_firstvisit ,
>  @edc_staylen ,
>  @edc_email ,
>  @edc_purpabroad ,
>  @edc_staylenabroad ,
>  @edc_ddepart ,
>  @edc_dcarfk ,
>  @edc_depflight ,
>  @edc_batfk ,
>  @edc_scan1 ,
>  @edc_scan2 ,
>  @edc_scan3 ,
>  @edc_portfk ,
>  @edc_typfk ,
>  @edc_degfk ,
>  @edc_gndrfk ,
>  @edc_cityfk ,
>  @edc_sttefk ,
>  @edc_pocfk  )
>-- Auto Identifer table - Return the id, guid, or computed value of the record created
>

>
>stp_S_clsedcards
>

>set ANSI_NULLS ON
>set QUOTED_IDENTIFIER ON
>go
>
>
>-- Procedure definition
>ALTER PROCEDURE [dbo].[stp_S_clsedcards]
>  (  @OLD___edc_pk int  )
>As SELECT TOP 1000 a.edc_pk,a.edc_dentry,a.edc_acarfk,a.edc_arrflight,a.edc_surname,a.edc_firstname,a.edc_midname,a.edc_dob,a.edc_brthfk,a.edc_natnfk,a.edc_passno,a.edc_cardno,a.edc_issfk,a.edc_issued,a.edc_embkfk,a.edc_occpfk,a.edc_addr1,a.edc_addr2,a.edc_ctryfk,a.edc_postcode,a.edc_actpfk,a.edc_accomother,a.edc_accmfk,a.edc_rsonfk,a.edc_firstvisit,a.edc_staylen,a.edc_email,a.edc_purpabroad,a.edc_staylenabroad,a.edc_ddepart,a.edc_dcarfk,a.edc_depflight,a.edc_batfk,a.edc_scan1,a.edc_scan2,a.edc_scan3,a.edc_portfk,a.edc_typfk,a.edc_degfk,a.edc_gndrfk,a.edc_cityfk,a.edc_sttefk,a.edc_pocfk FROM [dbo].[edcards] a
>WHERE (a.edc_pk =  @OLD___edc_pk)
>

>
>stp_SL_clsedcards
>

>set ANSI_NULLS ON
>set QUOTED_IDENTIFIER ON
>go
>
>
>-- Procedure definition
>ALTER PROCEDURE [dbo].[stp_S_clsedcards]
>  (  @OLD___edc_pk int  )
>As SELECT TOP 1000 a.edc_pk,a.edc_dentry,a.edc_acarfk,a.edc_arrflight,a.edc_surname,a.edc_firstname,a.edc_midname,a.edc_dob,a.edc_brthfk,a.edc_natnfk,a.edc_passno,a.edc_cardno,a.edc_issfk,a.edc_issued,a.edc_embkfk,a.edc_occpfk,a.edc_addr1,a.edc_addr2,a.edc_ctryfk,a.edc_postcode,a.edc_actpfk,a.edc_accomother,a.edc_accmfk,a.edc_rsonfk,a.edc_firstvisit,a.edc_staylen,a.edc_email,a.edc_purpabroad,a.edc_staylenabroad,a.edc_ddepart,a.edc_dcarfk,a.edc_depflight,a.edc_batfk,a.edc_scan1,a.edc_scan2,a.edc_scan3,a.edc_portfk,a.edc_typfk,a.edc_degfk,a.edc_gndrfk,a.edc_cityfk,a.edc_sttefk,a.edc_pocfk FROM [dbo].[edcards] a
>WHERE (a.edc_pk =  @OLD___edc_pk)
>

>
>stp_U_clsedcards
>

>set ANSI_NULLS ON
>set QUOTED_IDENTIFIER ON
>go
>
>
>-- Procedure definition
>ALTER PROCEDURE [dbo].[stp_U_clsedcards](  @OLD___edc_pk int ,
>  @edc_pk int ,
>  @edc_dentry datetime ,
>  @edc_acarfk int ,
>  @edc_arrflight char (10) ,
>  @edc_surname char (40) ,
>  @edc_firstname char (40) ,
>  @edc_midname char (40) ,
>  @edc_dob datetime ,
>  @edc_brthfk int ,
>  @edc_natnfk int ,
>  @edc_passno char (20) ,
>  @edc_cardno char (20) ,
>  @edc_issfk int ,
>  @edc_issued datetime ,
>  @edc_embkfk int ,
>  @edc_occpfk int ,
>  @edc_addr1 char (40) ,
>  @edc_addr2 char (40) ,
>  @edc_ctryfk int ,
>  @edc_postcode char (40) ,
>  @edc_actpfk int ,
>  @edc_accomother char (40) ,
>  @edc_accmfk int ,
>  @edc_rsonfk int ,
>  @edc_firstvisit char (1) ,
>  @edc_staylen int ,
>  @edc_email char (100) ,
>  @edc_purpabroad char (40) ,
>  @edc_staylenabroad int ,
>  @edc_ddepart datetime ,
>  @edc_dcarfk int ,
>  @edc_depflight char (10) ,
>  @edc_batfk int ,
>  @edc_scan1 text ,
>  @edc_scan2 text ,
>  @edc_scan3 text ,
>  @edc_portfk int ,
>  @edc_typfk int ,
>  @edc_degfk int ,
>  @edc_gndrfk int ,
>  @edc_cityfk int ,
>  @edc_sttefk int ,
>  @edc_pocfk int  )
>As
>UPDATE [dbo].[edcards] Set
>    edc_pk = @edc_pk,
>    edc_dentry = @edc_dentry,
>    edc_acarfk = @edc_acarfk,
>    edc_arrflight = @edc_arrflight,
>    edc_surname = @edc_surname,
>    edc_firstname = @edc_firstname,
>    edc_midname = @edc_midname,
>    edc_dob = @edc_dob,
>    edc_brthfk = @edc_brthfk,
>    edc_natnfk = @edc_natnfk,
>    edc_passno = @edc_passno,
>    edc_cardno = @edc_cardno,
>    edc_issfk = @edc_issfk,
>    edc_issued = @edc_issued,
>    edc_embkfk = @edc_embkfk,
>    edc_occpfk = @edc_occpfk,
>    edc_addr1 = @edc_addr1,
>    edc_addr2 = @edc_addr2,
>    edc_ctryfk = @edc_ctryfk,
>    edc_postcode = @edc_postcode,
>    edc_actpfk = @edc_actpfk,
>    edc_accomother = @edc_accomother,
>    edc_accmfk = @edc_accmfk,
>    edc_rsonfk = @edc_rsonfk,
>    edc_firstvisit = @edc_firstvisit,
>    edc_staylen = @edc_staylen,
>    edc_email = @edc_email,
>    edc_purpabroad = @edc_purpabroad,
>    edc_staylenabroad = @edc_staylenabroad,
>    edc_ddepart = @edc_ddepart,
>    edc_dcarfk = @edc_dcarfk,
>    edc_depflight = @edc_depflight,
>    edc_batfk = @edc_batfk,
>    edc_scan1 = @edc_scan1,
>    edc_scan2 = @edc_scan2,
>    edc_scan3 = @edc_scan3,
>    edc_portfk = @edc_portfk,
>    edc_typfk = @edc_typfk,
>    edc_degfk = @edc_degfk,
>    edc_gndrfk = @edc_gndrfk,
>    edc_cityfk = @edc_cityfk,
>    edc_sttefk = @edc_sttefk,
>    edc_pocfk = @edc_pocfk
>WHERE 	( edc_pk =  @OLD___edc_pk )	
>