Global System UDF to return ISO Date string

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by David A. Long » Global System UDF to return ISO Date string

Global System UDF to return ISO Date string

Rate Topic

Display Mode

Topic Options

Author

Message

David A. Long

Posted Monday, September 24, 2007 2:28 AM

SSChasing Mays

Group: General Forum Members
Last Login: Tuesday, June 04, 2013 8:54 AM
Points: 631, Visits: 231

Comments posted to this topic are about the item Global System UDF to return ISO Date string

Post #401901

Jeff Moden

Posted Saturday, March 23, 2013 5:03 PM

SSC-Dedicated

Group: General Forum Members
Last Login: Yesterday @ 9:01 PM
Points: 33,111, Visits: 27,037

The following code doesn't work.

EXEC sp_changeobjectowner 'fn_DateTimeToISODate', 'system_function_schema'

It produces the following error in SQL Server 2008.

Msg 15411, Level 11, State 1, Procedure sp_changeobjectowner, Line 111
Database principal or schema 'system_function_schema' does not exist in this database.

Has this database principle gone away in 2008? I've not checked but did it exist in 2005 or what? What version of SQL Server were you using when this worked for you?

--Jeff Moden

"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Post #1434632

Lynn Pettis

Posted Saturday, March 23, 2013 6:03 PM

SSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 9:17 PM
Points: 21,832, Visits: 27,855

I'm thinking this would work on SQL Server 2000 when you could update system tables.

Cool

Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)

Post #1434635

Jeff Moden

Posted Saturday, March 23, 2013 6:41 PM

SSC-Dedicated

Group: General Forum Members
Last Login: Yesterday @ 9:01 PM
Points: 33,111, Visits: 27,037

Lynn Pettis (3/23/2013)

I'm thinking this would work on SQL Server 2000 when you could update system tables.

I'm thinking the same thing but wanted to make sure because it sure would be handy. I wish MS would build a "MasterUser" database that had the "everywhere" capabilities of the Master database and that you could easily add any global proc, view, function, or table that you needed to be globally available. Who knows... maybe by the year 2020 (the year of "a clear vision" Tongue

).

--Jeff Moden

Post #1434636

« Prev Topic | Next Topic »

Permissions