having sql2000 on win2000
when running long lasting queries [30 minutes f.e.], and running them async,
is there some method to periodicaly check the percentage of completness?
i know there is a status indicating when the query is done, but is it

We have a new server, 4 physical dual core processors, with hyperthreading,
so it shows up as 16 logical processors.
A simple query joining 3 tables, a distinct, an order by, with maxdop set to
0, takes over 2 seconds.  With maxdop set to 1, it takes 200 milliseconds.

I want to change following store procedure, it takes around 5 minutes to
execute & I calls for  each vessel / voyage combination... , Could any one
help me to fine tune this store procedure.
--------------------

Is post SP2 hotfix build 3175 a good build to use?
Thanks
Chris

DTS packages on 2000 need to be migrated to 2005.  Looking for an easy
migration.  What are some of the resources and tools available?  We have
about 30 packages so the $25 per package is not an option.  More interested
in a simple tutuorial - something along these lines.  

This requirement is for our development and test environment. We have
a database server which we use for development hence many changes are
done on the database objects on daily basis like tables def changes,
view def changes, sp changes, new sp etc.

Hi. I hope someone can give me some ideas.
I have a SQL 2005 dev installed in my Vista and I tried to register it from
my Win 2003 server which also has SQL 2005.  I get a time out message, it
seems the server cannot connect to my vista sql server.  I already set my

I have SQL 2005 database, around 500gb in size. We're working on deleting a
lot of useless records. In some tables, this could be in excess of 70% of the
data. The largest tables are ~82gb, very wide, with wide clustered indexes. I
know this sounds bad - we are working toward ...

I am using SQL Server 2000 and I am trying to change the identity seed in a
table. I want to change this via a script. I have used the following command:
DBCC CHECKIDENT (dbo, RESEED, value)
where

I have had some users contacting me and reporting this error message when
refreshing SQL Server queries in their Excel 2003 spreadsheets:
"Unknown token received from SQL Server"
They are using Excel installed on a Citrix server.

Hi
I am trying to change default port on sql server 2005 via sql config
manager, but the change is not taking effect even after restarting the
services. Any ideas would be appreciated?

I test db. mirroring.
While it's working, tr. log continues growing. while I run tr. log dumps
regulary, the size of it only goes up.
I tried dbcc shrinkfile and shrinkdatabase - it won't help.

My table on the SQL 2000 Server has a filed Id which is a (clustered)
primary key.
There is but another field named Field1 and I wish to define it as unique or
it could be Null.

Accroding to the following Article:
http://support.microsoft.com/?id=274750
Note The maximum amount of memory that can be supported on Windows Server
2003 is 4 GB. However, Windows Server 2003 Enterprise Edition supports 32 GB

I have followed the procedure in http://support.microsoft.com/kb/275312
to change object ownership so that I can delete a user.
This appears to have worked ( subsequent runs tell me that the
original user owns no objects and a query on the sysobjects table