I am running SQL 2000 SP4.
I have a table1 with about 6.5mil rows.  I created another table
(table2) and I needed to transfer all data from table1 to table2. I
used DTS Import/Export feature however packages keeps running without

For the past couple of weeks now, my sql server agent shuts down on its own
without leaving any error messages.  Nothing really occurs prior to the shut
down.  
2008-05-19 13:57:28.84 server    SQL server listening on TCP, Shared Memory,

If I run an update statistics and then cancel it before finishing, does it
have any kind of effect on statistics?  Or is the end result the same as not
having run anything in the first place?
Thanks!

I’m trying to create a re-useable stored proc that will build an error
message that will be returned to the calling proc, I’ll call this proc
BuildErrorMsg_sp.  Then I can keep all the error trapping code in all
my transact sps small, I don’t have to duplicate all the error

This is an old issue, but I want to see whether there are new tricks.
If I want to start the SQL instance in a single user mode and I don't want
any app to get into it before I do, I can start it to listen on a different
port and disable SQL Browser. I think this is pretty safe. ...

I heard many comment about not putting SQL server on a domain
controller. Can someone tell me what is the implication of it?
Thanks

We are converting some queries that were used in SQL Server 2000 to SQL
Server 2005.  They have a where clause like below:
where personid *= recv.personid
What is the *= an OuterJoin?

I am getting the follow error message when trying rebuild an index or
run DBCC Checkdb.
ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Attempt to
fetch logical page (1:53888) in database 'db1' belongs to object

Need help here:
Upgrading from 2000 to 2005 and applying SP2 ran well.   But the
instance and databases are still showing version 8, not 9, even though
the EM is 2005.

I know this is a bit of old chestnut as questions go but I have
experienced serious problems making a remote connection. I have
googled this issue to death and using all the configuration tools I
have:

We are having problems with database performance at some of our bigger
customers.  Our biggest customer has a 1.1 TB database and they are not
happy.
We have done a number of tests on the system and every indication is that we

We have 2 instances on a box with 32 GB of RAM. When we set max memory on
each, do we want to give each say 30GB leaving 2GB for OS or do we give each
instance say 15GB with a total of 30GB?

Using Sql server 2005.
I would like to know if there is a utilty or if you have any ideas on
finding out
which records have been accessed in a very large table?

I need to set the Isolation Level (in ADO) for the Non-transaction queries
to SNAPSHOT.
Both the ADO.Connection.IsolationLevel Property and the SQL Server SET
TRANSACTION ISOLATION LEVEL command set the Isolation Level for the

table 1
abc
241060     3332.29   
table  2