When doing an integrity Check, I choose All databases.  However, it ends up
erroring out because one of the databases is offline.  I would think that
since it's offline, it would not try to do an integrity check, but it does.
Am I missing something? or is this expected behavior?  ...

I want to put a copy of SQL Server 2000 on a desktop machine here that is
really strong, but I want to make sure that it will work on XP Pro first.
Will SQL 2000 Server work on an XP Pro machine? Thanks!

I met really strange problem. On 1 host we have 3 instances running in VM
machine. Yes, it was not configured properly, but...
default instance would shout 100% cpu right after startup. I checked all
event log records, errorlogs, dump logs - all look inocent. No option

I'm trying to migrate our current systems of Janna Contact and
Peachtree Accounting over to MS BCM and MS Accounting.  Naturally, I
want to integrate the two latter products with each other, while
keeping all of the data accessible to any computer on the network.  To

I am using SQL Server 2005 Std Edition.  Can I have more than 1 database of
the same name on the same physical server?  If so, how can that be done?
Thanks.
David

I have a client who just installed SQLEXPRESS and I was having him test by
using sqlcmd at a c:\> prompt.
he got an error "No connection could be made because the target machine
actively refused it"

I have read the SQL 2000 32 bit and SQL 2005 64 bit can be installed on the
same machine.  During the installation of the Integration Servcies I received
the following error: {copied from SQLSetup0002_SQLDEV64_DTS.log}
<Func Name='LaunchFunction'>

I'm relatively new to SQL, so this may be a dumb question.
I have a DB say at SiteA and a web site at SiteB (the reasons are business
related).
Anyway, can I access the data in SiteA from web pages at SiteB? My suspicion

If I look at the query plan of 2 simple queries that are essentially
the same, but one uses a CTE, the plans are the same and so is the
logical reads to execute it. Here is an example:
WITH x as (SELECT titleid, authorid FROM books)

This situation is a little complex. Imagine a table called grptest
that looks something like this:
VisitID    CaseID    ProcedureID    VisitProcedureID
2219    106319    20123    948

Is there a way to see the memory (RAM) usage by an SQL Server instance, and
get that value by executing a statement in Query Analyzer?
SQL Server 6.5
SQL Server 7

If someone instruct me how to do Mirroring with screen shot and with
steps to do it.
Thanks in advance.
Zubair

I have implemented log shipping between A production Server say PROD1
database and two DR server's DR1 and DR2.
After implementing log shipping LOG file in Prod1 started to increase,
with in 3 days it has reached to 40 GB.

I have the table "EmployeesTimeWork" with the structure:
IdEmployee  Date   TimeIn  TimeOut
-------------------------  ---------   ------------------
In other I have the 1 day ranges from the hours like

Without having to recreate this processing in SSIS, I have an existing
Access program
which I can run by commandline.  The batch file runs an AccessDB executing a
specific macro.