Thank you...I will try that!!!!!

Thanks Jo.  I realize that I have to find out if the user owns anything, which is what I was trying to do with the sp_helpdb sp.  With issues stated...

Thank you for the explanation.  This brings me to ask you another question.  The reason I was trying to run the sp_helpdb, is to find out who owns what databases,...

Thanks Steve for the comments.  I really don't know how to go about this project.  Was hoping that maybe others have had some experience/knowledge and could help me out.  What...

Rudy, thanks a ton!!  I am going to try that...until we get sp4 implemented!!!!

I will try this!!  Thank you so much!!!!!!!!!

that fix requirea sp4...and I don't believe IT has upgraded yet.  I wonder if there is any other workaround?? 

it seems odd and I don't know why, but the variables and values I was working with didn't jive on the new platform.  I fussed with them and ended up...

ok guys, this may be the issue.  I will make some changes in my code and see if it works....I will be back soon!!  Thanks!!!!!!

Thanks Ryan....I will keep this for another time!!

Thanks David, with a couple of tweaks, this one worked!!!!

Well, I will start playing now...Thank you so much for the input!

Thanks Farrell.  I contacted Sean and he sent me the link to the article.

http://www.sqlservercentral.com/columnists/sMcCown/getawayfromconfusingcode.asp

You will love the little script he has at the bottom...I have it saved off...

Thank you to both of you for your responses.  This report is comma delimeted and is going into an excel spreadsheet.  What I found yesterday, is that if I do...

ok, in case anyone is reading this, I was able to get around the error by putting a collation clause after my column in the following manner:

update

 t

set t.UserHeightFactor = uc.Factor

from...