ohhh... ok thanks.. i guess my backup script will be stuck in the mssql format (dbname_db_YYYYDDMMHHMM.BAK) 🙂

Jeff Moden (5/4/2008)

---

Gosh, I sure hope so, Lester. Thank you for the confidence. I look at some of the articles I've written and say to myself, "Everyone probably...

Jeff Moden (5/3/2008)

---

Nicely done, Matt! I guess my only exception to what you said is that I use it to "replace loops" all the time. Although.... I'll agree...

Sorry to say angelin as of now the script only restores 1 mdf and 1 ldf if i have time i will try to modify the script to include multiple...

If the format of your backup file is the same with the MSSQL 2000 format e.g. dbName_db_YYYYMMDDHHMM.BAK maybe this will help

http://www.sqlservercentral.com/scripts/Backup+%2f+Restore/31995/

If network is not a problem it can be done but sometimes backing up direclty to another server/pc may result to a corrupt backup file. So what you can do...

YOu can use the openrowset property to export data from sql to excel (key in OPENROWSET in BOL) as for the format you can use a cursor (not recommended) because...

In Outlook you can create a distribution list somewhat like group mail where in you will create a group then populate it with email addresses so that you will only...

You can use sql "OPENROWSET" that is what im using and i can easily generate an excel file (report) with dynamic name on it example lester_yyyymmdd.xls try reading this good...

if what you are talking is if you can bcp a table storing in a text file and save to another location in the network, yes it can be done...

Almost forgot some points to consider

1. Where will the created report be placed??

2. Does it have (the place where the report will be dump) a sql server install in...

Example :

exec master..xp_cmdshell 'dir /od C:\*.xls'

This will search all file with xls(excel) extension. you can insert the output to a table

example :

insert into tablw_name

exec master..xp_cmdshell 'dir /od C:\*.xls'

From here you...

If the filename is static and only the date is changing example : Lester_20080327.xls then you cna use xp_cmdshell to locate the filename in a specified location then use xp_sendmail...

Are you sure the numbers of columns in the excel file is equal to the number of columns in your '*'? select * from table1? please check...

The best way (for now since you will buy a third party backup application) is to script your backup procedure. Just exclude those databases that do not need backups. In...