Snitz™ Forums 2000
https://forum.snitz.com/forumTopic/Posts/71347?pagenum=1
04 November 2025, 15:01
Topic
daveo
SQL Server 2014
25 June 2021, 18:36
I recently tried to move to SQL Server 2014. I can read the database and update records, but not reply or create new topics. I am a little frustrated by this issue. I was forced to make this more. Any ideas how to resolve this issue?
Replies ...
Etymon
27 June 2021, 06:02
Perhaps it has to do with the identity seed. When you insert new data into a table, the identity seed increases.
Perhaps you can run a test on your server by creating a dummy table and use generic code to INSERT a new record into that dummy table. If you can do that, then try it on a copy of your FORUM_TOPICS table. If you can do that, then that might help you isolate the problem.
HuwR
27 June 2021, 13:29
How did you move the database? As etymon said could be the table identity columns aren't set. shouldn't be a problem for Snitz, I have used every version of SQL without an issue.