>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?


What's wrong?
Did you get any error?