Scripts to manage Active Directory Users Appending a Multi-Valued Attribute Appending a Phone Number Adding a Route to the Dial-In Properties of a User Account Adding a User to Two Security Groups Appending Address Page Information for a User Account…
How to fix broken permalinks in wordpress. Fixes blank pages and non-working links. My problem was that links like this would work: but links like this would not: Basically i thought the apache mod rewrite rule was working,…
Error: Messages: Failed to Get Projects Properties; Failed to get projects properties; Failed to save projects properties; Cannot build directory item for key ‘…… …….. [Mercury][SQLServer JDBC Driver][SQLServer]Server user ‘td’ is not a valid user in database If this is…
Need to print a windows directory? Here’s how: 1. Open up notepad 2. paste this text in Windows Registry Editor Version 5.00 [HKEY_CLASSES_ROOT\Directory\shell\printdir] @=”Print Directory” [HKEY_CLASSES_ROOT\Directory\shell\printdir\command] @=hex(2):25,00,77,00,69,00,6e,00,64,00,69,00,72,00,25,00,5c,00,70,00,72,00,69,\ 00,6e,00,74,00,64,00,69,00,72,00,2e,00,62,00,61,00,74,00,20,00,22,00,25,00,\ 31,00,22,00,00,00 3. Save file as printdir.reg 4. Open up a new notepad…
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…
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…
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)
