hi, i am doing a stored proc in which i add a server using sp_addlinkedserver and the location parameter is passed dynamically. in some instances the location doesnt exist and hence the processing stops. but i still want to continue the processing by writing the error handler for the above problem. but i observed that the variable @@error doesnt catch this error. is there anyway i can catch the error?? does sp_addlinkedserver return any result set or some error code in some form of variable so that i can catch it and use it in my error handler?? any ideas? thanx in advance akbar Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
