To prepare insert script for a datatable from MSSQL Server using stored procedure and write the result into a sql file dynamically using powershell script
Simple way to create insert script from table is explained. As many of them already know, using this method you can create DDL script as well.
How we can use sql client objects in the powershell to execute and process the result
In windows 7 environment you may receive “Unable to get window handle, Windowless ActiveX controls are not supported..” exception, when you display a child form that contains ActiveX user controls. The user control may be a third party control. To avoid this exception you may disable DEP (Data Execution Prevention) for your ActiveX control.
To solve “The name ‘ConfigurationManager’ does not exist in the current context” problem