I am very new to RS so please excuse my ignorance. Developers and business
are asking if they can have RS running on the same SQL Server instance I have
my transactional based database's on. I have always segregated my transaction
and DSS database from one another. Does anyone have any documentation
detailing the prerequisites for Reporting Services?Microsoft has a couple of great articles on their web site...
Maybe this one will help
http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/rsdepgd.mspx
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"FredG" <FredG@.discussions.microsoft.com> wrote in message
news:DDD8C9EE-C7F2-41FC-91BB-C3400E318785@.microsoft.com...
>I am very new to RS so please excuse my ignorance. Developers and business
> are asking if they can have RS running on the same SQL Server instance I
> have
> my transactional based database's on. I have always segregated my
> transaction
> and DSS database from one another. Does anyone have any documentation
> detailing the prerequisites for Reporting Services?|||Hello Mr. Snyder,
Thank you very much for the doucmentation. Do you know of any whitepapers or
discussions detailing performance of RS?
"Wayne Snyder" wrote:
> Microsoft has a couple of great articles on their web site...
> Maybe this one will help
> http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/rsdepgd.mspx
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "FredG" <FredG@.discussions.microsoft.com> wrote in message
> news:DDD8C9EE-C7F2-41FC-91BB-C3400E318785@.microsoft.com...
> >I am very new to RS so please excuse my ignorance. Developers and business
> > are asking if they can have RS running on the same SQL Server instance I
> > have
> > my transactional based database's on. I have always segregated my
> > transaction
> > and DSS database from one another. Does anyone have any documentation
> > detailing the prerequisites for Reporting Services?
>
>
Showing posts with label business. Show all posts
Showing posts with label business. Show all posts
Thursday, March 22, 2012
Sunday, March 11, 2012
Applying business rules to the database
Hi Experts,
My system stores events into a large table. I would like to apply some
rules on that table and possibly take action if the rules were satisfied.
For example if a certain event arrives 2 times in 60 seconds then perform an
action. What is the best way to apply rules to data in the database? If it
cannot be done with the database itself a recommendation of a third party
tool will be great. However please not that I cannot use any GUI. I need
to declare the rules and get the result of the rule into my application
which can be in C++ or C#
Thanks for all the help,
AviHave you looked at streaming databases? Google up BitStream.|||You could use triggers in SQL but if you need to invoke external code
against the database then it's better to put this in a middle-tier
application. In your middle-tier code, poll the table regularly for the
changes based on a date-time stamp column.
David Portas
SQL Server MVP
--
My system stores events into a large table. I would like to apply some
rules on that table and possibly take action if the rules were satisfied.
For example if a certain event arrives 2 times in 60 seconds then perform an
action. What is the best way to apply rules to data in the database? If it
cannot be done with the database itself a recommendation of a third party
tool will be great. However please not that I cannot use any GUI. I need
to declare the rules and get the result of the rule into my application
which can be in C++ or C#
Thanks for all the help,
AviHave you looked at streaming databases? Google up BitStream.|||You could use triggers in SQL but if you need to invoke external code
against the database then it's better to put this in a middle-tier
application. In your middle-tier code, poll the table regularly for the
changes based on a date-time stamp column.
David Portas
SQL Server MVP
--
Thursday, March 8, 2012
Applications are often blocked
Hi all ,
I renew my request and hope you could give me a hand.
We use Small Business Server and we have 14 small
officies, and in each officy we have 1 server and 3 PC
client.
*We have SQL server 2000 Small Business with SP3, running
on the server which is the domain controler too and there
are no Trust Realation between them.
*On each server and each client we have an Access's
application which extract and treat data from SQL server.
We use the mobil profil and with our policy of security
user can log and use the server like the Workstation.
In each server, We use Memory Virtual 1024 Mo and we
dedicate all of them for APLLICATIONS.
Some time our application is is blocked but
it happened only with user who exploiting the application
in the server and there are no Errors Messages.
Do you have some idea, please.
Can
.SQL has some traceflags you can turn on to aid in finding the cause of
blocking.
DBCC TRACEON (1204,3605,-1)
Also have a look at http://vyaskn.tripod.com/administration_faq.htm#q14
--
HTH
Ryan Waight, MCDBA, MCSE
"can" <canpama@.netscape.net> wrote in message
news:ac4701c3811c$27c587b0$a601280a@.phx.gbl...
> Hi all ,
>
> I renew my request and hope you could give me a hand.
> We use Small Business Server and we have 14 small
> officies, and in each officy we have 1 server and 3 PC
> client.
> *We have SQL server 2000 Small Business with SP3, running
> on the server which is the domain controler too and there
> are no Trust Realation between them.
> *On each server and each client we have an Access's
> application which extract and treat data from SQL server.
> We use the mobil profil and with our policy of security
> user can log and use the server like the Workstation.
> In each server, We use Memory Virtual 1024 Mo and we
> dedicate all of them for APLLICATIONS.
> Some time our application is is blocked but
> it happened only with user who exploiting the application
> in the server and there are no Errors Messages.
> Do you have some idea, please.
> Can
> .
>
I renew my request and hope you could give me a hand.
We use Small Business Server and we have 14 small
officies, and in each officy we have 1 server and 3 PC
client.
*We have SQL server 2000 Small Business with SP3, running
on the server which is the domain controler too and there
are no Trust Realation between them.
*On each server and each client we have an Access's
application which extract and treat data from SQL server.
We use the mobil profil and with our policy of security
user can log and use the server like the Workstation.
In each server, We use Memory Virtual 1024 Mo and we
dedicate all of them for APLLICATIONS.
Some time our application is is blocked but
it happened only with user who exploiting the application
in the server and there are no Errors Messages.
Do you have some idea, please.
Can
.SQL has some traceflags you can turn on to aid in finding the cause of
blocking.
DBCC TRACEON (1204,3605,-1)
Also have a look at http://vyaskn.tripod.com/administration_faq.htm#q14
--
HTH
Ryan Waight, MCDBA, MCSE
"can" <canpama@.netscape.net> wrote in message
news:ac4701c3811c$27c587b0$a601280a@.phx.gbl...
> Hi all ,
>
> I renew my request and hope you could give me a hand.
> We use Small Business Server and we have 14 small
> officies, and in each officy we have 1 server and 3 PC
> client.
> *We have SQL server 2000 Small Business with SP3, running
> on the server which is the domain controler too and there
> are no Trust Realation between them.
> *On each server and each client we have an Access's
> application which extract and treat data from SQL server.
> We use the mobil profil and with our policy of security
> user can log and use the server like the Workstation.
> In each server, We use Memory Virtual 1024 Mo and we
> dedicate all of them for APLLICATIONS.
> Some time our application is is blocked but
> it happened only with user who exploiting the application
> in the server and there are no Errors Messages.
> Do you have some idea, please.
> Can
> .
>
Application Settings and data extensions
I have application settings that I set in a configuration class and expose
via properties. My business objects use these settings. I use these
business objects in a data extension for reporting services. I include the
configuration dll and business object dlls with my data extension dll. The
application settings are not being found. How do I get these to work?Hello Bruce,
Based on my research, you need to check whether you have include your
configuration dll in your ReportServer web.config file.
Please try to check you web.config file.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||I don't understand your response. Could you please provide more information.
"Wei Lu [MSFT]" wrote:
> Hello Bruce,
> Based on my research, you need to check whether you have include your
> configuration dll in your ReportServer web.config file.
> Please try to check you web.config file.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> Get notification to my posts through email? Please refer to
> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
> ications.
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up response may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> http://msdn.microsoft.com/subscriptions/support/default.aspx.
> ==================================================> (This posting is provided "AS IS", with no warranties, and confers no
> rights.)
>|||Hello Bruce,
First, I would like to know have you use the strong named assembly?
If so, I will suggest you to put all the assembly to the GAC.
If not strong named assembly, please put all the assembly to the Bin folder
of your extension project.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.
via properties. My business objects use these settings. I use these
business objects in a data extension for reporting services. I include the
configuration dll and business object dlls with my data extension dll. The
application settings are not being found. How do I get these to work?Hello Bruce,
Based on my research, you need to check whether you have include your
configuration dll in your ReportServer web.config file.
Please try to check you web.config file.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||I don't understand your response. Could you please provide more information.
"Wei Lu [MSFT]" wrote:
> Hello Bruce,
> Based on my research, you need to check whether you have include your
> configuration dll in your ReportServer web.config file.
> Please try to check you web.config file.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> Get notification to my posts through email? Please refer to
> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
> ications.
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up response may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> http://msdn.microsoft.com/subscriptions/support/default.aspx.
> ==================================================> (This posting is provided "AS IS", with no warranties, and confers no
> rights.)
>|||Hello Bruce,
First, I would like to know have you use the strong named assembly?
If so, I will suggest you to put all the assembly to the GAC.
If not strong named assembly, please put all the assembly to the Bin folder
of your extension project.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.
Saturday, February 25, 2012
Application need Date without Time
Hello,
We are managing industry standard application for solvent business need and it is working fine as per requirement but after replication we got some problem with date type data.
We have stored date data through application in dd/mm/yy format only, we didn't used time data so it is truncated in overall application but after implementation for replication (Merge Model) from multiple location some date field automatically get time with date value, so some time application not retrieving data from database owing to stored time with date.
How I can resolve this issue I didn't get any solution in short way.
Thanks in advance to every particapetience.
R.MallYou do know that datetime data always stores both. right?
If no time is supplied the default time is 0, or midnight.
We are managing industry standard application for solvent business need and it is working fine as per requirement but after replication we got some problem with date type data.
We have stored date data through application in dd/mm/yy format only, we didn't used time data so it is truncated in overall application but after implementation for replication (Merge Model) from multiple location some date field automatically get time with date value, so some time application not retrieving data from database owing to stored time with date.
How I can resolve this issue I didn't get any solution in short way.
Thanks in advance to every particapetience.
R.MallYou do know that datetime data always stores both. right?
If no time is supplied the default time is 0, or midnight.
Subscribe to:
Posts (Atom)