Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
anandu_76
Starting Member
1 Post |
 Posted - 2008-10-11 : 07:42:16
|
| Hi,hi,Northwind Backup Plan4_200810111149.txt - this for generating report file name whenever completing database backup. so every day this file has been created with date and time.This report file i want include in email alert dynamically, so how to set the command in @messagefile at body of the content.right now i am using static path like @messagefile = N'c:\dbbackup\Northwind Backup Plan4_200810111149.txt 'how to set dynamic path file in current text file above statement? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-11 : 12:02:17
|
| get name onto a variable.use dynamic sql and append variable value to @messagefile to take the value |
 |
|
|
|
|
|
How set dynamic file path in sql 2000?