Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials

Getting an error message "Cannot specify a column width on data type text" when trying to create a table in SQL server.

dreamrg

Kiwi Syslog server, SQL2008R2 using a OBCC SQL connector.

Any thoughts?

Find more posts tagged with

Accepted answers

All comments

Aforsythe

Text data type or nText data type does not support a "width" property, you can't specify column length. If you're creating the table via Kiwi, I believe that you can edit the SQL used to create the table and change the column definition.

gopinath_try

Can you share, how this can be achieved?

RootBearded

When configuring Kiwi for SQL, the "Database type/field format" defaults to "MS Access".

Click the dropdown, select "Kiwi SQL format" and you should be good to go.