Size of resultset

From: Pod (peterlazell_at_podware.co.uk)
Date: 03/13/05

Next message: Andrew: "Re: MSAccess and ADO"

Previous message: Dennis Passmore: "Re: Overloaded TADOCommand.Execute.. How to use?"
Next in thread: Jeremy Collins: "Re: Size of resultset"
Reply: Jeremy Collins: "Re: Size of resultset"
Reply: Arnie: "Re: Size of resultset"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Date: Sun, 13 Mar 2005 20:24:11 -0000

Is there anyway to find out the size of a result set that a query retrieves?
I am using SQL Server and although there is a stored procedure called
sp_spaceused which brings back the size of a table, this is not what I am
looking for as I need to know the amount of spaced used for the result set.

Next message: Andrew: "Re: MSAccess and ADO"

Previous message: Dennis Passmore: "Re: Overloaded TADOCommand.Execute.. How to use?"
Next in thread: Jeremy Collins: "Re: Size of resultset"
Reply: Jeremy Collins: "Re: Size of resultset"
Reply: Arnie: "Re: Size of resultset"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Relevant Pages

in sql server is it possible to get the amount of memory used by a stored procedure? e.g. memory usa
... in sql server is it possible to get the amount of memory used by a stored ... e.g. memory usage statistics per stored procedure? ...
(microsoft.public.sqlserver.connect)
in sql server is it possible to get the amount of memory used by a stored procedure? e.g. memory usa
... in sql server is it possible to get the amount of memory used by a stored ... e.g. memory usage statistics per stored procedure? ...
(microsoft.public.sqlserver.datawarehouse)
in sql server is it possible to get the amount of memory used by a stored procedure? e.g. memory usa
... in sql server is it possible to get the amount of memory used by a stored ... e.g. memory usage statistics per stored procedure? ...
(microsoft.public.sqlserver.security)
in sql server is it possible to get the amount of memory used by a stored procedure? e.g. memory usa
... in sql server is it possible to get the amount of memory used by a stored ... e.g. memory usage statistics per stored procedure? ...
(microsoft.public.sqlserver.datamining)
Re: How to get list of EventClasses in MSSQLServer2000
... statement inside a stored procedure has completed.') ... SQL Server statement or stored procedure.') ... Plan','Displays the plan tree of the Transact-SQL statement executed.') ... Login','Occurs when a SQL Server login is added or removed; ...
(microsoft.public.sqlserver.security)