question

Wilfred van Dijk avatar image
Wilfred van Dijk asked

suppress output when using set language

I create HTML reports bij redirecting the T-SQL ouput to a file. I want the date format in a specific setting, so my first statement in the script is 'SET LANGUAGE DUTCH' Unfortunately, this results in a message saying "language is set to ...." which also comes to my outputfile. Is there a way to suppress this message?
outputhtmllanguage
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Fatherjack avatar image
Fatherjack answered
Can you set the language in the connection string/settings so that it doesnt need to be done via TSQL?
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Wilfred van Dijk avatar image Wilfred van Dijk commented ·
No, I don't see such option. However, if you add the -R parameter, it's using the client regional setting, which works fine for me.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.