Is there a way to get full text search to span all the databases on a server? I need all the Databases to be searchable with 1 search. Thanks for any help, if I didn't explain enough just tell me.
I am afraid you'll have to build your custom function which will - List all databases - List all tables in each database - Search each field in each table.
I am not aware of a function which will automatically do this for you.
J.