Posts

Compatibility problem in Windows Vista (7) family

You build your application in visual Studio 2005 or 2008 but The application gives error if it runs on Windows 7 or Vista event there is no problem on Windows XP. The problem is about compaqtibility problem with your application.it may be about Data Execution Prevention architecture in windows. You can obtain such information on my other post. anyway, You have to re-build your project in Microsoft Visual Studio (2005 0r 2008) with parameter of ; /DYNAMICBASE:NO /NXCOMPAT:NO and also you have also one more thing to do to solve this problem .Open Visual studio Command Promkp via Visual Studio Tools and call editbin with parameter shown below; editbin.exe /NXCOMPAT:NO good luck

Microsoft Visual Studio gives an error while loading form in design time

if you are facing an error : " One or more errors encountered while loading the designer. The errors are listed below. Some errors can be fixed by rebuilding your project, while others may require code changes" while Microsoft Visual Studio loading the form in Design Time. You have to initialize all properties which belong to form.You will probably get "object reference not set to an instance of an object" in the details of the error. Please Initialize all objects with "new" keyword or set them existance once. If you do not know main responsible of causing this error.Please follow the below to ask Visual Studio. Open a new Visual Studio instance. Open any source file. This is required to see Debug menu so that Visual Studio lets you attach to a process. Attach the old Visual Studio instance to the newest one. The Visual Studio process is called devenv.exe with the name of loaded project . You only need to attach to managed code. Set Visual Studio to

Attempted to read or write protected memory. This is often an indication that other memory is corrupt.

Image
if any installed application does not run after upgrading operating system with followings Windows Vista,Windows 7 , Windows 2008 Server Family and gives an error such as "Attempted to read or write protected memory. This is often an indication that other memory is corrupt." The porblem mostly about memory permission. You can try this;(based upon Windows 2008 Server,if you use different once, some step may be changed) 1-Right Click to "Computer " 2-Select "Properties" 3-Click "Advanced System Settings" on the left panel of newly opened window. 4-Select "Settings" on the first Group Box,name is "Performance",in the Advanced tab 5- Select "Data Execution Prevention" tab 6-Turn off DEP for you application or Turn off for all application except Windows Programs and Services. 7-You have to restart the server. Here is the screen shut : cheers, P.S:Please do not hesitate to share your comments.

Windows Management Instrument Tester

Just run 'wbemtest' from Command Prompt. You can connect kind of domains to intearct with WMI. Ex: The majority of the WMI classes for management are in the root\cimv2 namespace you can run "Select * from Win32_OperatingSystem"statement over WMI with WQL type under the Query button.The result will be information about the operating system, such as version, whether it is activated, or which hotfixes are installed. good lucks, P.S:Please do not hesitate to share your comments.

search text in Stored Procedures

Do you want to find any text in Stored Procedures in SQL Server Database ? "select * from INFORMATION_SCHEMA.ROUTINES" returns Procedure,Function exist in specific database. You will see objects and details in columns. P.S:Please do not hesitate to share your comments.

Notes about Merge Replication

some usefull stored procedures you may use during merge replication; * - EXEC sp_adjustpublisheridentityrange @publication='Publication_Name' //adjust identity range,if you get any error related with identity renge , you can reset identity offset managed by agent * - EXEC sp_helpmergearticle @publication='Publication_Name' //retrieve article(s) information in given Publication_Name * - EXEC sp_changemergearticle @publication='Publication_Name', @article = 'Article_Name' , @Property = 'identityrangemanagementoption', //What would you like to do.ie disable identity management by agent @Value = 'Manual', @force_invalidate_snapshot = 0 //change article property ( http://msdn.microsoft.com/en-us/library/ms174386.aspx )
ERROR MESSAGE : The Publisher failed to allocate a new set of identity ranges for the subscription. This can occur when a Publisher or a republishing Subscriber has run out of identity ranges to allocate to its own Subscribers or when an identity column data type does not support an additional identity range allocation. If a republishing Subscriber has run out of identity ranges, synchronize the republishing Subscriber to obtain more identity ranges before restarting the synchronization. If a Publisher runs out of identit (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147199417) EXECUTE : sp_adjustpublisheridentityrange @publication='PUBLISHED_DATABASE_NAME' (ref : http://msdn.microsoft.com/en-us/library/ms181527.aspx )