These kind of SqlSrv specific things need to happen in the SqlServer Platform Decorators, they are located in Zend\Db\Sql\Platform.