RE: Function in database disappears

SSC Guru

Points: 323506

February 11, 2016 at 11:49 am

not suspicious; it sounds like a missing GO statement between drop create procedure and drop/create function in someones script.

it happens to us all at some point

IF OBJECT_ID('[dbo].[sp_Bad]') IS NOT NULL DROP PROCEDURE [dbo].[sp_Bad]

GO

CREATE PROCEDURE [dbo].[sp_Bad] AS PRINT 1

--Implied GO statment here is missing

IF OBJECT_ID('[dbo].[sp_Bad2]') IS NOT NULL DROP PROCEDURE [dbo].[sp_Bad2]

GO

CREATE PROCEDURE [dbo].[sp_Bad2] AS PRINT 1

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!