Sunday, March 1, 2020
Friday, September 7, 2018
Saturday, September 9, 2017
Query to Identify Primary Table is being used as Reference in which Tables in the SQL Database
Just write down the PrimaryTableName
and execute below query.
SELECT OBJECT_NAME (FK.referenced_object_id) 'Referenced Table' , OBJECT_NAME(FK.parent_object_ 'Referring Table' , FK. name 'Foreign Key' , COL_NAME(FK.referenced_ FKC.referenced_column_id) 'Referenced Column' , COL_NAME(FK.parent_object_id, 'Referring Column' FROM sys.foreign_keys AS FK INNER JOIN sys.foreign_key_columns AS FKC ON FKC.constraint_object_id = FK.OBJECT_ID WHERE OBJECT_NAME (FK.referenced_object_id) = ' PrimaryTableName '
If you want to check multiple Primary Table then just replace OBJECT_NAME (FK.referenced_object_id) = ' PrimaryTableName ' by OBJECT_NAME (FK.referenced_object_id) in ( ' PrimaryTable1 ',' PrimaryTable2','PrimaryTable2')
|
Wednesday, January 14, 2015
Simple solution for Crystal Report SP12 with Visual Studio 2013 on 64 bit OS
First of all, many many thanks to Don Williams (http://scn.sap.com/people/don.williams)
Issue:
Issue:
An unhandled exception of type 'System.IO.FileNotFoundException' occurred in mscorlib.dll
Additional information: Could not load file or assembly 'file:///C:\Program Files (x86)\SAP BusinessObjects\Crystal Reports for .NET Framework 4.0\Common\SAP BusinessObjects Enterprise XI 4.0\win32_x86\dotnet1\crdb_adoplus.dll' or one of its dependencies. The system cannot find the file specified.
Solution:
Simply add useLegacyV2RuntimeActivationPolicy="true" in startup tag in app.config file.
example: <startup useLegacyV2RuntimeActivationPolicy="true">
Labels:
#tomamuns,
64 bit,
CR,
Crystal Report,
mysql,
Technology,
Visual Studio,
VS 2013
Thursday, January 8, 2015
Use Crystal Report SP12 for Visual Studio 2013, SP11 has regression issues
SAP has announced through their website regarding the regression issues in SP11.
SP9 or higher is required to integrate "SAP Crystal Reports development version" for Visual Studio 2013
download link: Crystal Report (version SP12) for Visual Studio 2013
Monday, August 11, 2014
Error 10061 or 1067 when starting MySQL Service
Steps to mitigate…
1. stop the MySQL service
2. Delete both ib_logfile0 and ib_logfile1
3. restart MySQL service
both the files ib_logfile0 & ib_logfile1 are loated in MySQL data folder…
This is just work-around solution, assuming there are no databases uisng InnoDB engine.
Otherwise, those databases will not work. Please take proper backup/sql dump before applying above procedure.
This is just work-around solution, assuming there are no databases uisng InnoDB engine.
Otherwise, those databases will not work. Please take proper backup/sql dump before applying above procedure.
Subscribe to:
Posts (Atom)