Home > Archive > microsoft.public.sqlserver.server > November 2002 > New Template?





You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author New Template?
Sam

2002-11-21, 5:23 am

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
Tibor Karaszi

2002-11-21, 5:23 am

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



Sean Gallivan

2002-11-21, 10:24 am

That's perfect many thanks.



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





Free Braindumps | MCSE braindumps software forum

Copyright 2003 - 2008 examnotes.net