Thanq chris, now only i saw ur reply.Thans a lot

Thanq mike, now only i saw ur reply n thans once again

I can't get u prakash.. can v inse..,dele.. ,upda.. in a view.. Is it possible...

Likewise,

1.A stored procedure can't return a table whereas a function can.

2. We can't use 'Print' statement in functions whereas in S.P we can.

these are 2 of the plenties..

Sorry kelley,

When i m running those statements in the sql server, there exists an error message "Invalid object name ....".  Wat 2 do now.

U didn't specify any method to do the task..

What is the way to achieve it

sorry kelly,                                                                   i can't get u..                                                         where do i want to execute the specified query..           esp.,Select * from Win32_PingStatus and Select * from Win32_Process

thanq hanslindgren..

is there any other way to achieve the task without logging as the administrator of the network.

thanq gurus..

sorry mr.remi gregoire.. i can't catch ur point clearly.. can u explain it in a detailed manner.. or can u give the script of the function(which returns the max of...