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 |
|
fm88
Starting Member
18 Posts |
 Posted - 2008-07-28 : 08:03:33
|
| Hi guys,i have a small problem..im using visual studio 2005 and want to pass a filename as a parameter to a stored procedure where i, doing backup to the database..Can anyone tell how to write the stored procedure to do backup and pass the filename as a parameter??(assume to save the backup in a fixed directory..C:\..for example..)thanks |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-07-28 : 08:34:52
|
| Have a look at BACKUP statement in booksonline and use it with dynamic sqlhttp://doc.ddart.net/mssql/sql70/ba-bz.htm |
 |
|
|
|
|
|
passing filename as parameter