The differences in basic administration between 2000 and 2005 are minor, though the interface is somewhat different and the Enterprise Manager and Query Analyzer have been replaced with SQL Server Management Studio some other tools are different too. They aren't hard to use, just be prepared for some minor adjustments.
Aside from the technical differences, I would definitely take into account that if your organization if cheap and slow to upgrade, it can pay off to make an argument for the most current version of everything at the start of a project because you are likely to have problems getting it upgraded later. If this is for a dev environment, just make sure they are also willing to make that same investment for the production environment. -Cameron On Tue, Apr 29, 2008 at 3:50 PM, Bob Imperial <[EMAIL PROTECTED]> wrote: > Hello folks, > > Firs time posting here and I am in need of some > feedback/suggestions/advice on a new server being setup here at work. I work > for UNC Chapel Hill and I made the suggestion to the powers that be that we > set up this new box to house (or hose depending on how this all washes out) > some internal Coldfusion applications I am working on. This box will not be > a dedicated SQL box but will have Windows Server 2003 standard along with > Coldfusion 7 standard on it. That being said, I know this is isn't any where > near best practice for this kind of thing. Dealing with tight purse strings > here so I take what I can get. My experience with SQL Server has been > limited to 7 and 2000, the latter is what we currently have a copy of for > this. I am not a DB admin by any stretch, I just opened my mouth so here I > am. I'm looking for some recommendations as to sticking with 2000 or moving > up to whatever the current version is bearing in mind bewildered Bob here > will be doing the install and maintenance :). Pros/Cons anything at all will > help me at this point. > > > Bob > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:3066 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6
