Thanks David,

I will have to run this from databases. If i would like to collect list of all table in all databases present on server, is there any system DMV? I would...

Hi,

Is there any DMV in SQL 2005 to get this information directly?

TIA

Sandesh

yes, it is folder heirarchy is changed in SQL 2005.

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLServer\SuperSocketNetLib\Tcp\IPAll\TcpPort

It contains one folder with spaces (Microsoft SQL Server) and now master.dbo.xp_instance_regread is giving error there. I tried to...