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 |
|
Les.61
Starting Member
49 Posts |
 Posted - 2010-01-27 : 20:07:07
|
| Is there a way to run a snapshot on all reports at a particular time without going to each report manually? The time is a variable. The reason I ask is when we have processing difficulties we need to redo the snapshot after the problem has been fixed. |
|
|
yosiasz
Master Smack Fu Yak Hacker
1635 Posts |
Posted - 2010-01-28 : 17:05:15
|
| I would try running an SSIS package that does that for you. You might need some .net code in there that does the snapshot for you and save it somewhere. better yet fix the underlying problem with why you have processing difficulties, can you explain that a bit more? why create another thing that might cause difficulties<><><><><><><><><><><><><><><><><><><><><><><><><>If you don't have the passion to help people, you have no passion |
 |
|
|
|
|
|
Snapshot All