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