Hi,

Pls. refresh the service acount passward for both mssqlserver and agent services.and then try u will come out with the success.

Pls. revert back after doing so.

Regards

Satendra Singh

Hi..

as because table variable remains in the buffer(memory), It takes less time in almost every transaction happened in comparison of temp table which store in tempdb.So in mu openion table...