Great article Aaron!

Now that I have it installed and functional. (I've been procrastinating for a long time) I would really like to see more on what people are...

Error 823

I/O error <error> detected during <operation> at offset <offset> in file '<file>

Proactively, a DBA can set an alert within the SQL Agent for 024 - Fatal Error: Hardware...

I am curious why the user databases needed to be restored since a version of the Master, (and presumably msdb & tempdb), were restored? If this was my system,...

I don't understand the CAST... I'll have to read up on that. But the new code works.

I do get three emails for every auth of that account now...

Is there a way to test the trigger? The last_login_date value for user bbsupport gets updated when the user logs in via the application. I've logged in as...

Your modifications do allow a trigger create. But I can't prove it works. I can login as that user, the last_login_date value does change. But I'm not...

Like this???

IF @last_login_date from inserted where (user_id = 'bbsupport');

The desired result is from any change to the last login date for that user, I want an email. Basically I'll know any time that user account logs in....

Thank you for your help!

Now I'm getting two messages/emails for every data change that meets the criteria. Dunno why. I can live with that for now though.

The logic wasn't...

Use "WSS_ MSWSS-1_EESP_CONTENT"

select 'EESP\' + FullUrl from dbo.webs

Use "WSS_ MSWSS-1_VPBFA_CONTENT"

select 'VPBFA\' + FullUrl from dbo.webs

Use "WSS_MSWSS-1_BOT_Content"

select 'BOT\' + FullUrl from dbo.webs

Where as, the return is: (extremely condensed)

EESP\directory

--------------

VPBFA\sites/HR/CrossFunctional/Summit 2010

--------------

BOT\collab

--------------

All in...

So, you're saying to create a temporary table, but in what DB? Then query the individual DB/Tables, send the result set to the temporary table / DB, then query...

Got with our DBA and came up with this:

select email, user_id, firstname, lastname, student_id, from users where user_id in

(SELECT a.* FROM OPENROWSET( BULK 'F:\NAMES.txt', FORMATFILE = 'F:\NAMES.fmt') as a)

The...