Web Wiz Support and Community Forums : Script for updating Relastionships? https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Thu, 09 Apr 2026 03:29:50 +0000 Wed, 06 Sep 2006 16:24:13 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=21229 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[Script for updating Relastionships? : You can transfer your SQL Server...]]> https://forums.webwiz.net/script-for-updating-relastionships_topic21229_post113724.html#113724 Author: WebWiz-Bruce
Subject: 21229
Posted: 06 September 2006 at 4:24pm

You can transfer your SQL Server database using SQL Server but the way you are presently doing is not correct.

I no-longer use SQL Server Enterprise Manager but as far as I recall you need to select the import/export DTS tool  then select the configuration option that allows the must number of choices, then go through the screens selecting to have everything copied over except permissions and server roles. By doing it this way it should also copy across index's, default values, etc. for your database.
]]> Wed, 06 Sep 2006 16:24:13 +0000 https://forums.webwiz.net/script-for-updating-relastionships_topic21229_post113724.html#113724 <![CDATA[Script for updating Relastionships? : I&#039;ve discovered the problem....]]> https://forums.webwiz.net/script-for-updating-relastionships_topic21229_post113722.html#113722 Author: McTurok
Subject: 21229
Posted: 06 September 2006 at 3:19pm

I've discovered the problem. I re-did everything and I was getting the same result.

I had to go into the permissions table and change all fields to allow nulls to get rid of the error and discovered that it is not inserting the Author_ID into the table.

This is the problem and I'm not sure why or how to fix it.

Any ideas why I can log on fine but yet this field is not being stored correctly?


]]> Wed, 06 Sep 2006 15:19:44 +0000 https://forums.webwiz.net/script-for-updating-relastionships_topic21229_post113722.html#113722 <![CDATA[Script for updating Relastionships? : It looks like in the transfer...]]> https://forums.webwiz.net/script-for-updating-relastionships_topic21229_post113708.html#113708 Author: WebWiz-Bruce
Subject: 21229
Posted: 06 September 2006 at 11:25am

It looks like in the transfer process you lost the default values for tables, the relationships are not important but the index's they create could effect performance.

I would try using a different method to move your SQL Server database in Enterprise Manager until you find a method that will work for you and move across the default value also.
]]> Wed, 06 Sep 2006 11:25:10 +0000 https://forums.webwiz.net/script-for-updating-relastionships_topic21229_post113708.html#113708 <![CDATA[Script for updating Relastionships? : Hi Everyone,I just installed 8.03...]]> https://forums.webwiz.net/script-for-updating-relastionships_topic21229_post113690.html#113690 Author: McTurok
Subject: 21229
Posted: 05 September 2006 at 5:22pm

Hi Everyone,

I just installed 8.03 on a new server, but I did this from an update from 7.x.

What I did was transfer over my current forums via MS Eterprise Mgr. This created all my tables (7.x) and brought over all my data along with it to my new MSSQL server.

I then ran the update script to upgrade to 8.x tables. This worked fine too.

I'm now trying to update the new forum permissions and I'm getting this error.

Quote

Microsoft OLE DB Provider for SQL Server error '80040e2f'

Cannot insert the value NULL into column 'Author_ID', table 'tds_db.dbo.tblPermissions'; column does not allow nulls. INSERT fails.

/forum/admin_forum_details.asp, line 308



I'm guessing it's becuase during the transfer to my new server the relationship between the tables was not kept.

Any sql scripts I can run to update these relationships?

Thanks,
Chris
]]> Tue, 05 Sep 2006 17:22:45 +0000 https://forums.webwiz.net/script-for-updating-relastionships_topic21229_post113690.html#113690