Hi Serg,

This scenario occurred as part of my routine work, where I tried to fetch data from the table and noticed that complete data is not fetched and there onwards...

Hi,

with the following query you can know which is the latest updated SP

select * from sys.procedures order by modify_date desc

thanks ravi..

i got the issue...i have three date keys in fact table ..so when i am adding date dimension i am having 3 dimensions one for every foriegn key with...