opening blog, and comment regarding executing procedures from views- August 23, 2004 Hi, this is my opening blog. I intend to use this space to discuss my SQL 2000 exploits, and to build up some blogging experience. As an opener, I'd like to describe a scenerio I've seen in news group posts - 'execution of a stored procedure as a view'. The normal work around for this is to use the openrowset provider. However, this only works if the stored procedure in question does not use temporary tables to build its result set. instead you will have to consider encoding the stored...http://blogs.msdn.com/ryans/archive/2004/08/23/218885.aspx |