Wayne, thanks a lot for your answer. I hope I've got your idea but just to clarify: if in Index column for locked tblB I see tblA that means that tblA...

May be I am wrong but the difference is that (from BOL) "AFTER triggers are never executed if a constraint violation occurs" and FOR trigger doesn't care. But, probably, from...

Thanks a lot.

I am not sure regarding SAN- will check tomorrow. Another server or windows process- what I need to pay attention for first? Thanks

Thanks. But, probably, sp_who will return same info as ProcessInfo from EM and as I already mentioned, sometimes almost nothing is running but ADQL is pretty big. Profiler is runnibg...

Agree with RGR'us- already had issues using system table trying to count row number. Thanks

Thanks, David. I'll check in a while

Sorry, for long post

CREATE PROCEDURE dbo.getmedian

(

 @tablename varchar(50)

)

 AS

DECLARE @n int, @number varchar(10)

DECLARE @sql nvarchar(255)

SET @sql='SELECT COUNT(*)  AS ' +...

Sorry, if I wasn't clear in my first post. In our forum I found script (from Brian Kelley) how to calculate median for column myId (int) in table myTable (let...

Remi, I didn't get you. Certainly, I've done this a lot of times working with web applications. But for Report project- where do I need to put this code? Thanks 

Thanks a lot, Phill

Actually, I would like Report Service (RS) will check input parameter (-s) constraints (limitations) before executing report. But I am not sure it's possible. Frankly, it's seems a bit strange...

I asked- silence. Thanks

Phill, thanks- it's cool, but it's not what I am looking for. I don want to create list with available values for parameter but instead to use some criteria to limit it,...

Phill, sorry, but I didn't get you. Certainly I can create dataset to provide list of available values (and I doing a lot this way).  But how can I create...