Posted by Hugo Kornelis on 11/06/01 11:36

On 6 Jan 2006 05:54:42 -0800, jhmosow@gmail.com wrote:

>Thanks. SQL User Defined Functions only allow you to save one
>template. Do you know which one is the default installed by SQL Server
>2000?

Hi jhmosow,

This is not correct. You can store all three (or even more, if you
desire).

The location where templates for user-defined fuinctions are stored
(asssuming that SQL Server is installed in the default directory) is
(warning, path may wrap)

C:\Program Files\Microsoft SQL Server\80\Tools\Templates\SQL Query
Analyzer\Create Function\*.tql

The "...\Create Function\" is a folder; the three .tql files Erland sent
you should be stored there.

--
Hugo Kornelis, SQL Server MVP

• Next in forum: Re: Default Template for User Defined Function
• Prev in forum: Re: Default Template for User Defined Function
• Thread view: Re: Default Template for User Defined Function

[Reply to this message]