I am trying to change the data type of two columns in a SQL database.The columns were created using the“smallint” data type.Since they are used to identify document and document sections rather than mathematical functions, I think they should have been constrained to a text data type such as nvarchar.When I try to concatenate with a query the result is a mathematical addition of the numbers, butI am trying to combine the two numbers as a string with a "-" between them.
I have not had any success in changing the data type of the two columns.Apparently, the original database was set up for full text search and won’t let me change the column data type.I keep getting this error message:
'Full Documents' table
- Unable to modify table.
Timeout expired.The timeout period elapsed prior to completion of the operation or the server is not responding.
The statement has been terminated.
I ran a query to increase the timeout period (which succeeded in increasing the timeout but still got the same error message when trying to change the column data type). My research suggests that this is really a matter of the column data constraints related to the full text search issue.
Any suggestions on how to change the data type of these columns?
Since this is a general SQL question, I'm moving it to a more general forum where you'll get a better answer.
Mike
No comments:
Post a Comment