Vladan (5/28/2008)

---

Hmmm... there are certain limitations to using TRY..Catch, and - as I understand it - nonexistent objects (tables) are one of the things that doesn't work because of deferred...

good luck! Let us know if you have any more questions.

AFCC Inc. Com (5/27/2008)

---

It looks like to me that Vendors can be customers that purchase goods from a company, and it also looks like Vendors can be a company's supplier....

You don't need a cursor (not even a hidden one, as in the sp_MSforeachTable proc), this article lists a view that can do this, and includes much more per table...

glad we could help.

How about:

Select count(*)

From (Select TOP 1 *

From ServerName.DBName.Schema.TableName)

Not directly. I believe that you have to force it through some intermediate data types first, like:

Select @img =...

Yes, it would have been nice if SQL Server had dependent objects use dependent Namespaces, but that never happened.

The only way that you could get this information would be to parse the View source code yourself. The source code is available (in syscomments and other places).

Hmm, this makes it...

I've been doing it for thirty years, but it still suprises me how hard some folks make it to help them.

to get you started:

select * from tablename for xml auto

guess we would have to see the code then.

Well, in the first one you passed in a varchar parameter ('123') and in the second one you passed in int (Employee.ID), apparently.

try this:

select *

from master.sys.databases D

left Join master.sys.master_files F on F.database_id = D.Database_id