Adding more info to my question,

I like the email alert to be sent whenever an order crosses a threshold value. For example, the order is pending for 40 minutes, nothing will...

How can I get more help on "job", this is something new for me.

DECLARE @email VARCHAR(4000)

SET @email = ''

SELECT @email = RTRIM(@email) + RTRIM(email) + ';'

FROM Users

WHERE email <> '' AND DepCode = 'A'

execute sp_send_dbmail --

I am using after insert trigger, so definitely I am looking into Inserted table, not deleted table.  So far, I am getting the right data. I will see if any...

I have found out a way

select @customername = customername from instered

then use @customername to fomulate the mail body. It works fine.

How? Any select statement? I read in books online, "SELECT * from deleted" but when I include this line in my trigger, using @query parameter of database mail, it doesn't work 

Even though we have corporate level policies for windows authentication and variety of GPO are in place, SQL Server authentication will suit us.

We can implement some procedures to lock the...

I understand completely.

I was wondering, the SQL server has also the facility to create SQL Logins and the SQL server can authenticate the users and grant them permissions. Can...

Suggestion is very nice. no doubt about that. Simply you have given the complete solution.

But, the problem in windows authentication is that in our network one computer is logged...

I am using the following method to connect to SQL server & create table definition:

Dim db as dao.database, rs as dao.recordset, tbl as dao.tabledef

strcon="ODBC;Driver={SQL SERVER};SERVER=msrvr;Database;mydb;UID=me;pwd=;TrustedConnection=Yes"

and I am using mostly bound...

Anybody !!!!