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

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

State Suggested Answer
Replies 3 replies
Answers 1 answer
Subscribers 12 subscribers
Views 544 views
Users 0 members are here

Options

dreamrg over 2 years ago

Kiwi Syslog server, SQL2008R2 using a OBCC SQL connector.

Any thoughts?

0 Aforsythe over 2 years ago

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.
Cancel
Up 0 Down

Reply

Verify Answer

Cancel
0 gopinath_try over 2 years ago in reply to Aforsythe

Can you share, how this can be achieved?
Cancel
Up 0 Down

Reply

Verify Answer

Cancel
0 RootBearded 2 months ago

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.
Cancel
Up 0 Down

Reply

Verify Answer

Reject Answer

Cancel

SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 150,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.