Dec 10, 2012

Database space used

EXECUTE sp_spaceused ur_table; EXECUTE sp_MSforeachtable 'EXECUTE sp_spaceused [?];';

Remote Desktop Connection Manager-RDCMan

You could connect and work multiple remote session at once in a single screen!!!. For Download http://www.microsoft.com/en-us/download/details.aspx?id=21101 For demo video http://www.youtube.com/watch?v=qVTAHo-uUAw Kindly think about the security risk before configure all the remote screens at a single file.

xcopy for fast copy

xcopy c:\dbbk\*.* \\tsclient\e\*.* /E /R /K /Y use this method to copy files from remote or other places. It would be faster than other methods.