For the record, I get the same sort of results as Gus.

This would be a really nice thing to be able to find - help my automated inventory efforts 😉

Has it worked in the past?

Has anything changed?

Can you setup logging on the package and show us the error as it shows in the package log? (Not from SQL...

There a few methods to do that. One of which is to associate that user with the second database.

Another option includes the use of certificates.

Create a script and run that from an ssis package that loops through all of your servers and executes the script against each one.

options

1) USE [master]

GO

ALTER LOGIN [sa] WITH DEFAULT_DATABASE=[master],...

Do as Bru suggested. Use a named instance and you should be good to go with both instances.

I like my thresholds a little higher. 25%

Interesting Article. Thanks

Here is a nice resource on the topic

http://www.brentozar.com/archive/2006/12/dba-101-using-perfmon-for-sql-performance-tuning/

I started a Thread to get an idea of who might be in my area for SQL Magazine Connections.

http://www.sqlservercentral.com/Forums/Topic865022-61-1.aspx

https://www.cia.gov/library/publications/download/

Is the following an accurate statement?

DateMileagev.VehicleName AS UnitNumberv.VehicleColor AS MedicNumberMileage

'1/1/2010''Henderson' (name not Number) 'Red'Color but not Number ...

GSquared (2/15/2010)

---

You should be able to view the query in the report properties.

If not, run a trace and open up the report. If the trace includes the text for...

cents

Chad Crawford (2/15/2010)

---

Ahhh.... that might explain what looked like a contradiction. Maybe it is the GUI that accepts blank/zero but the XML underneath is always zero. That...

sense