I can't see your report, so I don't really know what's happening. Does this stored procedure produce the main report, or does it just supply the parameters for the...

You need to set @startdate, @enddate and @fp as OUTPUT parameters in your stored procedure, don't you?

John

Have you considered a table-valued parameter?

John

drosa 15759 (7/27/2016)

---

Hola amigo tengo 7 grupos contando el Primary y dentro de cada grupo tengo un archivo ndf, quiero eliminarlos porque actualmente tengo un entorno de produccion dentro de...

Quinn-793124 (7/27/2016)

---

Is there a way a way to figure out what license level I am at? Like express, standard or enterpriseso I get the same license...

tom.w.brannon (7/27/2016)

---

I expected the answer to be that there was an error because tbl did not exist. Since that wasn't an option, I did some experimenting around the open...

edwardwill (7/27/2016)

---

John Mitchell-245523 (7/27/2016)

---

Not sure whether you're...

Not sure whether you're saying you're surprised...

¿Cuántos archivos ndf tienes? ¿Por qué quieres eliminarlos?

How many ndf files do you have? Why do you want to drop them?

John

It's ready now!

John

You might want to take a look at this, in that case.

John

Where do the values from those variables come from? It looks to me as if you're inserting into activity_table one row at a time, which is very inefficient. ...

Glad it's working for you. Check out this page.

John

It's a SQL account. We can see that from the parameters for sp_addlinkedsrvlogin. What we still don't know is what message, if any, is appearing in the errorlog...

Jeff Moden (7/22/2016)

---

It's just easier for me to ensure that right after I bounce everyone out with a single user connection that I immediately shift back to something a bit...