Administrative tool for MS-SQL

What tool do you use to take care of your MS-SQL db?

[lazerzubb]

Anyone have any tips on tools to administrate a MS-SQL database, downloading SQL server trial for Enterprise Manager, any other tool which is good?

[le_gber]

I tend to use the MySQL control center, but I mainly develop sites in ASP/ACCESS so haven't really played with it. It seems to be good though and free.

Leo

[lazerzubb]

>>MySQL control center

Uh... not sure that does work for MS-SQL? ;)

[le_gber]

OOOOPS sorry didn't see that ;)

Leo

[mattur]

Enterprise manager is the standard way to manage MS SQL. It lets you manage everything (security, logs, maintenance plans etc) to do with your database server(s). It's an MMC application.

Query Analyzer and Profiler are also useful. These all come as part of the SQL Server tools. AFAICR you can do something like a "tools only" install from the SQL Server disks.

[Sinner_G]

Using only Enterprise Manager here, can't think of anything for which I would need another tool.

[bmcgee]

Enterprise Manager is the way to go for administering the database.

For actual day to day usage of a SQL Server database, I prefer Query Analyzer.

[gangstah]

Enterprise Manager for administration, Query Analyzer for queries. I'm not smart enough to use QA for administration ;-)

[pff_iy]

I use the Enterprise manager for looking after the database. Like someone else mentioned here it is an MMC so can be set up as an application on your desktop. For querying I would have to say that the most convenient and fastest way is the query analyser