how to change language code of client executing the report dynamic?

Our customer want to use a different language type of his Regional option.
So the datetime type at the Parameter Bar of reporting service could
no show as stander code. (For example short date of his Regional is
2000.1.1 but he want to show as 1.1.2000 when he click the calendor
@.Parameter Bars and he refuse to change his regional options)He shouldn't have to change his regional params.
On the report just set the 'language' to '=User!Language' (this is available
in the Globals in the expression editor)
If you wish to add specific formatting on a cell or other item you can still
do this.
See the follow for this and other best practices:
scroll down to "93" to see my poin
http://www.ssw.com.au/ssw/Standards/Rules/RulesToBetterSQLReportingServices.aspx
"lieshengren" wrote:
> Our customer want to use a different language type of his Regional option.
> So the datetime type at the Parameter Bar of reporting service could
> no show as stander code. (For example short date of his Regional is
> 2000.1.1 but he want to show as 1.1.2000 when he click the calendor
> @.Parameter Bars and he refuse to change his regional options)
>
>
>

How to browse the history login detail of sqlserver?

Hi all,
I want to ask how to browse the history login detail of
sqlserver.eg:login user name , client ip and login time
thx.Hi
SQL server does not store it, unless you log it specifically though code
into a table.
If you have full auditing on, you can see the date and time of a specific
login (success or failure).
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"zlf" <zlfcn@.hotmail.com> wrote in message
news:Oj$X$xOLFHA.1916@.TK2MSFTNGP12.phx.gbl...
> Hi all,
> I want to ask how to browse the history login detail of
> sqlserver.eg:login user name , client ip and login time
> thx.
>|||Thank you for your help
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> д?:uGD9k3OLFHA.1176@.TK2MSFTNGP12.phx
.gbl...
> Hi
> SQL server does not store it, unless you log it specifically though code
> into a table.
> If you have full auditing on, you can see the date and time of a specific
> login (success or failure).
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "zlf" <zlfcn@.hotmail.com> wrote in message
> news:Oj$X$xOLFHA.1916@.TK2MSFTNGP12.phx.gbl...
>