Yo can find this solution from http://stackoverflow.com/questions/4678819/how-to-debug-windows-services-in-visual-studio or http://msdn.microsoft.com/en-us/library/7a50syb3(v=vs.110).aspx You can also try this. Create your Windows service and install and start…. That is, Windows services must be running in your system. While your service is running, go to the Debug menu, click on Attach Process (or process in old Visual Studio) Find your running service, and then sure the Show process from all users and Show processes in all sessions is selected, if not then select it. Click the Attach button Click OK Click Close Set a break point to your desirable location and wait for execute. It will debug automatic whenever your code reaches to that point. Remember, put your breakpoint at reachable place , if it is onStart (), then stop and start the service again If your debugger ...
Problem As a part of my best practices, I always save the T-SQL scripts used for creation and modification of objects in SQL Server. When creating and modifying tables using SQL Server Management Studio designer it is easy to right click in the designer and select "Generate Change Script...", but is there a way to automatically script the creation and/or modification of tables made through of SQL Server Management Studio (SSMS) designer? This tip shows you an option that exists within SSMS to automatically generate these scripts for all table changes when using the table designer. Solution Within SQL Server Management Studio (SSMS) there is an option to automatically generate scripts for your changes done through the GUI. The solution for this problem is provided in SSMS and works with both SQL Server 2005 and SQL Server 2008, but by default this option that we will discuss is disabled. To enable the option From the SSMS menus click on "Tools" ...
Comments
Post a Comment