I had a script working locally to add a full text catalog. When I went to run remotely, part ran and part failed, as though it could not find some stored procedures in master/user. I was running from user.

Also, does anyone have a script to clean up catalogs, after restoring a database that points to a catalog which does not exist on the new db. If it points to a non existent catalog, I cannot find a way to delete it.

Thanks,
MC