Solved

how to declare functions at server level

Posted on 2009-04-04
10
191 Views
Last Modified: 2012-05-06
Is there any procedure or table called dbo.fn_strt date and dbo_fn_enddate where we can update the input parameters at server level?
0
Comment
Question by:parpaa
  • 5
  • 3
  • 2
10 Comments
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 24069132
No.
0
 
LVL 142

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 24069182
I agree.
usually, you would declare them in the master database...
0
 

Author Comment

by:parpaa
ID: 24069190
where exactly?? is that in table or a procedure??can it be database specific or only server specific??
0
NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

 
LVL 142

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 24069207
I think there is some room for misunderstanding ...

can you please clarify if you
* have those functions, and don't know if they do exist on all sql servers by default
* don't have those functions, and want to know how to get them
* want to have those functions available in your sql servers, in all databases available
* something else.
0
 

Author Comment

by:parpaa
ID: 24069246
This is the request i got...

update dbo.fn_startdate(@a, @b, @c) and dbo.fn_enddate(@a, @b, @d) to include parameters to provide begin and end dates for:
1. Parameter X
2.Parameter Y
3.Parameter Z

0
 

Author Comment

by:parpaa
ID: 24069248
As i am not sure about, so asking for help where to update it..
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 24069299
I am afraid I have no idea what it is you are asking.
0
 

Author Comment

by:parpaa
ID: 24069330
I have those functions in my server and i dont know where they are to update it.. hope i am clear this time..
0
 
LVL 142

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 250 total points
ID: 24069334
they must be on the database level... in sql 2005 sql server management studio:
programmatibility -> stored functions
0
 

Author Closing Comment

by:parpaa
ID: 31566632
Thanks.. got it..
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction This article will provide a solution for an error that might occur installing a new SQL 2005 64-bit cluster. This article will assume that you are fully prepared to complete the installation and describes the error as it occurred durin…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
In a recent question (https://www.experts-exchange.com/questions/28997919/Pagination-in-Adobe-Acrobat.html) here at Experts Exchange, a member asked how to add page numbers to a PDF file using Adobe Acrobat XI Pro. This short video Micro Tutorial sh…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

831 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question