OK - It's been awhile since I've been completely stumped, but here I am.
Using Wrox's "Professional SQL Server 2000 Programming", I have been trying to create a searchable text catalog with no luck. I followed the instructions step-bystep through running stored procedures with no results, not even an error. I repeated it on other databases in the system and used other methods including the wizard built into Enterprise Manager and point and click methods in EM.
Is there a way to troubleshoot when all your results show everything is working fine, but there simply aren't query results when you know there should be?