Getting further...

UPDATE Users

SET UserID = UserID + 2080;

Sure enough, as I wrote this I came up with a plan. I've always selected Cascade Update/Delete when creating the relationships between tables. I went through SQL Analyser...

Cuz I dunno how

I've been trying to do that, but I'm SQL Stupid!

Also, the query is trying to transfer about 60,000 records from an Access database to the new SQL Server one.

It's timing out. Is there anyway for me to disable...

The problem was though, that my new forum has to have the correct ForumID's in every related table ie: My first forum "Super Forum" has an ID value of 23...

Yep, that seemed to be the solution to my problem. Just added:

SET IDENTITY_INSERT yaf_Forum ON

Before I started my insert statement.

I have a similar problem. I am converting forums from the older one with different structure to the new one. I'm not the greatest SQL dude, but in...