Sergiy, The language for formulas in Reporting Services is VB.Net

Steve, Not sure where you're using the value, but why not do you calculation in SQL anyway, that reduces the work...

One other thing you can check/change. Is the server using TCP or Named Pipes? If its using Named Pipes, change it to TCP.

Probably should have started a new thread.

Increasing the max error count may help you if the Network hiccup is resolved before the data transfer.

Downsides ... the transfer does not start...

While you might not be confused, by using the sp_ prefix you are however slightly confusing SQL Server.

When SQL executes a stored procedure with the sp_ prefix it will look...

I had a file or two hanging around as well. Couldn't work out what the problem was. Then after a reboot to apply so Windows Updates they went away.

That is just was I was going to suggest. Those errors you were getting are usually seen when the collector is not installed. So if you added all the servers...

Have you installed the Performance Collector? It is a seperate download available from http://www.microsoft.com/downloads/details.aspx?FamilyID=64983af0-7902-427e-9b41-7c2e8fdcc140&DisplayLang=en

What do you do when you can't connect using the DAC ??

We had a problem on a clients server recently and the CPU was flatlining. We could tell from Task...

If you're using the new SQL Maintenance Plans utilising Integration Services tasks, then you should include the two clean-up tasks that are provided.

'Clean Up History' - removes rows from job...

I recognise quite a few of those example posts you provided

The script should give you an idea of what objects and properties you need to update. All you need to do is adapt the script to your needs.

I think my problem stems from the fact that the databases all reside on the same server. So in my case the database name is what changes.

You can setup the start and stop of the counter log via a Windows Scheduled Task.

Use the logman command line app. Type logman /? for the syntax.

I'll try to be a bit more helpful than Hans ...

I've been trying to do a similar exercise with SSIS, multiple databases on...

The DTS GUI is looking for an object that fits the DTS object model. The VB file has no information about the object model in it.

Modify the "Save" line in the...