---
title: "MsSQL-specific interaction methods"
url: "https://axoflow.com/docs/axosyslog-core/4.28/chapter-destinations/configuring-destinations-sql/sql-interactions-syslog-ng/mssql-specific-interaction-methods/"
last_modified: "2023-06-27T21:05:00+02:00"
---

> For the complete documentation index, see [llms.txt](https://axoflow.com/docs/axosyslog-core/4.28/llms.txt).

# MsSQL-specific interaction methods

In SQL Server 2005 this restriction is lifted - kind of. The total length of all key columns in an index cannot exceed 900 bytes.

If you are using `null()` in your configuration, be sure that the columns allow `NULL` to insert. Give the column as the following example: `"datetime varchar(16) NULL"`.

The date format used by the MSSQL database must be explicitly set in the `/etc/locales.conf` file of the AxoSyslog server. `[default] date = "%Y-%m-%d %H:%M:%S"`.

Last modified June 27, 2023: [Moves content/docs to content/ to shorten output url (a5fcf1ed)](https://github.com/axoflow/axosyslog-core-docs/commit/a5fcf1ed4956f586bc12af2b775e10aa75c1e630)