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
Uncooperative MSDTC Instance18 Mar 2010 15:04 GMT-
I can't get my MSDTC instance to move to another node. . . .unless I down
the node where it's running.  Then, the instance will travel.    What's up
with that?
Can I just create another instance?
Cluster service is attempting to failover the cluster resource gro16 Mar 2010 13:59 GMT12
The SQL cluster is not failover over to another node. Can anyone shed some
light in to this. I have checked the config on the cluster administrator side
and it all seems correct to me. The event id appeared is 1153 event source:
clussvc.
SQL Server 2008 and tempDB with SAN10 Mar 2010 20:17 GMT7
Is it possible to place the tempDB on internal disk and the data on SAN?
Please help....
Many thanks
SQL 2005 Cluster Error and VIA protocol error10 Mar 2010 19:07 GMT-
I cannot diasbale the VIA protocol and get the primary SQL instance to start
in my Virtual Cluster the Attributes of the Server configuration is as follow:
VMWare: Cluster configuration
OS: WServer2003R2 SP2
DB Hammer06 Mar 2010 08:43 GMT2
Two questions:
1.  Has anyone used MS's database hammer tool that comes with the resource
kit?  I'm running into errors when running the loadmaster app  Any info on
your real life experience would be greatly appreciated.
SQL Server SAN timeout settings02 Mar 2010 15:13 GMT2
I am running SQL Server 2005 x64 on Windows 2003 active/passive cluster. We
are currently having latency issues with our SAN, this is causing the SQL
Server instance to restart when the latency is high. We are addressing the
SAN latency issues with the SAN vendor but in the ...

English Query (view all ...)Last Post  Replies
multiple criteria to case statment06 Mar 2010 23:05 GMT1
See the SQL statement below.  It is based on a table called datanorm.  I have
another table called ToUSTART where the DATANORM.ID will join to the
TOUSTART.USERID with one(toustart) to many(datanorm) relationship.  Within
TOUSTART there is a datefield called TOUSTART to compare ...
BEGIN END not working28 Jan 2010 13:38 GMT4
I'm using SSMS with SQL Server 2008 and Windows 7.  The following works:
CREATE FUNCTION dbo.test (@testin INT)
RETURNS TABLE
AS
data type mismatch24 Jan 2010 11:19 GMT1
sir/madam,
i have two parameters , one for int and one for varchar. In print statement
i wrote as
PRINT 12 + '12' then it gives 24 as result, but when i give 12 + 'neha' it
Show Top Value Only01 Jan 2010 20:08 GMT1
I have a single table with 5 fields:
READID (key), ID (user identifier), READDATE, TOD (time of day - as INT 1,
2, 3, etc...), CONSUMPTION (measurement).
I'm looking to return the maximum measurement (CONSUMPTION) from each day
Need hep for a simple query11 Dec 2009 14:25 GMT1
i have 2 derived tables
TBL A
product code
product color
Formatting a date27 Nov 2009 14:49 GMT2
When I want to format a date in a view, I use e.g.
CONVERT(Char(20), tblPE_Personen.PE_Geboortedatum, 112)
With the CONVERT function, I am limited to the available Date and Time Styles.
How can I get an output such as e.g.  mmdd or as dddd dd mmmm yyyy?

Full-Text Search (view all ...)Last Post  Replies
Sql Server 2005 - Full Text Catalog Special Characters02 Mar 2010 19:10 GMT-
To Whom It May Concern:
My name is Al Battle and I'm a Senior Software Engineer with eComSystems.  
I'm working on a project which includes the usage of Sql Server 2005 Full
Text Catalog.  I'm encountering some difficulty returning results which
"weight" failing in fulltext search in Sql-Server EE01 Mar 2010 18:45 GMT7
 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 ')
ANTIVIRUS FREE DOWNLOAD 916926 Feb 2010 16:46 GMT-
Many problems with performance and safety of your computer can be solved
easily with an updated antivirus and recognized. Antivirus Free Download
Microsoft best practices in:
http://yourantivirusfreedownloadonthissite.blogspot.com/
DESCARGAS - ANTIVIRUS GRATIS 763917 Feb 2010 18:28 GMT-
Muchos problemas de rendimiento y seguridad de tu computador son causados por
virus maliciosos, la mejor forma de combatir esto es tener instalado un
Antivirus reconocido y actualizado en tu computador
Descarga gratis Antivirus en:
Full Text Service not starting from EM09 Feb 2010 14:12 GMT8
I have the following problem. Everything was working fine
with the full text search. I created a catalog etc... now
in EM, database->tools->"Full Text Indexing" is grayed
out. I cannot use the full text indexing with tables
Accent insensitive search..05 Feb 2010 15:56 GMT6
I am trying to implement search functionality in my web application which
does not return the expected results in accent insensitive search.
Database collation : Latin1_General_CI_AI
If i create a index with italian language as word breaker  and run the

Replication (view all ...)Last Post  Replies
Reconciler Test fails on multiserver environment (MSSQL 2005, IIS     6.0)18 Mar 2010 12:02 GMT3
My Reconciler Test fails and I have no idea why.
I had working single-server publishing going on, but now I have to
change it to multiserver environmet (Same sql server, different IIS).
The old setup is still working so I haven't broken anything on the SQL
Merge replication:  syncing data from the subscriber to the publis17 Mar 2010 22:11 GMT-
I have the following senario:  SqlServer A in outside the corp firewall in
the DMZ.  SqlServer B is inside the corp firewall.  I want to sync data from
A to B.
I have set up merge replication and a publisher on B.  B is also setup for
Moving the Distribution Database to a server with the same name17 Mar 2010 16:20 GMT-
I have built a duplicate remote distributor server and I am trying to move
the distribution database to the server without breaking the existing
replication but I am having a few problems.
This was the steps I followed.
How to configure web synchronization with sql server 2005???17 Mar 2010 11:36 GMT-
I have a problem when synchronizing web publication.
I begin by giving you an insight into my soft installed:
-sql-server 2005
-windows 7even so IIS7
Cannot insert explicit value for identity column in table x16 Mar 2010 20:49 GMT-
I am reposting this from the Sql Server Forum.
We are using Sql Server 2005 9.00.4035.
We have a hub and spoke topology which includes 6 tables with identity
columns.
Preparing for replication on sql server 200015 Mar 2010 21:19 GMT-
Hello all I am using sql server 2000 sp4 (boy do I feel obsolete)
I am trying to prepare for replication (transactional Replication ).
The manual I am following tells me that I need locate identity columns in
the schema and adjust them to "NOT FOR REPLICATION" The below query

Service Broker (view all ...)Last Post  Replies
Service Broker proper usage ?11 Mar 2010 03:09 GMT2
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.
marvendas@gmail.com Kit completo de   Solenoides ( solenoid ) + chicote Para Cambio automatico 01M hidramatico Audi A3 Vw Golf gti turbo 0551220 Feb 2010 03:24 GMT-
Contato: marvendas@gmail.com
marvendas @ gmail.com
marvendas no gmail.com
Kit completo de solenoides para Volkswagem e Audi.
DESCARGAS - ANTIVIRUS GRATIS 786918 Feb 2010 13:01 GMT-
Muchos problemas de rendimiento y seguridad de tu computador son causados por
virus maliciosos, la mejor forma de combatir esto es tener instalado un
Antivirus reconocido y actualizado en tu computador
Descarga gratis Antivirus en:
TÉLÉCHARGEMENT GRATUIT ANTIVIRUS    640714 Feb 2010 17:23 GMT-
Nombreux problèmes de performance et la sécurité de votre ordinateur sont
causées par des virus malveillants, le meilleur moyen de lutter contre cela
est d'avoir
reconnu Antivirus installé et mis à jour sur votre ordinateur
CREATE QUEUE + Procedure_Name + parameters26 Nov 2009 17:17 GMT3
How could I pass parameters to the procedure I execute through a Queue ?
Service Broker = SOA?30 Oct 2009 18:12 GMT1
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?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage




©2010 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.