well this can be done using code behind file. but i heard we can do it using sqlserver2000 enterprize manager if u have any idea regarading that , please help me

table 1, empno(pk), empname , empage table 2, deptno(pk),deptname,dept_empno(fk) then when joinging the datea select empname,emapage,empno,deptname from table1 inner join table2 on empno = dept_empno

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. Thank you for helping me in advance You can mail me the procedure suhailquadri@gmail.com

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.

well using sp_depends storedprocedurename , it will list all the details of a stored procedure.

Thanks i got the solution.

Hi, i want to write stored procedure insuch a way where in it has to return the table name used stored procedure. for example create procedure proc1 as begin select * from student end once u exit exec proc1 it has return the table name used i.e "Student" could you please help in doing this. or it is possible in sql. reply me soon at suhailquadri@gmail.com:-D Suhail Ahmed Mohammed, Application Engineer, Cybernet Slash Support