I have the opportunity to design or DB server with the version that will do
what we need.   If I understand my information correctly, my Standard Version
for SQL 2005 Standard Edition, will not perform indexing without shutting
down the DB.  Howver; Enterprise Editition, as I ...

We have an existing 2 node cluster running SQL 2005 Enterprise x64 SP2
on W2K3 R2 Enterprise x64 SP2. We have added a third node to the
cluster. SQL deployed without a hitch. When we ran the SP2 install
from the active node, the install ended saying it had nothing to

"On the Cluster Network Selection page, specify the network resources for
your failover cluster instance:
   * SQL Server Failover Cluster Network Name — This is the name used to
identify your failover cluster instance on the network.

All,
I'm new to clustering. We are trying to set up an Active-Active cluster
consisting of two nodes with each of the two SQLServer nodes hosting
multiple databases. We followed the two step approach in installing and

We have a sans and a server box that currently has a SQL 2005 Failover
cluster installed, we are attempting to install a new SQL 2005 Failover
cluster but ran into an issue. After setting up the new cluster group and
installing the instance to this group the installer modified ...

In a hypothetical scenerio:
I want 4 node, active/active/active/active cluster.
There are 4 sql instances installed on each node, with name SQLInstance1....
SQLInstance4

I am going to design hospital database
I have a patient table tblpatient(patientid pk,name,age,................)
another table that is tblyearly(yearlyid ,patientid fk,isadmit,department,....
)

I have two tables Person and Employment. Person has 1 row per person,
Employment lists that person's job history where each row is an employment
period at a particular grade. Therefore there can be multiple rows per Person
in the Employment table.

I explain the problem
COL0    COL1     COL2    COL3   COL4          COL5
row1     blabla      37       M        X                 1
row2     dgdgg      35       M        X                 2

I have an SQL database with the following:
[B]TableA[/B] with ItemID, Fk1, Fk2, Fk3, Fk4
[B]TableB [/B] with DescID, description -
Where Fk1-4 is equal to a DescID in Table B.

All, I'm relatively new to SQL server and am having problems writing a
complex date/time query. I have a table with a datecreated field and a
priority. The priority is either 1, 2, 3 or 0. The table also has a
datecompleted field.

Is there a simple and effective way to revert an update query after the fact?

I want to use the Full Text Search feature of Microsoft SQL Server.
If I have a table Client which refers other tables like City, Country,
Department, etc. is it better to create a separate table that would
hold de-normalized data, which would then be full text indexed, or is

How can i repair this?

I am using the June CTP release of SQL Server 2005 on Windows Sever 2003.
Is there a quick way to get a total natch count (estimate is OK)
of a SQL FullText query? I am working with about 10 million r
ows of simple character data.

I want to set a minimum word length on a Full Text Catalog to a value lower
than the default setting.  Is this possible to do?  When I look this issue up
on the Internet it can be done using MySQL.  I am using SQL Server 2005.
Please advise...

I am using SQL Server 2005 and the index for full text search consists of 5
fields.
While there is everything fine searching only one word or searching several
words with OR, i encounter unexpected results while searching with two or

 The query pasted below
SELECT CAST(copy.copyid as VARCHAR(50)) as copyid
FROM copy,story,brief,link_copy_issue,brief_issue
WHERE CONTAINS (copy.*,' weight AND loss ')

Publisher w/ 2 subscribers running merge replication.
the data was on all three machines and the i changed tables on the
publisher so the identity column was in a different range. i wanted it
to be an increment of 2 and a seed of 100,000, but instead i set an

I am assigned to do a transactional replication of a large database of size
more than 4 TB and As the snapshot cannot hold the large amount of data I am
looking for better solution like initialize the database from the backup and
then perform the replication.?

I have got 2 publisher replicating to a subscriber
Publisher1 - Server1 / Db1
Publisher2 - Server2 / Db2
Subscriber - Server3 /Db3

Platform: 2 machines - Win2003 Server SP2 x64, SQL Server 2005
Problem: The subscriber is not being updated even though Replication Monitor
says Publication status is OK and Subscription Performance is Excellent.  It
was working fine for weeks and then just got stuck.  ...

I am looking for a step-by-step guide on how I can set-up a replication
between 1 single SQL Server 2008 publisher and SQL Server 2008 subscriber. I
am regularly taking full back-up of the publishing database. Distributor is
already present on the publishing server.

I have two questions regarding replication.
1. I have replication that setup as non initial snapshot, and manually
initialize a pull subscription to a transactional publication. When I got
error in subscription and I need to remove the table from replicaiton. But

Even though it came out with SQL server 2005, I am new to this concept...
I have a process whereby I would like to accomplish the following...
The setting includes many client workstations using a VB.net application to
communicates with a database via ADO connections.

How could I pass parameters to the procedure I execute through a Queue ?

I'm an analfabeth as long as it concerns buz words..
I tried to search in Wikipedia the term "Service Broker" and was directed to
Service-oriented architecture (http://en.wikipedia.org/wiki/Service_broker).
Is it correct?

Here is a tip I can share that may help others that use SQL Service Broker in the way I do.
Definition:
I have queue tables that have triggers defined on them, which fire messages on INSERT/UPDATE to SQL Server Broker for processing, sort of like this below.
Sometimes I need to fire ...

I have a stored proc. tied to a Queue activation.  I use valid xml to
exchange information between queues.
Is there a way to know which message is being currently processed . ?
Currently i am writing a log when the stored proc is being called. I am

I have an application that puts data into a table in a remote database
instance. The problem is that when the database or network is down the
application has nowhere to put the data. To overcome this, I have decided to
save the data to a local instance and use Service Broker to ...