Yes.  The servers that do not show the remote registrations do have SP3a.  Based on the Microsoft article that I mentioned above, this is apparently a known problem, MS just...

Now I got it to work.  The problem had nothing to do with an open file.  In the @attachments parm you have to refer to the share in UNC format...

Thanks for the response.  I'm trying to test this.  I created the share on the other machine and gave permissions on it to the service acct that's running SQL.  Then on...

Yes, I'm sure the reported success was not for the previous night.

I guess the 'dos' command explanation is what happened.  The DTS package is executed by DTSRUN from xp_cmdshell, but...

To keep from executing the grants against all the individual tables, point to your database in Query Analyzer and run this:

SELECT

'GRANT SELECT,INSERT,UPDATE,DELETE ON ' + NAME + ' TO xxxxxx;'

FROM...

My environment is like Robert Stewart's.  At the large bank where I'm a DBA we call DAs Data Analysts and they enforce naming standards for in-house developed databases.  They also...

I beg to differ with the above.  The rules of formal database design state that a "natural" meaningful key should be used if at all possible.  A numeric identity key...

I have also used DTSRUNUI to generate the command-line syntax to execute the DTS package, then put that syntax in a stored procedure.

Then you can just execute the stored procedure in...

The optimizer will almost surely not use the last_name, first_name index, if you query on first_name only.  If you will frequently query on first_name only, you should create another index where...

My rules of thumb are

- make sure your primary key, unique indexes are in place.  That of course is automatic.

- create indexes for all foreign key columns.

- have the developers give...

Also these

http://support.microsoft.com/default.aspx?scid=kb;en-us;315886

http://support.microsoft.com/default.aspx?scid=kb;EN-US;311231

This is a quick query to check for disabled job, but it won't show who did the disabling.

SELECT name

FROM msdb.dbo.sysjobs

WHERE enabled =...

The crucial things are that the sql server service and the sql agent service be running under a domain service account.  Your SQL Server must have connectivity to your Exchange...

I'd like to try that UDL file suggestion.  I created a text file named test.udl.  When I double click it, I get "File cannot be opened.  Ensure it is a...