This is what I got when I tried and I have SA access.

Msg 15151, Level 16, State 1, Line 1

Cannot alter the schema 'system_function_schema', because it does not exist...

Now I'm trying to create this function in SQL 2005 and get this error when it tries to change owner...

Msg 15411, Level 11, State 1, Procedure sp_changeobjectowner, Line 107

Database...

Thanks for all the info.  I'm going to ask.  I'm sure suits are not required at this work place so that is not a concern for me

Ditto on the ego boost LOL

I think I might have fell off my chair laughing

I'm ready for an interview now

All great answers.  I did find the bad code already but will test these ideas.

The symtom was 141,872 rows with a length of 12,433 bytes being sorted

Great article.  I agree 100%

Just a follow up to say that seemed to fix it.  Thanks again.

It was checked. I corrected ALL the settings to what they should have been

Thanks a bunch

Carl

As for CPU time goes I was hoping MS did a good job with the convert function so I'm using that.  If that is the case then this should work...

Thanks to both of you

I'll check out that CLR info.  I have some things I need to put in now on 2000 but...

Chad, if you have done all that in 2005 already I can't imagine that 2000 to 2005 class will be worth the time and money.  I haven't taken the co

Thank you very much for the information.  My script is nearly complete  Not sure how many people would be interested in it.  Basically gathers contig data from all DBs and...

I would have to agree with the last post.  If that doesn't work then maybe you post some test data/example that would show why it doesn't work.  We're shotting for...

One more note on the ISP.  I guess it comes down to who is the ISP more afraid of?  Their customer or the person claiming the copyright problem?

I agree with most of what has been said... I'm for sure the less gov. is more type of person.  Even though it might be nice if the ISP looked into...