quote:

---

can i write a cursor in a stored procedure?

---

Yes you can, anything...

Execute system proc. sp_who2. as follows

Exec Master..sp_who2

This proc. will report all current sessions on any given SQL server,

including CPU Time, Disk IO, Client Source (ex. IIS, Query Analyzer)...

Here is an example:

CREATE PROC Author_Info

@Au_Id VARCHAR(14) OUT,

@Au_FName VARCHAR(14) OUT,

@Au_LName VARCHAR(14) OUT,

@Phone VARCHAR(14) OUT

...