Msg 170, Level 15, State 1

This error has been reported in a number of previous occasions. However in my case non of the suggested solutions appears to work

--==================================================
CREATE VIEW dbo.vAllLesions
AS SELECT
dbo.Patients.idP, dbo.Patients.Surname, dbo.Patients.GName, dbo.Patients.Sex,
dbo.Patients.DoB, dbo.Lesions.idL, dbo.Lesions.OriginalIdBase,
dbo.Lesions.OriginalIdL,
dbo.Lesions.Notes,
dbo.Lesions.idBatch,
dbo.UserLesionFlags.value As FlagValue
FROM********
dbo.Lesions INNER JOIN
****************dbo.Patients ON dbo.Lesions.idP = dbo.Patients.idP LEFT OUTER JOIN
****************dbo.UserLesionFlags ON dbo.Lesions.idL = dbo.UserLesionFlags.idL
WHERE**** (dbo.Patients.Exported = 0) AND (dbo.Patients.DeletedDay IS NULL) AND (dbo.Lesions.DeletedDay IS NULL)
GO
--
================================================
Server: Msg 170, Level 15, State 1, Procedure vAllLesions, Line 10
Line 10: Incorrect syntax near '*'.
Acoording to the error report there is a proplem with inner join but just what is the problem.
Regards
Joe

Quote:

Originally Posted by underdown

This error has been reported in a number of previous occasions. However in my case non of the suggested solutions appears to work
Joe

Sorry for the trouble. Turned out to be hidden characters that I removed using (guess what) Edit.
Regards
joe

MSDTC - confused

Reading some previous threads, I am a little confused.
We have 2 Windows 2003/SQL 2000 clusters.
One has been in production for months now, without problems.
We did not follow KB 817064 (how to enable network DTC access) or KB 301600
(configuring MSDTC on 2003), yet our install went fine and SQL fails over
and works. I see in the services applet of both nodes that the DTC is
installed, set to automatic, but not started. It is not setup according to
the above mentioned article and neither is Network DTC access in the
Add/Remove Windows Compents of our servers.
So, now I am confused. How is it that our install went fine, seems to work,
but yet it would seem we didn't do it correctly?
Thank you,
Jeff
You do not need DTC to install SQL Server 2000 on a cluster. You only need
to install Network DTCand /or configure DTC if you plan to use distributed
transactions.
Rand
This posting is provided "as is" with no warranties and confers no rights.
|||Thank you Rand, that clears things up quite a bit.
Jeff
"Rand Boyd [MSFT]" <rboyd@.onlinemicrosoft.com> wrote in message
news:6vffNsmWEHA.2920@.cpmsftngxa10.phx.gbl...
> You do not need DTC to install SQL Server 2000 on a cluster. You only need
> to install Network DTCand /or configure DTC if you plan to use distributed
> transactions.
> Rand
> This posting is provided "as is" with no warranties and confers no rights.
>
|||you can install DTC later also and it shoudl work fine
"JJP" wrote:

> Thank you Rand, that clears things up quite a bit.
> Jeff
>
> "Rand Boyd [MSFT]" <rboyd@.onlinemicrosoft.com> wrote in message
> news:6vffNsmWEHA.2920@.cpmsftngxa10.phx.gbl...
>
>