It seems to me that you are using the wrong hammer. can you set up a SSIS job to dump the list nightly to a share somewhere? then...

try something like this

restore database def from disk = 'BAK file name'

with move 'DEF_Data' to 'DEF_New_data.MDF',

move 'DEF_Log' to 'DEF_New_log.ldf'

'BAK file name' = the fully qualified...

take a look at fn_listextendedproperty in BOL. this will enable you to query the extended properties, from there you can come up with some kind of report.

I am seeing this trying to restore a sql2000 master databsae to a sql 2005 database with another name for the master database. the old version doesn't restore on...

write a batch file one osql per server...

osql -S"server1" -Uusername-Ppassword -dmsdb -ijob_stop.sql -olog.txt

type log.txt>>finallog.txt"

osql -S"server2" -Uusername-Ppassword -dmsdb -ijob_stop.sql -olog.txt

type log.txt>>finallog.txt"

osql -S"server3" -Uusername-Ppassword -dmsdb -ijob_stop.sql -olog.txt

type log.txt>>finallog.txt"

osql -S"server4"...

Is the path on the server the same as the path on your workstation? The exec xp_cmdshell is running on the server, not your workstation.

We did something like this at a previous employer. We ended up monitoring so many servers and so many processes we had a consolidated display with stoplights. Green...

Nice! the trick is figuring out how to talk to sharepoint. I've filed away your code for future reference. I also liked the reference to the C#...

I don't know if this is supported by SSIS but FTP has a "Quote" command that lets you run a command on the ftp server. these are called Site...

Here's a bunch of connection strings depending on which provider and what options you want to use. I usually go here first to snag a connection string for a...

you may need to tell the system which data source you want to use. in my C# i'm calling the SetReportDataSources method to hook the report to the datasource....

i don't know of any way to get the name in code from the subreport. can you pass the parent report name in as a parameter to the subreport?

Nope, you definitely don't have to mess with the firewall. I have set this up on many dev workstations and never touched it.

The problem you ran in to was...

Reporting services in 2000 won't let you use a dynamic image, the image can come from the database but not a file. haven't investigated 2005 yet.

If you batch file is always going to be running your batch file for "Today"  you can use the environment variable %Date% to plug in todays date on the appropriate batch...