Does anyone use Idera Dataase Management Tools?  If so, what has your
experiencce been?  Would anyone recommend a different databse management
application (esp. for performance tuning, alerts, and easy perusal of DB
statistics.)

I was running two different versions of the same query in QA and encountered
some odd results.  The two queries are:
SELECT CabinetID
FROM            Clients.dbo.Cabinets

Do you have experienced this ?
The mmc is slow to connect the first time it opens only, then it is quick.
The management studio 2005 CTP is slow to open itself, then slow to connect
the first time, and slow to connect for each new opened window !!

Is it possible to disable this security feature (need it on a dev.
box)
Morten

Hi, I have a problem whith procedure running by server agent scheduled job.
If I initiate this procedure by Query Analyser, is running more than 100x
quicker. Procedure make loading input data from text file, about 100 000
record count and start next SQL queries.

Hi, How to connect via internet to MSDE 2000 named instance using Enterprise
Manager?
On remote server (2K Server) there are installed MSDE 2000 default instance
and named instance. Named instance is using port 3077.

hey all,
if i declare a variable and set it is there a way i can get it to display on
the messages window or the grid?
thanks,

Is it possible to delete a group of stored procedure in one action, as it
was using the mmc in SQL2000 ?
Or do I have to delete each store proc one at a time ???

I'm looking for easy way of moving changes from dev sql to prod server....
every time we develop new release of our web based applications this is a
manual process of moving it to existing production server, it's build of 2
steps:

SQL Server Personal edition
Enterprise Manager
on Win 2000
I have the above installed on my own computer

I have a database that contains a product listing. I also have several other
databases that looks at this product listing database. When diagramming one
of these databases that uses the product listing database is there a way to
add this product listing database to my diagram? I ...

Here is my dilemma.
I would like a program to help me do the following:
1.  Change a value on the front end of a program.
2.  Notify me of what table/fields changed in a monitored SQL Server

I've been getting this message in a dialog box intermittently. Most recently
when trying to execute 'select @@trancount' after a statement attempted to
insert 100 rows into a table with only 10 rather small, varchar(256) columns
Everything that turned up on a Google search ...

For some time I've been looking at alternative tools for query construction
that could replace the old good Query Analyzer.
I think QA is a great tool for its purpose but it has become outdated and
it's missing some of the features we have come to expect in modern IDEs, like

I'm looking for any alternative methods that can be used in place of the
xp_sendmail extended stored procedure when running on a 64 bit machine with
the 64 bit version of SQL Server 2000.
Any proven suggestions would be extremely helpful.