Please dont double-post.

reply here: http://www.sqlservercentral.com/Forums/Topic1177646-150-1.aspx

A few suggestions:

http://social.msdn.microsoft.com/Forums/en-US/sqldisasterrecovery/thread/422c9841-6eb7-42ca-ab5d-50db52bbaa7a/

=iif(Fields!dataset.column.value = "condition", "Green", "Red")

first - focus on the column that will define the result

second - if true colour

third - if false colour

you can have multiple FALSE conditions:

=iif(Fields!dataset.column.value = "condition",...

I fully agree. We have tested on some systems with different configurations, disk speeds etc...and found in some cases the multiple NDF's actually slowed down the processing of some tasks.

Active.

was this a question/dairy entry/ statement? i dont see the question realy.

anyway, why add all the users as SQL Accounts? they are not linked to AD users.

Rather create an AD...

its not a compatibility issue, only access..

when logged in as administrator, grant the other account sufficient rights.

Duncan Pryde (4/13/2011)

Try this:

SET DATEFORMAT ydm

GO

SELECT CAST('2011-04-28' AS DATETIME)

or this:

SET LANGUAGE...

All 4 options work? one of those questions again...pick 2 out of 4 correct answers...a quessing game again.

this might help...

http://social.msdn.microsoft.com/Forums/en-US/transactsql/thread/1aa3b0df-8d9e-489d-90f2-d441bb241b8e/

you can try:

SELECT [column_names_here_instead_of *] FROM sports_program

where tf_org_air_date between ((dateadd(second,[20110304],'1 Jan 1970 02:00'))

AND

((dateadd(second,[20110306],'1 Jan 1970 02:00'))

AND

tf_genre_desc138 like '%basketball%'

and tf_genre_desc137='Sports Event'

order by tf_reduced_titlec

might need some tweaking on the...

we only exclude mdf, ndf and ldf....but thats only us....

Brent who? 😛

what are you future predictions based on?

Go to your Reporting Server Configuration (Start, Programs, MS SQL Server, Configuration Tools) connect to the production instance, and verify your Report Manager URL is showing as Production and not...