I want to populate/update a large table at night. I want to know the code structure or MSSQL features to be used for this. I am having a stored procedure for this purpose which is to be run at midnight.
Do we have any timer kind of facility which can trigger the run of stored procedure.
I would like to see some sample code lines.