I need to be able to do a heartbeat check for a remote backup server. However, doing an sp_who on a backup server seems to kill execution of a procedure. When i run the code below on my server, it never prints the ending statements. What is the problem here ?
drop proc test_proc
create proc test_proc
print "THE START"
if @@error != 0
print "What is the problem here"