See if sp_readerrorlog 0,1,'mirror', 'failover' (or some variation thereof) works for you.

For more in depth monitoring of mirroring events you may need to look into capturing WMI events via SQL...

Hi Matt,

You could try running it on a schedule if it's required on a known date each month.

This should take the rendering part out of the execution time completely.

...

Does it work if you import into a datetime2 type? Wondering if it's having a issue with the nanoseconds.

Edit: Scrap that, you need to use DT_DATE type, DT_DBDATE is day,...

Or .\SQLEXPRESS 😉

Hi Matt,

Is the report run on demand or on a schedule?

Easiest way would be to strip out any & all formatting, just return the information in a basic table.

Or see...

You will see that error if you parse the code in SSMS, running it should work though. Odd.

Just checking :-D, but has SQL Server Express been installed at all? You only mention installing Management Studio Express.

I believe in 2008, there's no upgrade option, the RS Configuration wizards auto-detects the RS db version & upgrades it as appropriate.

Worked for me going 2000 -> 2008.

Odd that 2005...

Sort of relatedly, but when I first moved to SSMS from Query Analyser/Enterprise manager, took me months to stop hitting the debug button on the toolbar, rather than Execute 😀

And...

Only real downside is the additional CPU load required to compress/uncompress (during restore) the backups.

Especially for the additional load backups put on a system under load.

I think you're limited on...

If you're using SSRS, why use a linked server at all? Just create datasources pointed at the production server.

Licensing, I'm not sure on. If the reports are only accessed by...

Yep, I'd go for merging the dataflows too 🙂

I do, it's "Con tent" right? :hehe:

Actually I've found the thread pretty entertaining 😀

And Wikipedia's "block" appears to be the equivalent of a...

I'm not sure what's going on then. I'd expect SSRS to pass the parameter to the proc as one string, as you are seeing in profiler.

What's going wrong inside the...