craig32768
asked on
Cant update a SP
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?
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?
USE [agoy]
GO
/****** Object: StoredProcedure [dbo].[sp_delete_oldemailtohosts] Script Date: 05/17/2009 23:09:03 ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO
ALTER procedure [dbo].[sp_delete_oldemailtohosts]
AS
BEGIN
DELETE
FROM EmailsToHosts
WHERE (EmailDate < DATEADD([month], - 3, GETDATE()))
end
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
AngelIII - I really need to get to grips with SQL 2008 - can you recommend any books for 'beginners' :-) ?
>How about creating a new one
open a query window, and run a CREATE PROCEDURE statement ...
>can you recommend any books for 'beginners' :-) ?
sorry, I didn't need any books ...
open a query window, and run a CREATE PROCEDURE statement ...
>can you recommend any books for 'beginners' :-) ?
sorry, I didn't need any books ...
ASKER
OK - thanks - Guess that's why your a 'Genius' ;-)
ASKER
Thanks - much appreciated
ASKER