How to fix Failed to determine structure in TD Tables Struct Dir; [Mercury][SQLServer JDBC Driver][SQLServer]Invalid object name ‘SEQUENCES’. This error may occur with Mercury Quality Center 9.0 if you move a project between databases. The fix: 1. Detach the database…
How to resolve this error: [Mercury][SQLServer JDBC Driver][SQLServer]SELECT permission denied on object ‘USERS’, database ‘qcsiteadmin_db’, owner ‘dbo’.; Stack Trace: java.sql.SQLException: [Mercury][SQLServer JDBC Driver][SQLServer]SELECT permission denied on object ‘USERS’, database ‘qcsiteadmin_db’, owner ‘dbo’. at com.mercury.jdbc.base.BaseExceptions.createException(Unknown Source) at com.mercury.jdbc.base.BaseExceptions.getException(Unknown Source) The reason…
To create a new service in server 2003 or xp you use the sc.exe tool. REMEMBER TO ADD A SPACE AFTER EVERY EQUAL SIGN!!!! THIS IS VERY IMPORTANT! sc create “my service” binPath= “c:\myfile.exe” type= “own” start= “auto” DisplayName= “my…
I had a need to write a .txt file with build details for every build (windows). This involves using environmental variables and executing a windows batch command. Create c:\buildinfo.bat @echo off echo Build number: %1 echo BUILD_ID: %2 echo JOB_NAME:…
Problem: How can I receive an email when the Redmine admin list changes or a project is changed to publicly viewable? You will need to run some mysql commands / queries in windows batch mode. Solution: Download blat and place…
Need to connect to a windows share from Mac OS X Leopard or Snow Leopard? Here’s how to.. 1. Open Finder 2. Menu “Go” -> “Connect to Server” 3. Type in smb://[ip_of_windows_share]/[sharename] 4. Click “connect” 5. When prompted for authentication…
Howto: check database fragmentation sql server How to find all indexes that have fragmentation over 25%: select * FROM sys.dm_db_index_physical_stats (NULL, NULL, NULL , NULL, ‘LIMITED’) WHERE avg_fragmentation_in_percent > 25.0 AND index_id > 0 AND page_count > 1000 order by…
First off, You CANNOT REVERT this command, so be sure you want to truncate the log! THE QUERY Instructions: Just replace with your DB BACKUP LOG WITH TRUNCATE_ONLY DBCC SHRINKDATABASE( ”, TRUNCATEONLY)
Howto: Compare two files using freeware or open source Diffmerge is my favorite program (open source at least) that I use to compare files. From their website: DiffMerge is an application to visually compare and merge files for Windows, Mac…
How to clear your flash cache To clear specific sites: When you click on the link, you are taken to the adobe site. On the right hand side of the frame, there is a box that will display a…
