sql server mseq: Use "SET" command.
The Transact-SQL programming language provides several SET
statements that alter the current session handling of
specific information.

See more information on this in BOL.

There isn't any command as "alter session" in SQL Server.

Hi,

I am trying to use the ALTER SESSION statement within a stored procedure.

How can I use it properly so that my procedure can be compiled ?

Thanks for your help,

Alain