Hi - I'm no SQL guru but I had a database running a website that was SQL 2000 - I could create and update SPs no problem in it. My host upgraded to 2008 - when I go into Programability and SPs and chose to modify a SP - it keeps on prompting me to save is somewhere else when I click save.
It's a simple SP to delete some records after a period of time...
Also - I can't seem to create one as I used to in 2000. It again asks me to save it as a file rather than add it to the list of SPs in Management Studio...
Am I missing something really simple here?
/****** Object: StoredProcedure [dbo].[sp_delete_oldemailtohosts] Script Date: 05/17/2009 23:09:03 ******/
SET ANSI_NULLS OFF
SET QUOTED_IDENTIFIER OFF
ALTER procedure [dbo].[sp_delete_oldemailtohosts]
WHERE (EmailDate < DATEADD([month], - 3, GETDATE()))