I am the newbie about SQL server.
I am facing a problem about install SQL2000 standard server over Windows2003
SP2 standard server.
While I clicked the setup.exe, it prompted me the following message:

I have hundreds of DTS packages that I brought over from SQL2000 into
a SQL 2008 Enterprise SP1 64 bit environment, on Windows 2008 R2 64
Bit.  Our plan is to bring everything over as is, and convert to SSIS
as time permits.  I've run into a bit of a stumbling block hopefully

I'm running a query on the sysjobhistory table on multiple servers. This
works fine, except that the results are not sorted by server name, which is
quite annoying. As the column "server name" is not part of the query, is
there a way to sort by this column ?

After doing a restore to migrate a SQL 2000 database to SQL 2008 we ran the
DBCC CHECKDB DATA_PURITY command which identified Invalid Rows in several
tables.
The data type of many of the identified columns was numeric(16,2), and we

We recently have upgraded an application from sql2000 to sql2005.  After
changing the ODBC on the client machines to point to the new server the users
are now experinacing a "User 'public' does not have permission to run DBCC
TRACEON", and the excel query will not refresh.  If we ...