suhailahmedmohammed wrote: hi, Well i am using the sqlserver2000 as backend. I have table like seatdetails and columns are seatno,bookingdate,dateoftravel,seatstatus the seatstatus can be 0 - rejected, 1 -pending, and 2 - accepted. Now the issue is daily at 12:00am , i need to execute the trigger or event which should check the dateoftravel with the date in server if it is less then check the status of a seat if it is 1 (i.e status of a seat) then the date diff of bookingdate and cureentdate if it is equal to 3 (i.e. counter of days) then the status should be set to 0 (i.e. status of a seat) and mail sent to @mailid1 and @mailid2 regarding the changes from the sqlserver. That's a pretty nice novel you have there. Now, what exactly is your question? I.E., where in writing the code for this are you having problems? suhailahmedmohammed wrote: You can mail me the procedure suhailquadri@gmail.com WHAT? Do your work yourself. This isn't rent-a-coder. This is a place where you ask specific questions when you are having specific problems. I can't wait until my device is finished. I'm going to become rich when I create a device that allows me to punch people in the face over the internet. "If an Indian asked a programming question in the forest, would it still be urgent?" - John Simmons / outlaw programmer

you need to access the information about stored procedure dependencies written by another dba. I m displaying the information of stored procedure dependencies using sp_depends procedurename. It was requested by one of my client. Now programmetically i dispalyed in table and displayed accordingly.