Viewing 15 posts - 16 through 30 (of 426 total)
I think that this is the culprit:
I do not believe that you can just use the Server and Table portions of the 4 part naming, you have to...
May 2, 2007 at 12:09 am
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...
April 12, 2007 at 9:51 pm
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 =...
April 4, 2007 at 12:48 am
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...
April 2, 2007 at 2:18 am
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...
April 2, 2007 at 1:51 am
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...
March 30, 2007 at 12:57 am
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...
February 16, 2007 at 12:45 am
From your debug statements it looks like you should have seen this:
if exists (select * from inserted)
if exists (select * from deleted)
select @Type = 'U'
select @Type = 'I'
select @Type = 'D'
February 13, 2007 at 1:37 am
SQL Mail is a MAPI connection, here is my reset T-SQL:
DECLARE @Err int
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...
February 13, 2007 at 12:43 am
When you are ready to post the self learning "stripper" code, I am ready to take a look.
February 13, 2007 at 12:11 am
Did you try:
select sectionname, count(sectionname)
, min(cont_section_id), max(cont_section_id)
group by sectionname
order by max(cont_section_id)
To see why the ORDER BY shows what it does?
February 2, 2007 at 2:02 am
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...
February 2, 2007 at 1:53 am
Make sure the Client Tools on your workstation are at the same service pack level as your server.
January 25, 2007 at 9:02 pm
SELECT REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(Phone,' ',''),',',''),'+',''),'-',''),'(',''),')','')
January 18, 2007 at 8:22 pm
SELECT COALESCE(NULLIF(Mobile,''),NULLIF(Business,''),NULLIF(Private,'')) as Number
September 28, 2006 at 12:39 am