Web Log

During project development you might have come across a situation where you need Insert script along with values from SQL Table. Found a very useful tool  SQL Script Generator   at CodePlex.  SQL Script Generator is a tool for generate INSERT/UPDATE statement SQL script. With SQL Script Generator you can create script to copy data from one database to another.

I recently encountered an issue on one of our development box, where SQL log files on C:\ and transaction logs grew to 13GB, on the other hand the DB size is just 29 MB. Used following SQL query to reduce the size of log file to free up the space ALTER DATABASE [DBNAME] SET RECOVERY SIMPLE; GO --Shrink the truncated log file to 1 MB. DBCC SHRINKFILE ( [DBNAME_LOGFILE_NAME] , 1); GO --Reset the database ALTER DATABASE  [DBNAME] SET RECOVERY FULL; GO

Recently our team ran into an issue where SharePoint where solution deployment is failing with following errors. After troubleshooting and going through the forums it was suspected that WMI might be corrupt on the Windows 2003 Server hosting SharePoint. To confirm the suspicion that WMI was indeed corrupt, we used the wbemtest.exe utility to check connectivity. Click Connect: Click Connect, using the default values: If no error is thrown, you have successfully connected to the local machine via WMI. If “Not Found” error message is received, you indeed have a corrupted WMI instance. To further test, you could execute the following WMI query to test the specific class SharePoint is querying during search provisioning, using the following example: If you received an error message when trying to connect, you can attempt to re-register the WMI .dll’s and .exe’s using the following seven steps: 1. Disable and stop the Windows Management Instrumentation service. 2. Right-