Converting my temp tables to the table datatype and using a UDF instead worked!! Although i could have swore there is a way to invoke a sproc inside a update/select...

Thanks but i need to used temp tbls which cannot be done inside a  udf

Hey there. Thanks for the advice. I tried datawriter but that still doesn't give me execute permissions on the sprocs.

Perfect. Thanks!

Thanks to all who replied!

This works:

SET ANSI_NULLS ON

SET ANSI_WARNINGS ON

GO

CREATE PROC A

AS

SET ANSI_NULLS ON

SET ANSI_WARNINGS ON

Select null

GO

This function worked like a charm.

Many Thanks!

YES

yes, but it sounds like they still need to be parsed. checkout where this guy says: "On the other hand, it isn't compiled prior to use. Each query or line...