Ken,

I am not 100% positive on this because I haven't used the sp_help_revlogins procedure myself, but I think what that does is script the server logins that exist in the...

Hi,

You might also want to take a look in Books Online for the system stored procedure sp_change_users_login. I think what may have happened is that the database user id...

Ramesh,

Yes, the DTC (Distributed Transaction Coordinator) service needs to be running for transactions within DTS to work.  On your SQL server box, go to the Windows Control Panel and double...

Ramesh,

In addition to what Antares mentioned, for each DDQ step which you want to roll back the whole transaction if it fails...

1.  Right click the DDQ step and choose Workflow...

Hello Patrick,

Please forgive my ignorance, but can you explain what a covered index is?

Thanks,

Julie

The enhancement we really need is the ability to email notifications for job failures without requiring SQL Mail or that a MAPI client be installed.

We have a SQL...

Steve, my WHERE clause would be even simpler, if you just want to see all the notes posted the same day you are running your query:

WHERE m.entrydate BETWEEN

CONVERT(datetime, CONVERT(char,...