Reg:Extract View information in Sql server

[User 4005525]

Hi, I have a view. i want to get the columns in a view along with its database and servername. For example, Employee table resides in CSCEmp server's Emp database. I have a view in CSCDet server that will have a column "EmpName" of [CSCEmp's] Employee table. When i list view information, i want to display like view view'sserver Columnname column'sServer EMPView CSCDet EmpName CSCEmp Is there a way to do like this. Thanks.

[Mycroft Holmes]

Look into the information schema views (under system views in management studio) or sysobjects in 2k. These will give you all the information about SQLs internal structures.

Never underestimate the power of human stupidity RAH