Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 226
  • Last Modified:

how to declare functions at server level

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
parpaa
Asked:
parpaa
  • 5
  • 3
  • 2
1 Solution
 
Anthony PerkinsCommented:
No.
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
I agree.
usually, you would declare them in the master database...
0
 
parpaaAuthor Commented:
where exactly?? is that in table or a procedure??can it be database specific or only server specific??
0
Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
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
 
parpaaAuthor Commented:
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
 
parpaaAuthor Commented:
As i am not sure about, so asking for help where to update it..
0
 
Anthony PerkinsCommented:
I am afraid I have no idea what it is you are asking.
0
 
parpaaAuthor Commented:
I have those functions in my server and i dont know where they are to update it.. hope i am clear this time..
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
they must be on the database level... in sql 2005 sql server management studio:
programmatibility -> stored functions
0
 
parpaaAuthor Commented:
Thanks.. got it..
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 5
  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now