Database advice

Hi,

I recently contacted my hosting company's customer support about my databases not working - saying that I use sql express (which they support).

The guy recommended:

"I would suggest you to upgrade the db's to use mssql 2005."

"Thisis because, sql express is built for development environment. When youare in development environment, you are accessing everything withadministrator permission. However, in live hosting environment (whenthere are differnet kind of permission restrictions), sql express oftenfailed on attaching database."

Does anyone have any opinion on that? Would it be best to change db's to use mssql 2005? How complicated/time consuming will it be to upgrade?

Thanks!

Jon

Hi jbear123

Here is a link from microsoft showing you the difference between all of the SQL Server Products.

http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

The only major difference express has over the other versions is that it is limited to 4 GB is size and will only use one process if you are running it on a multiprocessor machine. Other than that they are the same, and permissions are set up the same.

This is my understanding.

Hope this helps

Regards

ScottyB