thanks for the reply. probably i misunderstood but following is the link i got my understanding from.its here http://www.informit.com/library/content.aspx?b=STY_Sql_Server_7&seqNum=145
Careful. You are quoting from a book that is over ten years old. This is usually fine if the book is about theoretical or academic work but that book is a "Teach Yourself To Be A Dummy In 60 Seconds" styled book on SQL Server 7.
I know some people may still be supporting SQL Server 7 installations.
I know that a lot of people like these types of books.
I only said be careful.
-- Stop your grinnin' and drop your linen...they're everywhere!!!