I have yet to install SQL Server 2008, because I have been waiting for the official DVD's to be received by my IT department. I see no reason why this...

It sounds like the server value from the table SSIS_ServerList is not being mapped properly to the variable SQL_RS. Check the container Populate ADO Variable. Copy the SQL Statement and...

Sorry for answering your question with more questions.

What is the version and edition SQL server being used on the server returning the errors and the one running the package? In...

That looks like the SQL for "Update Data Used Size", but somehow many of the variables have been changed to "?". You might try downloading the package again.

Here is...

You can try manually running each step in the "Collect Database Info" container on the server you are having troubles with. You might get an error message that will identify...

Thanks for posting solutions to the problems you experienced with the package.

Size is the size of the Database file.

Space Used is how much space in the database file that is actual used.

MaxSize is the maximum size a file can...

Here are somethings to check

Variables:

1) Check variable names and make sure they use the same case. Their scope is your package name SQL_Overview_Package.

2) Set the default value of the variable...

You might want to look at the discussions for SQL Overview Part I for additional ideas on how to fix the MultiServer issue.

The article provides details on how to...

I was able to run the SQL you posted without problem on SQL Server 2005 Standard 9.0.3159 32 bit.

I did get that error while editing the job step and...

Your approach for combining the output from a stored procedure and a DBCC Command is very helpful.

Thanks for your article.

Here are some things to check:

1) Confirm the skip indicator in the table SSIS_ServerList is not set for any of the servers.

2) Check for any connection errors in SSIS_Errors.

3) Make...

Nice script but it is limited in what it reports.

1) Does not work in SQL Server 2000 because sp_help_jobschedule returns less columns in 2000

2) Does not support multiple Job schedules...

Try using

SELECT name

FROM master.dbo.sysdatabases

WHERE status&512 = 0

and status&32 = 0

Any databases that...

What is the error you are getting?

What @@VERSION of SQL Server 2005 are you running?

The version of SQL Server I am using is Microsoft SQL Server 2005 - 9.00.3239.00 (X64)...