Hi Dave,

One way to accomplish this would be to read the errorlogs to get the last date. This will be the LogDate and the NetBIOS name of the node in...

the last post was a very succinct and accurate analysis of what a lot of DBAs face. I know I came into a SQL infrastructure left by the previous DBA....

To be honest, I have only watched a few of the JumpstartTV videos and some of the earlier ones were not substantive enough even knowing these were compact tutorials. However,...

This script reminds me of a song and goes a little something like this:

"I've been through the desert on a horse named Dewayne"

What's up, Ken.

Rodney

Hello dguillory,

Glad you like the solution. I cover SQL authentication for DMZ and such environments in the February issue of SQL Server Magazine. Essentially, it is just creating a new...

Well now. This is great stuff.

My goal certainly was to allow readers of my original article to modify, extend, enhance and utilize the SSIS package I had put together...

It could be the local server connection in the DBA_Rep data source. You might need to change it to the server where the DBA_Rep database resides if it is not...

Try downloading the latest RDLs. There was an issue.

Rodney

I have asked to place new RDLs in the code download.

The issue everyone is having with the "TEST" datasource is the default parameter value for the ServerName parameter.

To address without...

Thanks for all of your comments so far.

The "test" data source is not a shared data source. When developing the reports, I used a static datasource for the...