If you don't need to return anything to the client use xp_logevent instead!

RAISERROR('FYI: This message should be sent without delay', 10, 1) WITH NOWAIT,LOG

This Thread has ALL you need

Good Luck!

the Log RAISEERROR uses are the Windows Application Log and the SQL Server Error Log!!!!

Will,

The order in the RELATIONAL Model is not guarantee at the Table level that is why you should not relay on clustered indexes and use the ORDER BY clause when...

SQL is a DECLARATIVE language. you are supposed to tell the engine WHAT you need not HOW to get it!

Indexes  help the engine improve/determine the execution plan (based on cost!)

What...

Most People I know Backup to Disk First! then to tape.

And yes, you can use windows scheduler to grab a folder (THE BACKUP Folder) periodically.

If you were refering to the Annonced servers you can run :

isql -L

Beware ! Announcing can be turn OFF!

It hasn't been explicitly said but just in case:

 If your FULL Backup Happened AFTER the deletion and you don't have any previous backups the data you are looking for is...

I'll rather enforce that with SECURITY ROLES!

My $0.02

?

BTW In fiber mode you will have to say Godd bye to DTS

For the purpose of comparison you DON'T NEED anything to grab the mdf files !!!! 

'COMMUNE D''IMPOSITION'

1. What if the USER  KILL you App. Stop the service and grabs the FILE

2. Performance and XML is an oximoron!!!