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?
is pronounced ree-bar and is a Modenism for R
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.
If you think its expensive to hire a professional to do the job, wait until you hire an amateur. -- Red Adair
How to post code problemsHow to post performance problemsForum FAQs