If you read the lengthy thread... is 5 forms... but should be an ALL or nothing kind of thing!!! that's why one sp makes sense!

Did you have a look at my post ?

112 parameters you are still very far from 2100

Now compare that with all you would need to do client and server side if...

Thanks!  you are very kind

BTW Did you see my reply to your trigger question ?

as of last year Lumingent Entegra was $10,000.00 per server plus $2000.00 maintenance fee and all that was just software then you need to add your collection server and your...

You can create an Alert which is fired by the database Size counter and use current size as the limit!  and for TLog growth there is also a log grow counter!

Cheers!

True! just less typing

My pleasure!

>> ...

-- better reports, less overhead, meets legal requierments and all the other things this design flaw does not.   <<

Yes and you for got to metion a ton of $$$...

Cheers!

SELECT FH.family_history_conditionID

 , FH.family_members

 , FH.other_info

 , FHC.condition

FROM

 family_history FH

 RIGHT OUTER JOIN

 family_history_conditions FHC

 ON FH.family_history_conditionID=FHC.family_history_conditionID and FH.intakeID=26

SELECT CategoryID, count( distinct AddressID)

FROM Categories

GROUP BY CategoryID

 other reasons:

- they create an abstraction layer for the Client side

- They give you more flexibility in maintanace changes

- They are very efficient when called repaeatedly with different parameter values

-...

I just posted that After Bob mentioned that pictures numbers were his way of differentiating them

BTW did my solution to your trigger issue...

AHHHHAAAAAAAAAAAHH !!!!!!!!

select PictureName

From Pictures

group by PictureName

order by newid()