Databasename Variable

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Gabe Matteson (gmatteson_at_inquery.biz.nospam)
Date: 02/24/05 

Date: Thu, 24 Feb 2005 13:47:03 -0500

declare @rc int
exec @rc = master.dbo.xp_smtp_sendmail
 @FROM = N'SRVDB1@mydomain.com',
 @TO = N'gmatteson@mydomain',
 @priority = N'HIGH',
 @subject = N'Process Success',
 @message = N'Database Backup Succeeded.', - Rather than putting Database
Backup Succeeded, I would like to put "@databasename Backup Succeeded".
 @server = N'mail.mydomain.com',
 @attachment = N'F:\TEST.txt'
select RC = @rc
GO

Anyone know how to do this, this is my first stored procedure and I really
have no idea how the syntax works! thanks.

Relevant Pages

  • RE: How do I restore from mdf and ldf files?
    ... Tasks -> Backup Database ... Tasks -> Restore Database ... Windows 2003 Server with Latest Service Pack ... Pre-requisites for Sharepoint Backup and Restore: ...
    (microsoft.public.sharepoint.portalserver)
  • Re: RMAN restore of full backup fails completely
    ... You are not using a catalog database. ... You might have autobackup controlfile on, ... Your autobackup has been made *prior* to the backup! ... plus archivelog', when i try a restore on the other server however, the ...
    (comp.databases.oracle.server)
  • Backup and Restore Files
    ... What is the best way to backup and restore a runtime database file? ... pszDisplayName As String ...
    (microsoft.public.access.gettingstarted)
  • Re: NTBACKUP error
    ... Are you putting the oracle tablespaces in backup mode before doing the ... start of the backup which they will be doing if the database is ... Shutting down archive processes ... Undo Segment 1 Onlined ...
    (comp.databases.oracle.server)
  • Re: NTBACKUP error
    ... Are you putting the oracle tablespaces in backup mode before doing the ... start of the backup which they will be doing if the database is ... Shutting down archive processes ... Undo Segment 1 Onlined ...
    (comp.databases.oracle.server)