Permanent tables is not a option.I think SSIS works with temp table with some settings but no sure how...

Cant create permanent DB objects.In SSIS I will be running the above query across many servers to gather the information as per the query details.

Yes it works perfectly in management studio.

Yes,that will be run against multiple servers as part of an SSIS package.

Thanks

SET NOCOUNT ON

fixed the issue.

Thanks

By evaluating 2 columns(Blocked and Current_Overdue) and then color coding 2nd column.

Can I have somethinglike this to color code a column (Current_Overdue)

=IIF(Fields!Blocked.Value=1 And Fields!Current_Overdue.Value = 0, "Red",...

I am aware of that..

but how do I write this condition in SSRS.

If cell1=value1 and cell2=value2 then for cell2 color=red

But how do I make the 2 drop down list independednt of each other.As of now I have select atleast 1 option in both the drop down lists to get...

If my result set has a million rows wouldn't a case statement be very slow than a where clause.

Is there a better way of doing this.My environment is sqlserver 2008.

And...

This is the script.It extracts all servers within a domain.

This code does not remove the empty spaces after each server name.I am unable to import it into a SQL table using an SSIS package.

Thanks

Thanks but...

Why is the existing one not working?

I cannot create a Stored proc across 100's of servers.

I will be running this code across servers from the SSIS package.

I have 2 variables.

One variable(ADO object) to list of server names in the forloop container and other variable to loop through the ADO object.

I see application users in the application but I do not see them in the database as users ?

These app users can connect to the database using their logins.But I...