I think that this is the culprit:

FROM TASKPOS...EJTable

I do not believe that you can just use the Server and Table portions of the 4 part naming, you have to...

I had this problem on a server with a FireWire interface, seems that when Windows Server 2003 was installed a "network adapter" was installed in addition to the "standard" NIC...

Try this:

SELECT cl.Code, cl.Name

FROM Country_lkp cl (nolock)

   INNER JOIN SalesCountryDestination_lnk scd (NoLock)

      ON cl.Code = scd.destinationcode

         AND scd.SalesCountryCode = @CountryCode

   INNER JOIN DestinationArticle_lnk da (NoLock)

      ON scd.SalesCountryDestination_Id =...

Actually the VB6 boolean is True = -1 and False = 0, so to convert the myVB6Bool variable to SQL bit would be Abs(myVB6bool), which returns 1 or 0 instead of...

Reverse your test, always leave the SQLMail Started, your test is leaving it Stopped.

This is the main problem with SQLMail, the connection between SQLMail and Exchange is persistant, restarting the Exchange...

Having chased this down receintly, the fault is Microsoft.

Microsoft keeps breaking ADO (MDAC) and now NativeClient (SQL 2005) by changing how the default Network Library is chosen. If you...

I use individual queries to define each level, then:

Select * FROM

(Select query that returns the desired Master

            , Date in your example) Master

LEFT JOIN (Select query that returns the level...

From your debug statements it looks like you should have seen this:

if exists (select * from inserted)

 BEGIN

  if exists (select * from deleted)

   select @Type = 'U'

  else

   select @Type = 'I'

 END

else

 select @Type = 'D'

When...

SQL Mail is a MAPI connection, here is my reset T-SQL:

DECLARE @Err int

EXEC master.dbo.xp_stopmail

WAITFOR DELAY '0:0:02'

EXEC @Err = master.dbo.xp_startmail

IF @Err <> 0

 RAISERROR('xp_startmail: Failed to start SQL Mail session.',19,1) WITH...

Toby,

When you are ready to post the self learning "stripper" code, I am ready to take a look.

Pun intended.

Andy

Did you try:

select sectionname, count(sectionname)

        , min(cont_section_id), max(cont_section_id)

from sectionnames

group by sectionname

order by max(cont_section_id)

To see why the ORDER BY shows what it does?

Andy

You posted in SQL 2000 / 7 but quote and article for SQL 2005, which are you using?

How did you calculate the total size 5968?

Here is a great article and...

Make sure the Client Tools on your workstation are at the same service pack level as your server.

Andy

SELECT REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(Phone,' ',''),',',''),'+',''),'-',''),'(',''),')','')

FROM MyTable

Andy

Try,

SELECT COALESCE(NULLIF(Mobile,''),NULLIF(Business,''),NULLIF(Private,'')) as Number

FROM Table

Andy