How to Find List of Tables Name and Columns or Fields Name of Specific Table in SQL Server

To Find the name of the tables name need to write this script:


SELECT name
FROM dbo.sysobjects
WHERE xtype = 'U'

To Select Names of the Fields or Columns of Specific Table by Name(SQL Script):

SELECT [name] AS [Column name]
FROM syscolumns
WHERE id = (SELECT id
FROM sysobjects
WHERE type = 'U'
AND [NAME] = 'Table_Name')

How to run IIS for ASP.NET in windows server 2003

Step 1:
setup iis then allow all web service extention

Step 2: Copy the published project (that worked previously) to the wwwroot

Step 3: right click on my computer->manage
then expanded and right click on Internet Information Service->website->default web site go to Propertise window
go to Document tab->remove all page then add only one page thats run as Home page

apply-> ok

Now also shows this error message:

unrecognized attribute 'type' error solve:


Step 4:


IIS framework 2.0.5......... install by command........
in run just type the below code:
%windir%\Microsoft.NET\Framework\v2.0.50727\aspnet_regiis.exe -i


hope this article will help every one