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...

Can we do this without using script task ? Basically without coding ! Not good at coding.

I am not sure if I made my question clear.

I currently have built a SSRS report where only specific rows appear to people accessing the report based on their...

can you please explain