Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Author info

Author  Topic 

Davecg2
Starting Member

10 Posts

Posted - 2009-05-21 : 02:14:20
How do i set the <Author,,Name> value for new stored procedures?

IE this is what comes up when i create a new SPROC.


-- ================================================
-- Template generated from Template Explorer using:
-- Create Procedure (New Menu).SQL
--
-- Use the Specify Values for Template Parameters
-- command (Ctrl-Shift-M) to fill in the parameter
-- values below.
--
-- This block of comments will not be included in
-- the definition of the procedure.
-- ================================================
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: <Author,,Name>
-- Create date: <Create Date,,>
-- Description: <Description,,>
-- =============================================
CREATE PROCEDURE <Procedure_Name, sysname, ProcedureName>
-- Add the parameters for the stored procedure here
<@Param1, sysname, @p1> <Datatype_For_Param1, , int> = <Default_Value_For_Param1, , 0>,
<@Param2, sysname, @p2> <Datatype_For_Param2, , int> = <Default_Value_For_Param2, , 0>
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;

-- Insert statements for procedure here
SELECT <@Param1, sysname, @p1>, <@Param2, sysname, @p2>
END
GO


I want the <Author,,Name> to actually have my name by default. Poked around and no luck finding where to set it.

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-05-21 : 02:32:22
[code]-- Use the Specify Values for Template Parameters
-- command (Ctrl-Shift-M) to fill in the parameter
-- values below.[/code]


E 12°55'05.63"
N 56°04'39.26"
Go to Top of Page

Davecg2
Starting Member

10 Posts

Posted - 2009-05-21 : 22:36:51
quote:
Originally posted by Peso

-- Use the Specify Values for Template Parameters 
-- command (Ctrl-Shift-M) to fill in the parameter
-- values below.



E 12°55'05.63"
N 56°04'39.26"




yea already tried that...but it only fills it in for the current one i want to set it for all new Sprocs not just the current one
Go to Top of Page

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2009-05-21 : 23:06:25
edit the source template and put your name there


KH
[spoiler]Time is always against us[/spoiler]

Go to Top of Page
   

- Advertisement -