brianwells05
asked on
Querying sys.objects
Is there a way to query another databases sys.objects collection without creating a linked server? For example, I need to check whether a table exists in another database before doing something. Normally I would query sys.objects to get this but I don't want to create a linked server for this case to get it. Any ideas?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I should have mentioned that I was looking on the same server...but that's a very useful technique for remote servers....thanks for the input.