SQL 2000 Stored procs - do I need to schedule? 1

[misuser]

I havent used SQL 2000 Stored procs much yet with Crystal

I think my question is quite basic(!)

I have connected CR9 to an SQL Server 2000 DB stored procedure as the data source. this works fine - I get the data I need. When CR9 connects to the Stored Proc tomorrow will the data be the same or does it hit the data base everytime it connects to the stored proc. Alternatively do I need to schedule the stored proc so the data it returns changes each day?

any help very welcome, thanks!

 

[JayKusch]

When crystal calls the stored procedure(SP) the SP will be reexecuted. Thus any new records that were added/updated/deleted will be processed.

Thanks

J. Kusch