Sorry, but in my opinion this is presentational stuff.

I assume, you need this for some kind of international application. I wuold do the localisation at the front end.

Your description is , ehm, a little bit vague and unclear.

Can you post an example of what you mean?

Can you post any more information, such as error messages...?

Yup, done! Since this is my laptop that wasn't much of a problem.

"Will not work" might be the wrong expression. "Will not be supported" seems to be more precise, when you read this http://www.microsoft.com/sql/howtobuy/windowsnetsupport.asp.

Glad to hear it worked!

Why run around the block when you can nip through the alley

...because one sometimes can't see the forest from the trees (or how do you...

Aah, great solution for the lazycoder

Damn, I found the wrong name in several places in the registry. Just did a global hack and replaced all occurences with the correct name and hope nothing will break...

Untested! What about:

SELECT

 'BD153TY', LEFT('BD153TY',LEN('BD153TY')-3)+ ' '+RIGHT('BD153TY',3)

 , 'LE34TY', LEFT('LE34TY',LEN('LE34TY')-3)+ ' '+RIGHT('LE34TY',3)

Windows XP? SP2?

Maybe one of these will help:

http://www.microsoft.com/technet/prodtechnol/winxppro/maintain/sp2otech.mspx

http://support.microsoft.com/default.aspx?scid=kb;en-us;841249

http://support.microsoft.com/default.aspx?scid=kb;EN-US;839279

http://support.microsoft.com/default.aspx?scid=kb;EN-US;841394

http://support.microsoft.com/default.aspx?scid=kb;EN-US;841251

http://support.microsoft.com/default.aspx?scid=kb;EN-US;841252

http://support.microsoft.com/default.aspx?scid=kb;EN-US;839269

Good luck!

Could this be the case? http://support.microsoft.com/kb/822473

What is the exact error message you get?

Do a search in the script section here. Very likely you'll find there what you are looking for.

And in case you need it for your developers in written what Adam said, have a look at BOL for "IDENT_CURRENT". Also contains a nice example about the differences between...

I believe Dinesh meant the same, however have a look at BOL for SET IDENTITY_INSERT ON/OFF. Should do what you want.