You are doing fine and there is a klugy work-around for mapping global variables that is at http://www.sqldts.com/default.aspx?234.

Basically, the steps are:

1. Have a dummy sql statement that is on one...

Did you apply the MDAC Service Pack to the web servers ?

Is the client Windows 2003 or XP ?

There are a couple of reasons:

For Windows XP, Windows Firewall is enabled on the computer. By default, Windows Firewall blocks the MSDTC program.

See...

Do not use an "AFTER INSERT" trigger, but try using an "INSTEAD OF INSERT" trigger

that inserts into the same table.

CREATE TRIGGER [trgTest]

ON [dbo].[tblMyLog]

FOR INSTEAD OF INSERT

AS

set nocount...

If you run a google search versus microsoft.com, you will find 2 fixes for the problem.

Product: MDAC 2.7

Solution: Apply SP1

URL: htp://support.microsoft.com/kb/322144/EN-US/

Product: SQL Server 2000

Solution: Apply SP1

URL: http://support.microsoft.com/kb/302409/EN-US/

To comply with Sarabannes-Oxley, no one, including the DBAs, are allowed to use generic accounts such as "sa". Instead, each DBA connects using an separate account. To prevent anyone...

Does the SQL Server service account have rights on the remote server ?

Also, since you are using the adminstrative share (c$), the account will need be a member of the...

The SQL Server could be configured to only allow Window Accounts to connect and not allow SQL Server accounts.

Are you using the MSDE edition ? If so, integrated security...

Task Manager does not provide accurate memory usage information for AWE. Specificly, the memory indicated for sqlservr.exe is never correct.

You must use the Performance Monitor to retrieve information on...

Here are the benchmark numbers from running the SQLIOStress utility on 2 servers where one is RAID-5 and the other is RAID-1.

The results are seperated by !

DB File Placement!Data and...

Here is quote from a major bank's new security access policy:

"No member(s) of any staff or consulting group involved in the development of information systems can request access to...

Am I missing something ?

Doesn't this SQL do the job ?

select *

, convert(varchar,convert(datetime,Date_Lst_Iss),103)

from dbo.Part_Mast

where Part_Num LIKE '258095GB%'

order by Part_Num

The physical attributes for tempdb are stored in master.dbo.sysaltfiles.

At startup, tempdb is created from model and then the physical attributes are applied such as changing the recovery mode to simple,...

Were you aware that when you change a DTS package, the prior versions are still retained ?

Under some circumstances ( that I have yet to determine), an older version...

Note that with a 24 hour clock, to determine if a specific time is with a range that spans midnight, such as 9:00 PM to 6:00 AM, two checks are...