SYSTEM_USER automatic RTRIM of trailing spaces in 2000, but not 2005?

From: brian.j.parker@xxxxxxxxx
Date: Thu, 21 Aug 2008 13:45:44 -0700 (PDT)

Hey all, I've noticed an obscure little quirk: it appears that if you
use a login with trailing spaces on the name, SYSTEM_USER
automatically trims those trailing spaces in SQL Server 2000, but not
SQL Server 2005.

Anybody know if this change in behavior is documented? If it is
intentional?

Is there a "quick fix" to revert to the old behavior (to automatically
RTRIM the results of SYSTEM_USER in 2005) until code can be changed?

Thanks in advance for any replies!
.

Follow-Ups:
- Re: SYSTEM_USER automatic RTRIM of trailing spaces in 2000, but not 2005?
  - From: Erland Sommarskog

Prev by Date: Re: Different empty_string/NULL handling under ODBC and OLE DB?
Next by Date: Re: SYSTEM_USER automatic RTRIM of trailing spaces in 2000, but not 2005?
Previous by thread: Different empty_string/NULL handling under ODBC and OLE DB?
Next by thread: Re: SYSTEM_USER automatic RTRIM of trailing spaces in 2000, but not 2005?
Index(es):
- Date
- Thread

Relevant Pages

Re: SYSTEM_USER automatic RTRIM of trailing spaces in 2000, but not 2005?
... use a login with trailing spaces on the name, ... automatically trims those trailing spaces in SQL Server 2000, ...
(comp.databases.ms-sqlserver)
Re: SYSTEM_USER automatic RTRIM of trailing spaces in 2000, but not 2005?
... use a login with trailing spaces on the name, ... automatically trims those trailing spaces in SQL Server 2000, ... If the login "pelle " did something bad, ...
(comp.databases.ms-sqlserver)
Re: SYSTEM_USER automatic RTRIM of trailing spaces in 2000, but not 2005?
... just used your exact commands to create the 'spacy ' login on both ... on SQL 2000, SYSTEM_USER gives you string actually used ... the trailing spaces are included if you ... SQL Server will let you in. ...
(comp.databases.ms-sqlserver)
RE: Collation....
... ANSI SQL-92 suggests that two strings which differ only in trailing spaces ... In SQL Server, with most collations a simple ...
(microsoft.public.sqlserver.programming)
Re: Cannot trim data
... I had make a test in my SQL Server, and I found that it happens in this ... > I have examine the data today and they are still contain trailing spaces. ... >> so to speak, in the current collation. ... >> Steve Kass ...
(microsoft.public.sqlserver.programming)