I think experience on the resume and a lab test for hiring tends to weed out the chaff from the wheat. Case in point: the last time I was involved...

If you check "Show step details" and then look at what's in step 1, what does it say?

From the system that's not working, can you ping the SQL Server? If you can, start up the Client Configuration (clicnfg.exe) and check the Aliases tab. See if someone has...

See my post here:

Other thread

Yeah, it did start out in the QoD forum. But anyone can accidentally post in the wrong column so we've not said anything about it.

What is the error recorded for the job that executes the DTS package?

So you have a SQL Server and all but one machine can connect to it?

Okay, how does the application connect to the SQL Server? Does it use an existing ODBC...

I wonder what Antares' record is for 1 day. When he's not knee-deep in projects he's a prolific poster. Of course, he doesn't post just to increase his post account,...

Use a CASE statement. For instance:

SELECT
  value1 AS 'VALUE1',
  CASE
    WHEN VALUE1 = 0 THEN value2
    ELSE value2/value1
  END 'VALUE2',
 ...

BUILTIN\Administrators isn't needed, but before it is removed the SQL Server service account and the Cluster service account both need to be added and given sysadmin rights. More here:

SQL...

Jet can be used to make an OLEDB connection to both Excel and text files. Not a common thing, but it's part of the functionality of Jet.

We're only restarting servers monthly. And that's due to Windows security updates requiring reboots. Otherwise we've not had a need to restart Windows 2000/2003 servers running SQL Server.

When you say they login to your Windows system, how are they doing this? Are they mapping to a shared drive or something like that first? Do you have any...

Do you have any group policies that make changes to settings like "Log on as a service" or "Act as part of the operating system" or "Log on as a...

The only caution on sp_oacreate is it is an extended stored procedure and it carries the ramifications of such. Also, the sp_oa* stored procedures typically require sysadmin rights to execute....