carlop-dev.blogspot.com
carlop technical journal: Reset SQL Schema during your coding sessions
http://carlop-dev.blogspot.com/2008/10/reset-sql-schema-during-your-coding.html
My personal memo about software development. Monday, 13 October 2008. Reset SQL Schema during your coding sessions. I think that anyone that writes SQL code has coded like the following:. This is quite common for me during the testing phase, since I find myself comfortable in writing a single script that drops and recreates all objects under development… but it is also quite frustrating to copy and paste always the same code only to change the object name. Subscribe to: Post Comments (Atom).
carlop-dev.blogspot.com
carlop technical journal: Reporting Service Permissions on Windows 7
http://carlop-dev.blogspot.com/2011/01/reporting-service-permissions-on.html
My personal memo about software development. Wednesday, 26 January 2011. Reporting Service Permissions on Windows 7. I installed RS on a brand new installation on windows 7 x64 with SqlServer 2008 R2, The user I was logged on had full administrative privileges, UAC was turned on as normal. As soon I tried to access the Reporting Services Site I got the following error: The permissions granted to user 'DOMAINNAME USERNAME' are insufficient for performing this operation. Log on as built-in administrator.
carlop-dev.blogspot.com
carlop technical journal: How to setup Distributed Transaction Coordinator
http://carlop-dev.blogspot.com/2007/02/how-to-setup-distributed-transaction.html
My personal memo about software development. Monday, 5 February 2007. How to setup Distributed Transaction Coordinator. The problem is really simple: You issue a query against a linked server and want to use transactions, but you get back an error, something like "The partner transaction manager has disabled its support" or "Distributed transaction coordinator has failed to ."Ok, this is how you can set-up DTC to make distributed queries to work:. 1 Go to "Administrative Tools Services". On your client c...
carlop-dev.blogspot.com
carlop technical journal: Problems enabling service broker
http://carlop-dev.blogspot.com/2009/04/problems-enabling-service-broker.html
My personal memo about software development. Wednesday, 29 April 2009. Problems enabling service broker. If you restore a database with service broker enabled on the same sql server instance, it may happen that broker doesn't enables and when try to manually enable it you may get back the following error message:. The Service Broker in database? Cannot be enabled because there is already an enabled Service Broker with the same ID. This statement fixed the situation:. Subscribe to: Post Comments (Atom).
carlop-dev.blogspot.com
carlop technical journal: New Debugger Behavior in Visual Studio 2012
http://carlop-dev.blogspot.com/2012/11/new-debugger-behavior-in-visual-studio.html
My personal memo about software development. Sunday, 4 November 2012. New Debugger Behavior in Visual Studio 2012. I have a .NET 3.5 library project to debug. To do it . I launch it through an external exe compiled with Delphi in native code. This works great in visual studio 2010 and earlier, I never had any issue of any type. This doesnt works anymore in visual studio 2012: the debugger doesnt stops, breakpoints are simply ignored. Solution #1: Use Debug - Attach to Process - Change the debugger type b...
carlop-dev.blogspot.com
carlop technical journal: Welcome to Wotsit.org
http://carlop-dev.blogspot.com/2009/12/welcome-to-wotsitorg.html
My personal memo about software development. Thursday, 17 December 2009. Welcome to Wotsit.org. From the site home page: “ The programmer's file and data format resource. This site contains information on hundreds of different file types, data types, hardware interface details and all sorts of other useful programming information; algorithms, source code, specifications, etc. It is a quite useful site with plenty of information, really worth a bookmark on your favorites:. Http:/ www.wotsit.org/.
carlop-dev.blogspot.com
carlop technical journal: Default Debugger
http://carlop-dev.blogspot.com/2009/11/default-debugger.html
My personal memo about software development. Monday, 16 November 2009. By default, Microsoft Windows uses Dr. Watson debugger as the default debugger. This can be altered in the Windows registry manually by a user or by the installation of software such as Visual Studio or Delphi. I think that having Visual Studio popped up each time an application crashes can be very annoying especially if you are performing some test but you don't need to debug that application. Subscribe to: Post Comments (Atom).
carlop-dev.blogspot.com
carlop technical journal: Irritating one-sided policies by Microsoft applications ...
http://carlop-dev.blogspot.com/2007/03/irritating-one-sided-policies-by.html
My personal memo about software development. Tuesday, 27 March 2007. Irritating one-sided policies by Microsoft applications . Go to HKEY CLASSES ROOT mailto shell open command. Change the value of the (Deafult) string. For outlook it may look like this: "C: PROGRA 1 MICROS 2 OFFICE11 OUTLOOK.EXE" -c IPM.Note /m "%1". For Novell groupwise it is something like that: C: Novell GroupWise gwmailto.exe /%1. Now I'm happy :). Subscribe to: Post Comments (Atom). View my complete profile.
carlop-dev.blogspot.com
carlop technical journal: How to cleanup SQL Server Service Broker
http://carlop-dev.blogspot.com/2008/10/how-to-cleanup-sql-server-service.html
My personal memo about software development. Thursday, 16 October 2008. How to cleanup SQL Server Service Broker. If you need to cleanup or reset Service Broker, you may find useful this short script that shuts down all open conversations and cleans up the Service Broker queue. Select top 1 @u=conversation handle from sys.conversation endpoints. While @u is not null begin. END CONVERSATION @u WITH CLEANUP. Set @u = null. Select top 1 @u=conversation handle from sys.conversation endpoints.
carlop-dev.blogspot.com
carlop technical journal: Using C# assembly from Delphi Win32
http://carlop-dev.blogspot.com/2010/02/using-c-assembly-from-delphi-win32_01.html
My personal memo about software development. Monday, 1 February 2010. Using C# assembly from Delphi Win32. A hands-on lab on how to call a C# class from within delphi win32 code. 1 First declare a C# interface as follows. 2 Write a class that implements the interface. System.Windows.Forms. MessageBox. 3 Make sure to set the assembly COM-Visible: Project options - Application Tab - Check “Make assembly COM visible”. 4 Declare the same Interface also in delphi:. Procedure DoSomething; safecall;. Life witho...
