From: "Juan Vera " <mssqldba-ezmlmshield-x49717911.[Email Address Removed] Subject: RE: proc's result set to a temporary table. Date: Tue, 31 May 2005 11:19:02 -0700
That's elegant... :-)
> CREATE VIEW v_who > AS > SELECT * FROM > OPENROWSET ( 'SQLOLEDB', 'SERVER=.;Trusted_Connection=yes', > 'SET FMTONLY OFF EXEC sp_WHO' )