[MSSQL] Run Procedure With Select

To run stored procedure using select, but the parameter is compulsory.

SELECT PROCEDURE_NAME(PARAM1,PARAMx)

[MSSQL] Alter Table

ALTER TABLE table

ADD column_name
data_type [ ( size ) ]
[ DEFAULT value ]
[ NULL | NOT NULL ]
[ PRIMARY KEY | UNIQUE ]
[ CONSTRAINT constraint_name ]

ALTER COLUMN column_name
data_type [ ( size ) ]
[ ( precision [ , scale ] ) ]
[ NULL | NOT NULL ]

DROP COLUMN column_name | [ CONSTRAINT ] constraint_name

[MSSQL] Enable sa Login

alter login sa enable;
go
alter login sa with password = ''

[IIS] HTTP Error 404 in IIS 6.0

Error message 1
HTTP Error 404 - File Not Found

Error message 2
HTTP Error 404- File or Directory not found

Resolution:
1. Open IIS Manager, expand the master server node (that is, the Servername node), and then select the Web service extensions node.
2. In the right pane of IIS Manager, right-click the extension that you want to enable. In this example, this is Active Server Pages.
3. Click to select the Allow check box.

Please refer to http://support.microsoft.com/kb/315122