I have a 2 node SQL 2005 cluster (active-passive) that currently has a
single direct attached SCSI array for it's shared storage.  Because
we've reached the performance limit of the SCSI array, I want to
replace it with multiple SAS arrays connected to multiple controllers

We currently have a 2-node SQL 2005 cluster.  We need to break the cluster
and turn it into a standalone server without losing the existing instances
or databases
We want to completely get rid of the clustering, not just run a single-node

I have a active-active node running well, and need to add 3rd node. following
bol I was able to install 2 instances on 3rd node, however, I only can swtich
2# instance to 3rd node, but 1# instance gives me the error: An error
occurred attempting to move the 'SQLAPP' group. The ...

In setting up a 2-node cluster (active/active) do I need to have an
additional SQL 2005 Enterprise license for the second node?
Also, I'm new to clustering and I just want to verify that I can do an
active/active 2-node clustering with SQL 2005? I see alot of talk about

   One my cluster environment I have Server02p$ account name for the 2nd
partner, Server02p in an active-passive configuration.  But I don't have one
for 1st partner; so when SQL cluster fails over to 1st partner Server01p;
because Server01p$ doesn't exist it fails to create the ...

 A server which is configured as SQL 2005 Cluster as an Active/Passive
node.
I have a query, if I can configure SQL 2005 Cluster as an Active/Active node
with Network load balance and can use same SQL virtual IP address.

This is a simple select statement where I am trying to convert a Julian date.
Where one of the fields is zero I get this error.
My Select statement is:
select

I'm trying to figure out how to list what file group every table is in.  I
thought this query was it :
select sys.tables.name,sys.data_spaces.name from sys.tables,sys.data_spaces
where sys.tables.lob_data_space_id = sys.data_spaces.data_space_id order by

Hello again, ive got a table with a column that normally contains a number,
for example, 4057. But there are some that finishes with an a, for example,
4057a. I want to quit the "a" and place a "1" instead, so in the last
example, the 4057a will be a 40571.

Since Microsoft decided to not continue supporting English Query after SQL
Server 2000 what have those of you how used it replaced it with?

I have an osql statement that queries a database.
If the query returns any rows I want them written to a file, so I redirected
the output of my osql statement to a file (results.txt). But if there are no
rows that comply with the condition of the query I do not want any files

Hello everyone
Within each database there is an icon called users, within that user
containner , you can see users has different permission for that database.
Is it possible to display a list of effective access rights for all users

I'm new on FullText Search.
I need this in order to find part of words on 3 of my columns in table
(Table1(Txt1, Txt2, Txt3)
I've discovered the function CONTAINSTABLE(...) which brings me rank of

I have a sql server 2005 db which contains a full text catalog on  a
table, certain columns on that table have a words with hyphens in them,
the customer expects the results to come up when the search term
contains hyphens, but looks like the indexing service uses hyphens as

I am a novice on Full text search, never used it before.
I have a large number of word documents (.doc files) with different layouts
and contents where I need to extract some data to populate a database. The
documents are invoices. In the documents I would like to search for  ...

my full text queries have suddenly stop functioning,when I press execute tab,
its keep on saying "Executing query" for hours.Can any one tell me how to
resolve this problem.
I am using SQL server 2005.In the enterprise manager, I can see Full Text

I have created a sample project to verify the full-text improvements from
SQL 2005 to SQL 2008.
Most queries run much imrpoved, but occasionally I get queries that never
finish (say, after 40 minutes).

I'm running SQL Server 2000 Developers Edition on my Windows XP workstation
(SP2)
I have configured Full text indexing on 1 table in my database.
Everything worked fine untill yesterday.

I have SQL Server 2000 build 8.00.908 and one of my Merge publications has
developed the error "failed to enumerate changes in the filtered articles".
Further details give the following msgs: "Incorrect syntax near the keyword
'where' and "incorrect syntax near the keyword 'and' ...

I have created a publisher and snapshot some of the tables, which are
published to a subscriber.
Now I would like to snapshot a single table for this publisher. I checked
the table  and start the snapshot agent, but it starts  to snapshot all the

I tested the Maximum Retention period of the distributor DB but my test
failed and I would like to know why?
Here after the scenario that I performed:
I set up a transactional replication with a pull subscription.

Is it possible with any version of SQL server to have 1 database in
headquarters and 1 db in a remote site and have them do a scheduled merge
everynight over the vpn connection. Both sites will access (read/write) thier
local db during the day?

Distribution database files were lost because of the disk failure.
We decided to remove completely replication from the server.
I used exec sp_dropdistributor, sp_dropdistributiondb, sp_removedbreplication
I also run delete msdb..msdistributiondbs

Some of the database updates on the Publisher are not being downloaded
to the Subscriber.  However, all the changes at the subscribers are
being uploaded successfully to the Publisher.  But, when I do a
complete download to a new local database I get all the data from the

There isn't much activity in this newsgroup, so it begs to question if
anyone know the future support of Service Broker.
I know it's supported in SQL 2008, but what about after that?  Is it going
to become obsolete in preference of WCF like the http endpoint

http://www.sex-version.com
Biggest On demand adult video publishing 70000+ vids and sharing porn website, strongly interfaced with porn video
WARNING: This website contains explicit adult material.
You may only enter this Website if you are at least 18 years of age, or at least the ...

I'm working with services in separate dbs on the same SQL2005 instance.
When trying to send a message from one service to the other, it fails with a
security context error (916).
The context of the user in the originating db is a dbo.  What is the minimum

I've build a simple procedure which send create new dialog if it not exist
and if so using current dialog.
when i run it as dbo i have no problem to read data from
conversation_endpoints. but when i read data from non dbo user it return no

In an effort to increase traffic to our new news group we now offering FREE
UNMODERATED chat and advertising
just go to
free.uk.retail.poundland.staff.chat

I've installed service broker in one of my sites
IT falt down as result of pages lock. Do i need it for service broker and
what it is?