Hi, I have solved the problem.

Under the datasets properties tab "parameters" you can add expression.

In this case it looks like this:

=JOIN(Parameters!Objects.Value, "', '")

Attach the solution.

Best regards

/Semko

Hallo ozgur, I have created a trace on same way.

Best regards.

/Semko

Thanks a lot for yours help. I did not find any solution. I vill crate user trace.

Best Regards.

/Semko

Thanks Jack, your script will return 25 rows from AdventureWorks database.

Script I wrote returns 68 rows.

Why, I'm looking on all columns included in index and want to have...

Thanks for your replay Jack, the result I want is to return a list of all tables, which have FK and are missing an index on same columns as...

..thanks a lot..

/Semko

yes thanks a lot.

Best Regards.

/Semko

Thenks for help,

 I found script on:

http://education.sqlfarms.com/education/ShowPost.aspx?PostID=784

and

http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=505&lngWId=5

I'm working to get them going!

Best Regards.

/Semko

Hi, have you some script to script index and PK?

/Semko

Thanks, just to do it.

/Semko

Thanks,

but if I have lot of tables it will take time and you mean I must drop and recraete PK and index to do it?

/Semko

Thanks a lot for your help I will be back with info if I find something.

Best Regards.

/Semko

Thanks, but this is still a work around.

Do someone know if it is possible to change the amount of "default trace" files because I want to have more history back in report...

Thanks, but the trace I want is the one that I can see in the "Summery/Report/Schema changes history".

Last week a developer complained that one SP disapeared and I want to...

SQL SERVER 2005