This post thanks to the caveman blog! All hail the caveman blog! SQL Server: How to add an identity column to a table with data. This article demonstrates a step-by step procedure about how an identity column an be added to…
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…
Add Public SSH Key to Remote Server in a Single Command From HowToGeek If you want to setup SSH keys to allow logging in without a password, you can do so with a single command. The first thing you’ll need…
How can you delete temporary internet files and ignore index.dat in c# ? (this refers to C:\Documents and Settings\%username%\Local Settings\Temporary Internet Files\ ) System.Diagnostics.Process.Start(“rundll32.exe”, “InetCpl.cpl,ClearMyTracksByProcess 4351”); // Delete All – Also delete files and settings stored by add-ons parameters that can…
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…
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…
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…
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…
