You need ALTER TRACE permissions at the server level. Just be aware that this IS a SERVER level permission so any user you grant this to can trace ANY...

You could possibly use TOP 1 with an order by date desc.

Select Top 1

Column List

From

Table...

In the Data Conversion Task go into "Configure Error Output" and set the desired error types to "Redirect Row". Then you will have a RED (failure) arrow in addition...

Use the RTRIM function on the FIRSTNAME. LIke this

Select RTRIM(FirstName) + ' ' + LastName

Answering your second question first, here are a couple of articles on point in time restores by people I respect:

http://www.sqlservercentral.com/articles/Backup+and+Recovery/restoringtoapointintime/1905/

http://www.sqlservercentral.com/articles/Backup/recoverytoapointintime/1914/

Now for the backup scenario you list. I'd add at...

I'll start by answering your last question first. You can do it all in one trigger if you want. The second part is a a little more complex...

JJ, Timothy, and Barry,

Thanks for the kind words. I just hope the article can be helpful especially to beginners.

There are pluses and minuses to both. I usually append to one file. I think it makes restores easier as you just need to change the file number...

Because you are creating a new file each time you do not need init/noinit. If you wanted to create one log backup file per day you would need somemore...

Yes.

Based on how I understand the Linked Server Security section in BOL, you cannot MAP to a different Domain Login. You would need to either grant Domain\Acct_A access to...

rbarryyoung (10/13/2008)

---

Steve:

You're right that SQL Mail (xp_send_mail) is a No-No from a trigger, however Database Mail (db_send_mail) is safe from a trigger because it is built around SQL Service...

You may only be concerned with a single row now, but...

Something like this will work:

[font="Courier New"]DECLARE @datetime VARCHAR(20)

DECLARE @filename VARCHAR(100)

-- get the date in ANSI yyyymmddhhmmss

SET @datetime = REPLACE(CONVERT(VARCHAR(10), GETDATE(), 102), '.', '') +

               REPLACE(CONVERT(VARCHAR(10), GETDATE(), 108), ':', '')

SET...

Just a guess because I am not an Access expert by any means, but I think because you have upsized CurrentDB will no longer work. You will need...