Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum

Tip: Looking for answers? Try searching our database.

Other Technologies

Recently updated threads


Thread preview

Clustering (view all ...)Last Post  Replies
Looking for high performance cluster storage28 Aug 2008 21:00 GMT-
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
Uncluster SQL 200528 Aug 2008 20:36 GMT1
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
Can not Switch to 3rd node: error ID 5042: cluster node was not fo28 Aug 2008 19:10 GMT-
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 ...
License question28 Aug 2008 17:16 GMT2
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
Accounts Server$28 Aug 2008 00:32 GMT-
   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 ...
Network Load Balancing in SQL 2005 Cluster27 Aug 2008 23:10 GMT3
 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.

English Query (view all ...)Last Post  Replies
Adding a value to a 'datetime' column caused overflow.27 Aug 2008 17:06 GMT2
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
Determining which tables are in which file group via T-SQL27 Aug 2008 15:39 GMT1
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
Updating data27 Aug 2008 15:35 GMT1
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.
How have you replaced English Query?08 Aug 2008 15:27 GMT1
Since Microsoft decided to not continue supporting English Query after SQL
Server 2000 what have those of you how used it replaced it with?
Output file31 Jul 2008 18:42 GMT3
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
printout of effective access rights for all users and groups for a31 Jul 2008 05:47 GMT1
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

Full-Text Search (view all ...)Last Post  Replies
using rank in fulltext28 Aug 2008 21:13 GMT1
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
hyphen as word-breaker25 Aug 2008 17:57 GMT1
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
Full text search to find near numerical values?20 Aug 2008 22:09 GMT2
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  ...
full text search problem!!.....help20 Aug 2008 12:16 GMT4
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
SQL Server 2008 iFTS Query Plan Question/Problem20 Aug 2008 12:14 GMT1
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).
Error message on Full Population20 Aug 2008 12:12 GMT1
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.

Replication (view all ...)Last Post  Replies
Failed to enumerate changes in the filtered articles29 Aug 2008 03:20 GMT-
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' ...
Making single table snapshot using sql server 2005 enterprise28 Aug 2008 21:40 GMT1
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
Maximum Retention period of the distributor DB (transactional replication) does not work28 Aug 2008 09:04 GMT1
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.
2 databases merge at night27 Aug 2008 20:51 GMT-
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?
Help to Remove Replication27 Aug 2008 19:04 GMT2
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
Subscribers are no longer getting all update applied at the Publisher27 Aug 2008 17:10 GMT3
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

Service Broker (view all ...)Last Post  Replies
future of Service Broker27 Aug 2008 13:41 GMT8
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
Looking for beta tester win free pass for life www.sex-version.com23 Aug 2008 15:22 GMT-
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 ...
minimum required security for messaging between db's21 Aug 2008 18:04 GMT1
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
aceess for service broker14 Aug 2008 00:38 GMT1
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
Free Advertising12 Aug 2008 03:40 GMT-
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
pages lock05 Aug 2008 13:08 GMT2
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?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage




©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.