Hi Alan,

spp_findtext '','','','Device'

When I run this procedure I get the same database name for all the servers found

What is wrong?

Lucien

Thanks very much, this is working fine now, really appreciate your answer

Lucien

Hello, I am a newbie to sql server and I have created the sp in Master

When I execute the sp using 'sa' as parameter the following error occurs: ...