stored procedures in reporting database

[johnhitashi]

Hi all,


I installed MSPS 2007 , its really nice... i wanted to know
why the stored procedures & triggers used in the reporting database ,
why it is needed ? What role they play ? please if any one can tell m
e, it will be helpful...

Thanks in advance

 

[Gary L. Chefetz [MVP]]

John:

These contain much of the business logic in the system.

--

Gary L. Chefetz, MVP
MSProjectExperts
For Project Server Consulting: http://www.msprojectexperts.com
For Project Server FAQS: http://www.projectserverexperts.com

 

[johnhitashi]

John:

These contain much of the business logic in the system.

--

Gary L. Chefetz, MVP
MSProjectExperts
For Project Server Consulting:http://www.msprojectexperts.com
For Project Server FAQS:http://www.projectserverexperts.com

Thanks Gary,

Well , can u explain a bit what business logic is carried by stored
procedures.. any links or documentation which talks about it...

 

[Gary L. Chefetz [MVP]]

John:

Microsoft does not want you mucking with these, and will not support your
solution if you do. They, therefore, do not document these. The easiest way
for you to see what's in there, is to look at them in the database. If
you're conversant with SQL, you should be able to figure it out.

--

Gary L. Chefetz, MVP
MSProjectExperts
For Project Server Consulting: http://www.msprojectexperts.com
For Project Server FAQS: http://www.projectserverexperts.com