Hi

I inadvertently overwrote the template for 'new user
defined function' (the stored procedure one looks like:
CREATE PROCEDURE [OWNER].[PROCEDURE NAME] AS).
Does anyone know where I can get a copy of this?

SQL 2000
Sam

Report this post to a moderator

Sam,

Below is the default on my machine. Can you paste in the text and set that as the default?

CREATE FUNCTION [OWNER].[FUNCTION NAME] (PARAMETER LIST)
RETURNS (return_type_spec) AS
BEGIN
(FUNCTION BODY)
END

--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=...ublic.sqlserver


"Sam" <sgpgpjr@yahoo.ie> wrote in message news:dbbc01c2914b$a721cc60$89f
82ecf@TK2MSFTNGXA01...
> Hi
>
> I inadvertently overwrote the template for 'new user
> defined function' (the stored procedure one looks like:
> CREATE PROCEDURE [OWNER].[PROCEDURE NAME] AS).
> Does anyone know where I can get a copy of this?
>
> SQL 2000
> Sam

Report this post to a moderator

That's perfect many thanks.



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Report this post to a moderator