I tried login as yy into my application database and execute the checkin u guys suggested.

I check using IS_SRVROLEMEMBER against sysadmin,dbcreator,bulkadmin,diskadmin,processadmin, serveradmin,setupadmin,securityadmin and yy belongs to none of...

Thank q for ur reply.

As u said SQL2k5 wouldn't explicitly indicate what [Builtin\Administrator] permission has, how do i check if my login belongs to which group?

the example " Create Login yy...

i agreed with addict, to sent email for only new entries, use trigger.

if u wan to check the record date before sending email, why don u just put a IF...

Thank q for ur reply. i'm not quite understand what u said...

let me explain the situation more: the sql server is reside in the server, and i'm using my local...

the storedprocedure should be as simple as passing paremeter into the system storedprocedure:

EXEC msdb.dbo.sp_send_dbmail

 @recipients = @emailto,

 @copy_recipients = @emailcc,

 @blind_copy_recipients = @emailbcc,

 @subject = @emailsubject,

 @body = @emailbody,

 @file_attachments = @emailattach,

 @body_format = 'HTML'

and execute...

which sql server u r using ? i'm not sure about sql2000, but for sql2005,

it is quite simple, as u can write trigger to your table and each time a...