I'm definitely trying to discourage it, but that will take time, especially since I've only been with this company for 9 months.  At my previous employer the developers went to...

Here is an update.  I found that if I do not specify a backup device or if I create a new backup device with a different name, backupmediafamily contains the...

Thanks Luke.  I'll start researching the MST approach.

Dave

Thanks all.  For some of our servers I've created scripts to restore the databases, but I still have several scripts to create.  I'll also be creating ISS files for installing...

That should do the trick.  Thanks

I was unaware you could specify an OUTPUT parameter with sp_executesql and found nothing in BOL tying the two together.  I checked again and only found documentation regarding the use...

I'm not sure why you think it's permissions.  When I run the following statement it works.

EXEC @status = SQL6.master.dbo.xp_readmail @peek='true', @suppress_attach='true', @subject = @msgsubject OUTPUT

The error occurs while...

For whatever reason I cannot see your reply between the comments

"...of 'Component Services' on the linked server." and "Also have you checked/tried..." so I don't know what changes you...

Sorry for any confusion.  When I say my second trace includes the corresponding "starting" events, that means in addition to the "completed" events, not in place of the "completed" events. ...

Three of our four domain controllers are global catalogs.  The DC that was rebooted yesterday is one of the three with a global catalog.  Please help me understand this a...

We have four domain controllers and Exchange is not a DC.  xp_stopmail / xp_startmail fails when this problem occurs.  The only solution 9 out of 10 times is to restart...

(1) The IP addresses are static. 

(2) After midnight all of our servers execute a schedule job to send a test email to the DBA.  This was setup to help...

Thanks for the feedback.  Centralizing DTS package connection property data in one location such as an INI file is something I've seen recommended by other people.  This would take some time...

Unfortunately change control is something that needs to be improved upon at this organization.  I've only been here for a few months and the lack of change control became apparent...

Brian,

In regards to saving the DTS packages to files, is there a way to automate this process to ensure every time a package is created or modified the package is...