You could still convert to a string, use format code 112 instead of 101. It will give your date in yyyymmdd format, and will sort as you expect.

This will...

It would help if you could provide some test data, the DDL for the table(s), and the expected results. Just looking at the code, its hare to tell what...

Per processor licensing is also valid if you have a large internal user community that is accessing your database. If you purchased SQL Server 2000 or SQL Server 2005...

You are confusing the the names in the call below with the names of your parameters in the stored procedure definition. they are not the same.

exec mailsecurity @dbname,@emp,NULL,Admin output

exec...

Procedure mailsecurity is expecting 4 parameters, inthe following order:

@dbname, @name, @emp, @admin-2 (output)

Your call in PRC_GET_EMAIL_ADDRESS is only sending 3 parameters mapped to the expected parameters as follows:

@name to @dbname,...

In your second call with only two parameters, the second variable is mapped to the second variable in the stored procedure. If you are going to execute the stored...

I'm at a loss right now. I was hoping you were running x64 since, as far as I know, MS hasn't released 64 bit drivers for Access as of...

What version of SQL 2005 (x32 or x64)?

Simple recovery model, the transaction log is truncated when the data is checkpointed. In full recovery model, the transaction log is only truncated when a transaction log backup is...

It "Depends". What type of backup and what recovery model is the database using?

A full backup and differential backup do not truncate the transaction log. Enough of the...

I'm glad to have been of assistance, even though all I did was point you to Jeff's article. Be sure to post a thank you to Jeff as well...

Here is what would really help, provide us with the DDL for the tables, some sample data for the tables, and your expected results based on the sample data.

Jeff Moden...

I took your code, made a couple of changes for my environment, and was able to send myself an email. If you would like, I can make another small...

I was comparing your call to sp_send_dbmail to one I have in a scheduled job and I see one thing missing from yours, this:

@execute_query_database = 'mydb',

Add this to your call...

I don't know, but I got the answer (per QoD) correct because it makes sense to me. There are two types of DML triggers: AFTER and INSTEAD OF. ...