Web Wiz Support and Community Forums : SQL 2000 to SQL 2005 https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Mon, 13 Apr 2026 12:14:31 +0000 Fri, 27 Jan 2006 02:14:12 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=18142 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[SQL 2000 to SQL 2005 : Actually I did attempt to search...]]> https://forums.webwiz.net/sql-2000-to-sql-2005_topic18142_post98257.html#98257 Author: ToJaRo
Subject: 18142
Posted: 27 January 2006 at 2:14am

Actually I did attempt to search for 'SQL 2005' and it gave me this error:
Search Error

One or more of your search criteria is below 4 characters

Click here to ammend your search
 
Thanks for the information regarding the SQL move... I will look more into these tools in the new Management Studio.
]]> Fri, 27 Jan 2006 02:14:12 +0000 https://forums.webwiz.net/sql-2000-to-sql-2005_topic18142_post98257.html#98257 <![CDATA[SQL 2000 to SQL 2005 : The forum will move from SQL 2000...]]> https://forums.webwiz.net/sql-2000-to-sql-2005_topic18142_post98215.html#98215 Author: WebWiz-Bruce
Subject: 18142
Posted: 26 January 2006 at 5:56pm

The forum will move from SQL 2000 to 2005 as I have done so myself.

However, the way I did it was to use the DTS Tools in the 'Managment Studio' to copy across the database rather than attaching and deteching files.

Also if you turn off friendly HTTP error messages in IE you will get an accurate error message that will help findout why you are getting the 500 internat server error.

I do plan on changing a number of parts to the new forum search engine including the amount of allowed characters for seperate words, although for the moment if you select phrase 'SQL 2005' will work as it doesn't count the individual characters in words. The reason 4 was choosen as the allowed characters was that I got the idea form some large PHP forums that have 4 as the allowed characters in searches.
]]> Thu, 26 Jan 2006 17:56:49 +0000 https://forums.webwiz.net/sql-2000-to-sql-2005_topic18142_post98215.html#98215 <![CDATA[SQL 2000 to SQL 2005 : I am attempting to test an upgrade...]]> https://forums.webwiz.net/sql-2000-to-sql-2005_topic18142_post98153.html#98153 Author: ToJaRo
Subject: 18142
Posted: 26 January 2006 at 4:22am

I am attempting to test an upgrade to SQL 2005 for my forum and have run into a bit of an issue.   After detaching and copying the ldf and mdf files to the new server and then running a reattach on the SQL 2005 box and changing the SQL_server_connection.asp to reflect the new password for the db, I can get to the site at default.asp but if I try to get into anything in the forum it gives me a 500 error.... now I know this is DB related because after i mod the SQL_server_connection.asp file to point back to the old DB server with the old DB password it works...  does the fact that I changed the DB user password on the 2005 server make any difference? 
 
If so how can I mod the DB to allow access again from that DB user?
 
Sorry, I am a SysAdmin with some SQL experience... I can get around SQL and make some changes, perform maintenance, etc... but when I come across stuff like this I google and if I can't find an answer, I ask.
 
I also tried searching on this site for "SQL 2005" but the new search is only allowing 4 or more characters for each word... Borg, you might wanna consider revising it since SQL is a commonly used search term.
 
Thanks in advance!
]]> Thu, 26 Jan 2006 04:22:41 +0000 https://forums.webwiz.net/sql-2000-to-sql-2005_topic18142_post98153.html#98153