Friday, March 9, 2012

Login.Language property for sa is not set.

I installed SQL 2000 standard edition.

Then I called server.Logins["sa"].Language

For some reason the value of this property was "" (empty string).

Can anyone explain, why?

P.S. After changing Default language for 'sa' login through Management Studio Language property became accessible..

Alexander Sychev.

The language property is tied to the property set in SQL for the login. By default it is just <default> and that is an empty string. When you set it like you did, the property is explicitly set.

No comments:

Post a Comment