Does anyone know how to check the current amount of "Open Objects"? I am getting an error that says my Open Objects parameter is set too low. If I cannot tell what it is currently set at, how can I tell how high to set it to?
Use sp_configure.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Rich" <anonymous@.discussions.microsoft.com> wrote in message
news:2F1B9867-385F-4984-B6E4-B62F538BBB53@.microsoft.com...
> Does anyone know how to check the current amount of "Open Objects"? I am getting an error that says my Open
Objects parameter is set too low. If I cannot tell what it is currently set at, how can I tell how high to
set it to?
|||Execute sp_configure and check the open objects run_value.
You can find more info on this setting in books online under
the help topic open objects Option
-Sue
On Tue, 27 Apr 2004 07:11:03 -0700, "Rich"
<anonymous@.discussions.microsoft.com> wrote:
>Does anyone know how to check the current amount of "Open Objects"? I am getting an error that says my Open Objects parameter is set too low. If I cannot tell what it is currently set at, how can I tell how high to set it to?
Showing posts with label objects. Show all posts
Showing posts with label objects. Show all posts
Monday, March 19, 2012
Open Obects Param
Does anyone know how to check the current amount of "Open Objects"? I am ge
tting an error that says my Open Objects parameter is set too low. If I can
not tell what it is currently set at, how can I tell how high to set it to?Use sp_configure.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Rich" <anonymous@.discussions.microsoft.com> wrote in message
news:2F1B9867-385F-4984-B6E4-B62F538BBB53@.microsoft.com...
> Does anyone know how to check the current amount of "Open Objects"? I am getting
an error that says my Open
Objects parameter is set too low. If I cannot tell what it is currently set
at, how can I tell how high to
set it to?|||Execute sp_configure and check the open objects run_value.
You can find more info on this setting in books online under
the help topic open objects Option
-Sue
On Tue, 27 Apr 2004 07:11:03 -0700, "Rich"
<anonymous@.discussions.microsoft.com> wrote:
>Does anyone know how to check the current amount of "Open Objects"? I am getting a
n error that says my Open Objects parameter is set too low. If I cannot tell what i
t is currently set at, how can I tell how high to set it to?
tting an error that says my Open Objects parameter is set too low. If I can
not tell what it is currently set at, how can I tell how high to set it to?Use sp_configure.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Rich" <anonymous@.discussions.microsoft.com> wrote in message
news:2F1B9867-385F-4984-B6E4-B62F538BBB53@.microsoft.com...
> Does anyone know how to check the current amount of "Open Objects"? I am getting
an error that says my Open
Objects parameter is set too low. If I cannot tell what it is currently set
at, how can I tell how high to
set it to?|||Execute sp_configure and check the open objects run_value.
You can find more info on this setting in books online under
the help topic open objects Option
-Sue
On Tue, 27 Apr 2004 07:11:03 -0700, "Rich"
<anonymous@.discussions.microsoft.com> wrote:
>Does anyone know how to check the current amount of "Open Objects"? I am getting a
n error that says my Open Objects parameter is set too low. If I cannot tell what i
t is currently set at, how can I tell how high to set it to?
Open Obects Param
Does anyone know how to check the current amount of "Open Objects"? I am getting an error that says my Open Objects parameter is set too low. If I cannot tell what it is currently set at, how can I tell how high to set it to?Use sp_configure.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Rich" <anonymous@.discussions.microsoft.com> wrote in message
news:2F1B9867-385F-4984-B6E4-B62F538BBB53@.microsoft.com...
> Does anyone know how to check the current amount of "Open Objects"? I am getting an error that says my Open
Objects parameter is set too low. If I cannot tell what it is currently set at, how can I tell how high to
set it to?|||Execute sp_configure and check the open objects run_value.
You can find more info on this setting in books online under
the help topic open objects Option
-Sue
On Tue, 27 Apr 2004 07:11:03 -0700, "Rich"
<anonymous@.discussions.microsoft.com> wrote:
>Does anyone know how to check the current amount of "Open Objects"? I am getting an error that says my Open Objects parameter is set too low. If I cannot tell what it is currently set at, how can I tell how high to set it to?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Rich" <anonymous@.discussions.microsoft.com> wrote in message
news:2F1B9867-385F-4984-B6E4-B62F538BBB53@.microsoft.com...
> Does anyone know how to check the current amount of "Open Objects"? I am getting an error that says my Open
Objects parameter is set too low. If I cannot tell what it is currently set at, how can I tell how high to
set it to?|||Execute sp_configure and check the open objects run_value.
You can find more info on this setting in books online under
the help topic open objects Option
-Sue
On Tue, 27 Apr 2004 07:11:03 -0700, "Rich"
<anonymous@.discussions.microsoft.com> wrote:
>Does anyone know how to check the current amount of "Open Objects"? I am getting an error that says my Open Objects parameter is set too low. If I cannot tell what it is currently set at, how can I tell how high to set it to?
Friday, March 9, 2012
OOP Objects and SSRS ? Doable? Reusable? Performance?
Is there any way to reuse Objects that returns a collection to my
report in SSRS?
Is it practical? Will it perform okay if I need to join the output
from that object with other data? Say I have a vb.net object that
already has all the business logic that joins a bunch of objects
(tables really). It's in one place and we like it that way. If I want
to use SSRS will I have to code a select (or a create a view) to get
my same expected row set?
Thanks for any help or information.You have several options. None of them great as far as I am concerned.
One is to use the reportviewer control that ships with VS 2005 and VS 2008.
Use it in local mode. In local mode you give it a dataset and a report.
However, there is a lot more coding and complexity involved and you lose the
server capabilities (subscriptions, performance, etc).
Two, to write a data processing extension. Non-trivial but possible. I would
read up on that in books online.
Or, have a web service that you query and get the data back from it. That
will work as well.
RS is not architected to perform this type of integration easily. It is a
SOA (service oriented architecture).
Crystal reports might work better if this is a hard and fast requirement.
But, do look up data processing extension. That is the best bet for you.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<wildman@.noclient.net> wrote in message
news:0802c9d7-98bb-4875-8f15-c24782d51cdd@.x35g2000hsb.googlegroups.com...
> Is there any way to reuse Objects that returns a collection to my
> report in SSRS?
> Is it practical? Will it perform okay if I need to join the output
> from that object with other data? Say I have a vb.net object that
> already has all the business logic that joins a bunch of objects
> (tables really). It's in one place and we like it that way. If I want
> to use SSRS will I have to code a select (or a create a view) to get
> my same expected row set?
> Thanks for any help or information.|||If the collections returned by your objects are 'flat' (have no nested
objects), you should be able to report on them, by exposing them as a web
service. See http://technet.microsoft.com/en-us/library/aa964129.aspx.
The documentation is a little sketchy. It works if your objects returns just
a list of fields. If there are nested objects, its not so simple.
<wildman@.noclient.net> wrote in message
news:0802c9d7-98bb-4875-8f15-c24782d51cdd@.x35g2000hsb.googlegroups.com...
> Is there any way to reuse Objects that returns a collection to my
> report in SSRS?
> Is it practical? Will it perform okay if I need to join the output
> from that object with other data? Say I have a vb.net object that
> already has all the business logic that joins a bunch of objects
> (tables really). It's in one place and we like it that way. If I want
> to use SSRS will I have to code a select (or a create a view) to get
> my same expected row set?
> Thanks for any help or information.
report in SSRS?
Is it practical? Will it perform okay if I need to join the output
from that object with other data? Say I have a vb.net object that
already has all the business logic that joins a bunch of objects
(tables really). It's in one place and we like it that way. If I want
to use SSRS will I have to code a select (or a create a view) to get
my same expected row set?
Thanks for any help or information.You have several options. None of them great as far as I am concerned.
One is to use the reportviewer control that ships with VS 2005 and VS 2008.
Use it in local mode. In local mode you give it a dataset and a report.
However, there is a lot more coding and complexity involved and you lose the
server capabilities (subscriptions, performance, etc).
Two, to write a data processing extension. Non-trivial but possible. I would
read up on that in books online.
Or, have a web service that you query and get the data back from it. That
will work as well.
RS is not architected to perform this type of integration easily. It is a
SOA (service oriented architecture).
Crystal reports might work better if this is a hard and fast requirement.
But, do look up data processing extension. That is the best bet for you.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<wildman@.noclient.net> wrote in message
news:0802c9d7-98bb-4875-8f15-c24782d51cdd@.x35g2000hsb.googlegroups.com...
> Is there any way to reuse Objects that returns a collection to my
> report in SSRS?
> Is it practical? Will it perform okay if I need to join the output
> from that object with other data? Say I have a vb.net object that
> already has all the business logic that joins a bunch of objects
> (tables really). It's in one place and we like it that way. If I want
> to use SSRS will I have to code a select (or a create a view) to get
> my same expected row set?
> Thanks for any help or information.|||If the collections returned by your objects are 'flat' (have no nested
objects), you should be able to report on them, by exposing them as a web
service. See http://technet.microsoft.com/en-us/library/aa964129.aspx.
The documentation is a little sketchy. It works if your objects returns just
a list of fields. If there are nested objects, its not so simple.
<wildman@.noclient.net> wrote in message
news:0802c9d7-98bb-4875-8f15-c24782d51cdd@.x35g2000hsb.googlegroups.com...
> Is there any way to reuse Objects that returns a collection to my
> report in SSRS?
> Is it practical? Will it perform okay if I need to join the output
> from that object with other data? Say I have a vb.net object that
> already has all the business logic that joins a bunch of objects
> (tables really). It's in one place and we like it that way. If I want
> to use SSRS will I have to code a select (or a create a view) to get
> my same expected row set?
> Thanks for any help or information.
Subscribe to:
Posts (Atom)