I got it.

I did a forech loop container to loop through the files of the directory.

so selected for each file enumerator

selected the folder

and for the file name created an expression

filespec...

Yes I got it figured out. Actually After playing with it all day long I decided to let it sleep and oh surprise! the next day it was all back...

Thank you for your reply.

I have a few suspended requests, waiting on PAGEIOLATCH_SH.

the wait resource column reads something like 9:1:4505200.

My question, how do I know that 9:1:4505200 is

9 is the...

The problem was the temp table. I changed the stored proc to create a table instead, anf the everything worked fine.

Not sure wht reporting services do not work well with...

I included the name of the schema on the name.

when I click on refresh it brings a box with the stored procedure parameters, so it is reading the procedure,...

This script only sends to excel the results of the last test on the resut file.

My output file looks like this

K

Type,Threads,Depth,Block_Size,IOps,MBps,Avg_Latency(ms),Min_Latency(ms),Max_Latency(ms)

,,,,359,3,354,1,402

I am not sure why it is not...

Thank you so much for your advice! I have several databases, some of them with over 300 procedures, so runing them all will be difficult. I will look at the...

thank you so much!!

How about triggers. Looks like I would have to script the tablein order todo them as well?

Is there a way to just do the triggers?

What I am trayng to do is a report in reporting services, so can not use a cursor (as far as I understand)

my report needs to read server roles from...

Awesome. Thank you so much

Thank you so much!

Thank you for the clarification.

what I actually need is to write 1 query that will list what databases were selected under user Mapping when the login was created...

I know I...