Here is some info from BOL:

mk:@MSITStore:C:\Program%20Files\Microsoft%20SQL%20Server\80\Tools\Books\acdata.chm::/ac_8_md_06_7j1y.htm

The ODBC API does not support explicit transactions, only autocommit and implicit transactions.

mk:@MSITStore:C:\Program%20Files\Microsoft%20SQL%20Server\80\Tools\Books\acdata.chm::/ac_8_md_06_2g6r.htm

OLE DB does not have a method to set implicit transaction mode specifically....

I use Visio from Visual Studio for Enterprise Architects (2002 or 2003).

Andy

"exec sproc @a = @a, @b-2 = @b-2, @c = @c

Is there any reason for assigning a variable to itself in an exec statement?"

This is actually not assigning a...

Since you stated "Had the ops guys set up Outlook 2003 ( not custom ) just standard.", this is the issue.

You must use the Outlook custom installation option in order...

Always use the ISO date format "yyyymmdd" and you will win, no matter the SQL Server's date format setting or the user's date format setting.  (MDY, YMD, or DMY)

In Access...

With a server reboot time of 4 minutes, that means one patch reboot a year.

Can a Windows ever achive 99.999% uptime when there is an estimated 12 reboots a...

You are going to have to save the word document to a file then attach the file to the email, and then delete the file after the email is sent,...

My experience is that the UPDATE table must also be the FROM table, so here is the tweaked example from sushila.

SET ANSI_WARNINGS OFF

UPDATE table2

   SET table2.a = t1.a, table2.b...

In EM, choose Properties for SQL Server Agent, then Connection tab, if it is configured to Use SQL Server Authentication and sa as the SysAdmin login ID, then change the...

This is not random, but accomplishes the rest

SELECT TOP 5 id, SUM(point)

FROM MyTable

GROUP BY id

HAVING SUM(point) = 50

Andy

Could the problem be:

delete [122.24.2.5].sweet.dbo.visit_detail

from [122.24.2.5].sweet.dbo.visit_detail a

inner join temp_stats_daily b

on a.remote_host = b.remote_host

Andy

Here is one way of calculating the First Monday Of the Month and Last Friday Of the Month for @MyDate

DECLARE @MyDate datetime, @FDMo datetime, @LDMo datetime

SET @MyDate = '20050918'

SELECT @FDMo...

Check this out:

DECLARE @Cnt int

SET @Cnt = -1

WHILE @Cnt < 6

BEGIN

 SELECT @Cnt, CAST(@Cnt AS datetime)

  , DATEADD(wk,DATEDIFF(wk,@Cnt,GETDATE()),@Cnt)

  , DATENAME(dw,DATEADD(wk,DATEDIFF(wk,@Cnt,GETDATE()),@Cnt))

 SET @Cnt = @Cnt + 1

END

I do not know who figured this out but...

Change:

SELECT name FROM sysdatabases WHERE sid <> 0x01

To

SELECT name FROM sysdatabases WHERE sid <> 0x01

     AND name NOT IN ('master','model','msdb')

This way they are excluded from your loop.

Andy

In a production environment, unless you have really good hardware and loads of memory, I would always suggest a dedicated server for any Client Server RDMS, as all are designed...