views:

20

answers:

0

When I click on Publish to Provider, I can't export my stored procedures. I get an error: " is an encrypted stored procedure. Scripting encrypted stored procedures is not supported".

However, I have not encrypted any of my stored procedures, and this has always worked for me in the past, so I am guess something else is wrong.

Here is an example SP;

USE [Irf]
GO
/****** Object:  StoredProcedure [dbo].[DataContainer_Insert]    Script Date: 09/18/2010 12:06:36 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[DataContainer_Insert]
    @ModelEntityId int,
    @ParentDataContainerId int,
    @DataContainerId int out
AS
BEGIN 
    SET NOCOUNT ON;
    DECLARE @ReferenceId int

    SELECT @ReferenceId = isnull(Max(ReferenceId)+1,1) from DataContainer Where ModelEntityId=@ModelEntityId

    INSERT INTO DataContainer (ReferenceId, ModelEntityId, ParentDataContainerId)
    VALUES (@ReferenceId, @ModelEntityId, @ParentDataContainerId)

    SELECT @DataContainerId = scope_identity()
END