I had tired to create index on large databse (>200GB, engine ss2k) but
I got errors, so I executed DBCC CHECKDB. DBCC told me that I have to
execute it with repair options. But I noticed in Activity Monitor that
I had still running creating index process with EC wait type. Then I

Hi Experts,
I am having new issue again,
My task is to copy data from one table to another table residing in
different database.

I understand that SQL Server 2005's licensing model is per socket, not per
core, for physical and virtual installations.  For virtualization, I
understand you can have multiple SQL Server 2005 installs and the licenses
are shared across the physical server.  Licensing is still ...

Gurus,
Is there any advantage to running an application to use named pipes in
connecting to a SQL Server instead of TCP/IP?  I would think no, b/c named
pipes is a legacy, slower form of communication, correct?

After more than 2.5 years of running the sp_updatestats on our production
(OLTP) SQL 2005 SP2a CU3 server we have suddenly noticed an abrupt change in
runtime behavior. Prior to 3/6/2008 this job was scheduled to run daily
(6:30am). The job historically completed in 9 – 11 min. ...

Hopefully I can ask this question w/o too much confusion. The example I am
about to give may not be practical, but the answer should help me understand
db and log backups a little better.
Scenario:

Source computer: SQL server 2005 SP1
Remote computer : SQLEXPRESS  
When I try to register/connect with remote server (named instance) using sql
server management studio I am getting following error:

Hey guys,
This may sound like a dumb question, but I am remoted to a customer's
server, and I need to run some SQL scripts.  They do have SQL server
2005 installed.

Gurus,
I noticed when my SQL Server Agent is stopped, what appears in SSMS is the
following:
"SQL Server Agent (Agent XPs disabled)"

Using MSQL SMS:
Table one: access db.
Table two: remote sql db table.
Using the import export wizard:

I need to migrate our databases from one server to another. Now since these
databases have DTS packages/scheduled jobs associated with them, should i
just restore the MSDB database on the target server to recover all settings?
Or is there any alternate way that will be best for my ...

Cache hit ratio -> Counter in Category -> SqlServer-Catalog Metadata, shows
20-27 as average in our boxes. Is this fine? Whats the ideal or recommended
range for this counter?

my database is 9G! I try to truncate some table to make the database smaller
but it seems it doesn't help, the database size has not changed by truncate
some table, so is there any good method to make the database size smaller? (I
accept some data loss in some table)!!

After I reboot my server server 2003 with SQL it expands the room taken on
the RAID array and then drops back after leaving only 10GB on 150GB hard
drive space to ony 40GB leaving 110GB.
Any ideas to why it does this after a reboot.

After a recent upgrade from SQL Server 2000 to SQL Server 2005, we get
problems with certain queries using a Transact SQL cursor.
I have noticed the following:
Table with a smaller number of rows.