This may be a dumb question. My excuse is I’m not a trained DB admin.
At work we have a server running an ms sql 2005 database. I use ms sql server management studio express 2005 to access it, but could I just as easilly use the 2008 edition? Would it be safe, and not try to “do 2008 things to 2005 server and break it”?
That’ll be something for me to do tomorrow at work… uninstall 2005 and install 2008.
there might be little or no difference (I don’t know) but I like to have the latest stuff. I’m like that.
On a seperate note I installed server 2008 express on my home computer and after some messing about I’ve managed to access it via php and a codegear c++ builder application.
Having it at home should be useful for learning to use it.
One thing you lose with the 2008 studio and a 2000 db is the current activity monitor. I think it’s okay if the db is 2005. I discovered that on Friday when I installed the 2008 client tools, thought everything was good so uninstalled the 2005 tools. I like to look at the activity on our 2000 db sometimes so I guess I’ll be reinstalling the 2005 studio tomorrow.