I'm running SQL Server 2000, sp4 on a 2000 Server, sp4 on a 2003 ADS domain
w/ Exchange 2003 Enterprise as a mail server.  When I try to configure SQL
Mail and click "Test", I get the following error:
Error 18025: xp_test_mapi_profile : failed with mail error 0x80070057

I am unable to download 'Best Practices Analyzer tool for SQL Server 2000 '
from the following link
http://www.microsoft.com/downloads/details.aspx?FamilyID=B352EB1F-D3CA-44EE-893E
-9E07339C1F22&displaylang=en
I am able to download other tools and files without issues. please advise ...

 We have a requirement to read the .trc files generated by SQL server
in real-time or atleast near real-time. We do not want to interfere
with existing SQL server setup by running functions like
fn_trace_get_table. The requirement is to get the events logged in .trc

I get the following error message when using Copy Database Wizard
Event Type:    Warning
Event Source:    SQLSERVERAGENT
Event Category:    Job Engine

When we did stress testing, we found that for the same procedure the time
taken is between 80 ms to 5000 ms. The procedure got executed 19929 times and
out of which the value was > 1000ms only 13 times and many times it was
between 80 to 800.

We are waiting for a SAN solution to be installed and our current sql server
has 8GB storage available and I am having our SQL auditing taking up tons of
space.  How can I disable all auditing or change settings on auditing within
sql server manager?  Also, all the old audit file ...

When I try to use the "Open Table" feature in SQL Managment Studio
(Standard), I get the following error:
Class does not support aggregation (or class object is remote) (Exception
from HRESULT: 0x80040110 (CLASS_E_NOAGGREGATION))

We are in the process of migrating our MS SQL Server 2000 databases to MS
SQL Server 2005.
We have using the MS Upgrade Advisor to flag problems in our databases so
they can be fixed. Does there exist a tool from which we can get a report on

I have a dB on a remote SQL2000sp4/win2k server I'm trying to import into
SQL2005x64 (sp1) on Server2003x64. I have a schema that I didn't write that
created the database on both servers.
During config on the import wizard I select to delete existing data and

I have maintenance plans set up in SQL2K that e-mail status reports to
me upon completion.  The e-mail subject lines have very handy
formatting which includes the job name and final status, like "SQL
Server DB Maintenance Report - SERVERNAME\System Backups (Success)".

I have installed SQL Server 9.0.1399 ("SQL Server Standard Edition") on my
machine. I've also installed "Microsoft SQL Server Management Studio Express"
(because I couldn't find Microsoft SQL Server Management Studio NOT EXPRESS
ANYWHERE either in the SQL Server Install or to ...

I recently tried to move 12 databases containing metadata for an application
from a dev db farm (64-bit SP4) of SQL Server 2000.  When I detached
everything I got this error listed above.  Luckily I could recover from
backup, but I'm trying to figure out why this occurred so I ...

I'm having a major beef with Management Studio Express when it comes to
editing Views that contain a UNION statement. For starters, it can't display
the View, which I guess is OK, the old tool couldn't do that either. But,
the syntax verification doesn't work either.. I get an ...

I am in the process of migrating an Access DB to SQL Server.  We need to do
this several times as part of the testing / deployment cycle. Right now we
are manually running the Access upsizing Wizard, then running a script to
add in the Views, Stored Procedures, etc.  It would be ...

I have been running querries in management studio and ocasionally I want to
edit the result set but when you double click on the row and column you want
to edit nothing happens. I have searched google and seen some references to
the same question but no answers. This is a feature ...