Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
IceDread
Yak Posting Veteran
66 Posts |
 Posted - 2007-10-17 : 03:38:38
|
| Greetings!I'm wondering if a db from an sql server 2000 restored on a sql 2005 server will use algoritms from sql 2000 or sql 2005. It seams to work quite well with a few exceptions, it's only for test anyway.I'm sorry if this has been asked before but I could not see it.ThanksIceDread |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-10-17 : 03:44:51
|
| There is a Compatibility Mode. When first restored it will be Compatibility Mode 80, which is "SQL 2000", but you can change that to Compatibility Mode 90 - i.e. SQL 2005.No point leaving it at Compatibility Mode 80 as you won't be able to use any new functions, and there is no guarantee that it will behave identically either! plus I read that it will run slower unless you set Compatibility Mode 90See also: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=55210&SearchTerms=Migrating+to+SQL+2005+Hints+and+TipsKristen |
 |
|
|
IceDread
Yak Posting Veteran
66 Posts |
Posted - 2007-10-17 : 03:52:04
|
| Once again I thank thee.I've several testservers and use my own machine (where I have sql 2005 installed) for some tests to mostly lern more about the systems here (very few things are documented and there are sometimes 20 sp's and udf's that uses each others) that I now work with and so atm effectivity is not a problem or a consern but very interresting to know. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-10-17 : 04:07:35
|
| "(very few things are documented and there are sometimes 20 sp's and udf's that uses each others)"<Shocked!> You must be the only company in the world where that is the case <bg>How about putting a Wiki in so that folk can record (in an "anarchical, but nice" way!) any snippets of Operating Procedures of Knowledgebase stuff?We've had a Wiki for a year or perhaps two. There are probably only 4 people who update it, and it has 355 pages - all to do with notes on rollout procedures, comments about Tricks and Traps of our code, Check-lists for exhibitions and stuff like that.Kristen |
|
|
|
IceDread
Yak Posting Veteran
66 Posts |
Posted - 2007-10-17 : 04:18:59
|
| HeheheWe've started with making a few documents to document stuff, me and a few more that are new at this place which the boss encurages us to do as well since even he and others has use of it. We're getting some more order on everything. Makes life easier for everyone. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-10-17 : 05:04:22
|
| I recommend a Wiki over Word DOC files. Word DOC are "single user", and folk work from out-of-date-copies on their C: drive, printouts, all sorts. And they are relatively tedious to change. Wiki provides straightforward linking of related materials, which provides a better interface than Word. (And what we find is we go to a page, can't find a link to something relevant, so we do a search, find some relevant pages and then improve the links there & then) |
|
|
|
IceDread
Yak Posting Veteran
66 Posts |
Posted - 2007-10-17 : 06:27:30
|
| I'll have to check that out closely then :) |
|
|
|
|
|
|
|
|
SQL 2000 DB restored on a SQL 2005