I believe you have already highlighted the issue - the value is reverting back to its "default" value. 🙂

If you check the parameters on the sub report (and parent report)...

Try this:

/*First off - lets disable*/

IF EXISTS ( SELECT

*

FROM

sys.fulltext_indexes fti

WHERE

fti.object_id = OBJECT_ID(N'[dbo].[InsertYourObjectNameHere]') )

ALTER FULLTEXT INDEX ON [dbo].[InsertYourObjectNameHere] DISABLE

GO

/*Then lets drop the index*/

IF EXISTS ( SELECT

*

FROM

sys.fulltext_indexes fti

WHERE

fti.object_id = OBJECT_ID(N'[dbo].[InsertYourObjectNameHere]') )...

Awesome script, I had most of these in separate scripts and now have a combined solution - thanks! 🙂

I did get one error, and fixed it by with this:

IF OBJECT_ID('tempdb..#tempdates')...

Rao.V (4/10/2012)

---

Hi all,

I am using idea of script you mentioned to verify the backup status of backup files location in different location. Same like RESTORE VERIFYONLY.

The 'C:\Temp\Paths.txt' is having backup...

Eric M Russell (5/7/2012)

---

This is a good script.

One suggested addition would be a 'schemaname' column. When I'm unit testing in Development, I often times have a different version of...

gsc_dba (10/26/2012)

---

I think you can use the JOIN function in this situation

= "SELECT * FROM " & JOIN(Parameters!DatabasesOnServer.Value) & ".sys.tables

Actually, you need a while loop which takes the parameter selection(s)...

I think you can use the JOIN function in this situation

= "SELECT * FROM " & JOIN(Parameters!DatabasesOnServer.Value) & ".sys.tables

Actually, you need a while loop which takes the parameter selection(s) and...

Nice script 🙂

Just a heads up - found a missing QUOTENAME here: (around @DBName)

(only applies if you have underscores and/or hyphens and/or dashes in your database names) 😉

--Get rid of...

http://dba.stackexchange.com/questions/4430/using-dta-vs-evaluating-dmvs

Instead of using 60 (integer) try using DateAdd(DateInterval.Day,-60,Now())

I also got an error because the int...

The part you missed is the false part of when the date diff is not <60

= iif(DateDiff("d",fields!STRTDATE.Value,today()) < 60, DateDiff("d",fields!STRTDATE.Value, today()), "Date not less than 60")

http://msdn.microsoft.com/en-us/library/dd239381%28v=sql.105%29.aspx

Shared data sources are useful when you have data sources that you use often. It is recommended that you use shared data sources as much as possible. They...

buddy__a (6/12/2012)

---

What I need to do is to create a custom interface that allows end users to enter reporting filtering criteria (as defined in the report) then execute and display...

SQL Tab Magic from Red Gate remembers the connection and database name...:-D

http://www.red-gate.com/products/sql-development/sql-prompt/entrypage/sqltabmagic?utm_source=google&utm_medium=cpc&utm_content=unmet_need&utm_campaign=sqltabmagic&gclid=CNfFxpXqyrACFcUmtAodaC8OVg

Yes it will 🙂