Basic sql server question...

I'm using SQL Server 2005. Do I need to get Enterprise Manager to administer the app through a hosted server? What do I need if not EM?

Thanks.

You normally manage SQL Server 2005 through the SQL Server Management Studio (SSMS). You can find that on the SQL Server 2005 installation CD, just pick the client components and tools when you install. You can also use the "free" version of SSMS which is used for SQL Server Express, although it has less functionality.

For a remote server, especially one in a datacenter where they don't open many ports, you might find that asking them to open a port just to your machine for a Remote Desktop to be preferrable. You can also use the command line tool (sqlcmd) or even PowerShell to manage your system.

Buck

|||Thanks. Just to clarify - can I use the Express version to remotley administer my application? If I need to get SSMS, can that be downloaded or is it best to order a CD? Thanks again.