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?

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.

Is it possible to place the tempDB on internal disk and the data on SAN?
Please help....
Many thanks

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

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.

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

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

I'm using SSMS with SQL Server 2008 and Windows 7.  The following works:
CREATE FUNCTION dbo.test (@testin INT)
RETURNS TABLE
AS

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

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

i have 2 derived tables
TBL A
product code
product color

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?

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

 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 ')

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/

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:

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

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

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

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

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.

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

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.

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

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.

Contato: marvendas@gmail.com
marvendas @ gmail.com
marvendas no gmail.com
Kit completo de solenoides para Volkswagem e Audi.

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:

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

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?