How to Create Custom System Function in SQL Server 2005

• sql v-line

  SSC Veteran

  Points: 271

  More actions

  March 29, 2010 at 9:22 pm

  #139573

  Hi, all.

  I need to create a function that is available across all database without two-part name.

  It's possible in SQL Server 2000.

  like this ...

  ------------------------------------------------------

  EXEC SP_CONFIGURE 'ALLOW UPDATES', 1

  RECONFIGURE WITH OVERRIDE

  http://msdn.microsoft.com/en-us/library/aa224829(SQL.80).aspx

  ------------------------------------------------------

  I can create custom System Procedure in SQL Server 2005 / 2008.

  Is there a way ?

  Thanks for everyone's contribution.

• bprov

  SSC Enthusiast

  Points: 137

  More actions

  April 12, 2012 at 1:37 pm

  #1472909

  Did you found the answer?

  I only found how to do it in MS SQL Server 2000.

  http://msdn.microsoft.com/en-us/library/aa224829(v=sql.80).aspx