Tag Archives: tips and tricks

Stop the command prompt from disappearing after execution

For most of the tasks I use the keyboard shortcuts. The touchpad comes in to picture only when there is no shortcut for a particular task or I don’t recollect the shortcut. Hence to launch any applications I use Start … Continue reading

Posted in SQLServerPedia Syndication | Tagged , | 5 Comments

Generate script for objects along with data using Microsoft SQL Server Database Publishing Wizard

Last week, we had a request from the Application Team to generate the DDL script for all objects on a Production database. Since the number of objects on that database was quite high (more than 100,000), the Generate Script wizard … Continue reading

Posted in scripts, SQLServerPedia Syndication | Tagged , , | 2 Comments