Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

how to declare functions at server level

Posted on 2009-04-04
10
Medium Priority
?
224 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 143

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
Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

 
LVL 143

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 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 1000 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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

I am showing a way to read/import the excel data in table using SQL server 2005... Suppose there is an Excel file "Book1" at location "C:\temp" with column "First Name" and "Last Name". Now to import this Excel data into the table, we will use…
When writing XML code a very difficult part is when we like to remove all the elements or attributes from the XML that have no data. I would like to share a set of recursive MSSQL stored procedures that I have made to remove those elements from …
Video by: ITPro.TV
In this episode Don builds upon the troubleshooting techniques by demonstrating how to properly monitor a vSphere deployment to detect problems before they occur. He begins the show using tools found within the vSphere suite as ends the show demonst…
Want to learn how to record your desktop screen without having to use an outside camera. Click on this video and learn how to use the cool google extension called "Screencastify"! Step 1: Open a new google tab Step 2: Go to the left hand upper corn…

972 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