>What's wrong?
>Did you get any error?

nono, no error. But only the first version (from the project) works, i.e. does something;

the sp that is created is an alter procedure, not an executing one (at least that's what I see when I "modify" it. And when I execute the sp from studio, it does not do anything.

I don't understand where the "alter procedure" statement comes from.

I must be missing something very basic here.

Thanks for caring.


>>I have this in my project
>>

>>-- =============================================
>>-- Create basic stored procedure template
>>-- =============================================
>>
>>-- Drop stored procedure if it already exists
>>IF EXISTS (
>>  SELECT * 
>>    FROM INFORMATION_SCHEMA.ROUTINES 
>>   WHERE SPECIFIC_SCHEMA = N'dbo'
>>     AND SPECIFIC_NAME = N'USP_RestoreState' 
>>)
>>   DROP PROCEDURE dbo.USP_RestoreState
>>GO
>>
>>CREATE PROCEDURE dbo.USP_RestoreState
>>AS
>>	declare @filename varchar(30);
>>	DECLARE @NOW DATETIME;
>>	set @NOW = getdate();
>>	declare @yymmdd varchar(8)
>>	set @yymmdd = right(convert(varchar(4),year(@now)),2)
>>		+ right('00'+convert(varchar(2),month(@now)),2)
>>		+ right('00'+convert(varchar(2),day(@now)),2)
>>	declare @sql varchar(200)
>>	EXEC sp_DropForeignkeys
>>	set @filename = 'Origins'
>>		set @sql = 'drop table dbo.' + @filename
>>		print @sql
>>		exec (@sql)
>>		set @sql = 'select * into dbo.'+@filename + ' from dbo._' + @filename
>>		print @sql
>>		exec (@sql)
>>		set @sql = 'alter table dbo.'+@filename + ' add constraint PK_' + @filename + ' primary key (' + @filename + '_Id)'
>>		print @sql
>>		exec (@sql)
>>	set @filename = 'Parcels'
>>		set @sql = 'DROP TABLE dbo.' + @filename
>>		print @sql
>>		exec (@sql)
>>		set @sql = 'select * into dbo.'+@filename + ' from dbo._' + @filename
>>		print @sql
>>		exec (@sql)
>>		set @sql = 'alter table dbo.'+@filename + ' add constraint PK_' + @filename + ' primary key (' + @filename + '_Id)'
>>		print @sql
>>		exec (@sql)
>>	set @filename = 'Transactionheaders'
>>		set @sql = 'DROP TABLE dbo.' + @filename
>>		print @sql
>>		exec (@sql)
>>		set @sql = 'select * into dbo.'+@filename + ' from dbo._' + @filename
>>		print @sql
>>		exec (@sql)
>>		set @sql = 'alter table dbo.'+@filename + ' add constraint PK_' + @filename + ' primary key (' + @filename + '_Id)'
>>		print @sql
>>		exec (@sql)
>>	set @filename = 'Transactions'
>>		set @sql = 'DROP TABLE dbo.' + @filename
>>		print @sql
>>		exec (@sql)
>>		set @sql = 'select * into dbo.'+@filename + ' from dbo._' + @filename
>>		print @sql
>>		exec (@sql)
>>		set @sql = 'alter table dbo.'+@filename + ' add constraint PK_' + @filename + ' primary key (' + @filename + '_Id)'
>>		print @sql
>>		exec (@sql)
>>	exec USP_CreateForeignkeys
>>GO
>>
>>-- =============================================
>>-- Example to execute the stored procedure
>>-- =============================================
>>EXECUTE dbo.USP_RestoreState
>>GO
>>

>>
>>When I execute it, it works fine.
>>
>>No I look at the stored procedure in studio via Modify and I get
>>
>>

>>USE [D060]
>>GO
>>/****** Object:  StoredProcedure [dbo].[USP_RestoreState]    Script Date: 9/7/2015 7:22:41 PM ******/
>>SET ANSI_NULLS ON
>>GO
>>SET QUOTED_IDENTIFIER ON
>>GO
>>
>>ALTER PROCEDURE [dbo].[USP_RestoreState]
>>AS
>>	declare @filename varchar(30);
>>	DECLARE @NOW DATETIME;
>>	set @NOW = getdate();
>>	declare @yymmdd varchar(8)
>>	set @yymmdd = right(convert(varchar(4),year(@now)),2)
>>		+ right('00'+convert(varchar(2),month(@now)),2)
>>		+ right('00'+convert(varchar(2),day(@now)),2)
>>	declare @sql varchar(200)
>>	EXEC sp_DropForeignkeys
>>	set @filename = 'Origins'
>>		set @sql = 'drop table dbo.' + @filename
>>		print @sql
>>		exec (@sql)
>>		set @sql = 'select * into dbo.'+@filename + ' from dbo._' + @filename
>>		print @sql
>>		exec (@sql)
>>		set @sql = 'alter table dbo.'+@filename + ' add constraint PK_' + @filename + ' primary key (' + @filename + '_Id)'
>>		print @sql
>>		exec (@sql)
>>	set @filename = 'Parcels'
>>		set @sql = 'DROP TABLE dbo.' + @filename
>>		print @sql
>>		exec (@sql)
>>		set @sql = 'select * into dbo.'+@filename + ' from dbo._' + @filename
>>		print @sql
>>		exec (@sql)
>>		set @sql = 'alter table dbo.'+@filename + ' add constraint PK_' + @filename + ' primary key (' + @filename + '_Id)'
>>		print @sql
>>		exec (@sql)
>>	set @filename = 'Transactionheaders'
>>		set @sql = 'DROP TABLE dbo.' + @filename
>>		print @sql
>>		exec (@sql)
>>		set @sql = 'select * into dbo.'+@filename + ' from dbo._' + @filename
>>		print @sql
>>		exec (@sql)
>>		set @sql = 'alter table dbo.'+@filename + ' add constraint PK_' + @filename + ' primary key (' + @filename + '_Id)'
>>		print @sql
>>		exec (@sql)
>>	set @filename = 'Transactions'
>>		set @sql = 'DROP TABLE dbo.' + @filename
>>		print @sql
>>		exec (@sql)
>>		set @sql = 'select * into dbo.'+@filename + ' from dbo._' + @filename
>>		print @sql
>>		exec (@sql)
>>		set @sql = 'alter table dbo.'+@filename + ' add constraint PK_' + @filename + ' primary key (' + @filename + '_Id)'
>>		print @sql
>>		exec (@sql)
>>	exec USP_CreateForeignkeys
>>

>>and when I execute it, for obvious reasons nothing happens.
>>What am I missing?
>
>