Skip to content

Instantly share code, notes, and snippets.

View swaters86's full-sized avatar
🏠
Kicking ass and taking names

Steve Waters swaters86

🏠
Kicking ass and taking names
3 followers · 2 following
View GitHub Profile
@swaters86
swaters86 / SearchAllTables.sql
Created July 14, 2015 14:23
USE [ChangeGear]
GO
/****** Object: StoredProcedure [dbo].[SearchAllTables] Script Date: 07/14/2015 10:22:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROC [dbo].[SearchAllTables]
(
@SearchStr nvarchar(100)
@swaters86
swaters86 / ChangeGearError2
Created July 14, 2015 13:51
2015-07-14 06:20:42,215 | ERROR | DevExpress.Xpo.DB.Exceptions.UnableToCreateDBObjectException: Unable to create 'ForeignKey' 'FK_CG_Flex1Ticket_UDF_ForwardEmail'. Parent: 'CG_Flex1Ticket'. Error: Executing Sql 'alter table "dbo"."CG_Flex1Ticket" add constraint "FK_CG_Flex1Ticket_UDF_ForwardEmail" foreign key ("UDF_ForwardEmail") references "dbo"."CG_Principal"("OID") NOT FOR REPLICATION' with parameters '' exception 'System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'FK_CG_Flex1Ticket_UDF_ForwardEmail' in the database.
Could not create constraint. See previous errors.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at S
@swaters86
swaters86 / ChangeGearError
Created July 13, 2015 20:43
2015-07-13 12:48:43,009 | ERROR | DevExpress.Xpo.DB.Exceptions.UnableToCreateDBObjectException: Unable to create 'ForeignKey' 'FK_CG_Flex1Ticket_UDF_ForwardEmail'. Parent: 'CG_Flex1Ticket'. Error: Executing Sql 'alter table "dbo"."CG_Flex1Ticket" add constraint "FK_CG_Flex1Ticket_UDF_ForwardEmail" foreign key ("UDF_ForwardEmail") references "dbo"."CG_Principal"("OID") NOT FOR REPLICATION' with parameters '' exception 'System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'FK_CG_Flex1Ticket_UDF_ForwardEmail' in the database.
Could not create constraint. See previous errors.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at S
@swaters86
swaters86 / CGServiceLog.txt
Created March 24, 2015 18:33
2015-03-10 16:20:54,473 | ERROR | System.InvalidOperationException: Cross-thread operation detected. 'XPOPersistenceService.XPOSession(24227)' is not a thread-safe object, please avoid using it simultaneously from different threads
at DevExpress.Xpo.Helpers.SessionStateStack.Enter(Session session, SessionState newState)
at DevExpress.Xpo.Helpers.ObjectCollectionLoader.LoadObjects(ObjectsQuery[] queries)
at DevExpress.Xpo.SimpleObjectLayer.LoadObjects(Session session, ObjectsQuery[] queries)
at DevExpress.Xpo.SimpleObjectLayer.GetObjectsByKey(Session session, ObjectsByKeyQuery[] queries)
at DevExpress.Xpo.Session.GetObjectByKey(XPClassInfo classInfo, Object id, Boolean alwaysGetFromDb)
at DevExpress.Xpo.Session.GetObjectByKey(Type classType, Object id, Boolean alwaysGetFromDb)
at XPOPersistenceService.XPOPersistenceManager.GetObjectForEdit(IUserSession uSession, IUnitOfWork unitOfWork, Type entityType, Int32 key)
at ApplicationServices.EntityHandlers.EntityHandler.GetObjectForEdit(IUser
@swaters86
swaters86 / cgservice.log
Created March 19, 2015 15:31
2015-03-17 15:22:47,045 | ERROR | Could not get object from DB.
System.InvalidOperationException: Cross-thread operation detected. 'XPOPersistenceService.XPOSession(95269)' is not a thread-safe object, please avoid using it simultaneously from different threads
at DevExpress.Xpo.Helpers.SessionStateStack.Enter(Session session, SessionState newState)
at DevExpress.Xpo.Helpers.ObjectCollectionLoader.LoadObjects(ObjectsQuery[] queries)
at DevExpress.Xpo.SimpleObjectLayer.LoadObjects(Session session, ObjectsQuery[] queries)
at DevExpress.Xpo.SimpleObjectLayer.GetObjectsByKey(Session session, ObjectsByKeyQuery[] queries)
at DevExpress.Xpo.Session.GetObjectByKey(XPClassInfo classInfo, Object id, Boolean alwaysGetFromDb)
at DevExpress.Xpo.Session.GetObjectByKey(Type classType, Object id, Boolean alwaysGetFromDb)
at XPOPersistenceService.XPOPersistenceManager.GetObjectFromDB(IUserSession usrSession, IUnitOfWork unitOfWork, Type type, Int32 key)
2015-03-17 15:22:48,465 | ERROR | Could not get obje
@swaters86
swaters86 / cpuusage
Created March 5, 2015 13:29
SQL Server Process CPU Utilization System Idle Process Other Process CPU Utilization Event Time
47 49 4 2015-03-05 08:28:19.993
50 44 6 2015-03-05 08:27:19.993
5 88 7 2015-03-05 08:26:19.990
4 91 5 2015-03-05 08:25:19.983
4 91 5 2015-03-05 08:24:19.983
4 91 5 2015-03-05 08:23:19.983
3 92 5 2015-03-05 08:22:19.983
3 93 4 2015-03-05 08:21:19.983
3 93 4 2015-03-05 08:20:19.983
@swaters86
swaters86 / dateline_formatter.sql
Last active August 29, 2015 14:16
/*
select *
from web.dbo.Artikkler_tekst (nolock)
where Avis='la' and Lopenr='150309826' and Dato='20150303' and blokk=1
*/
/* Declare Site Code Variable */
declare @ASite varchar(2)
@swaters86
swaters86 / siteidentificationscript.js
Last active August 29, 2015 14:16
// ==UserScript==
// @name Display Site Information
// @namespace DSI
// @description Overlays Infomration on Website
// @include http://*.dailynews.com/*
// @include http://*.presstelegram.com/*
// @include http://*.sgvtribune.com/*
// @include http://*.pasadenastarnews.com/*
// @include http://*.whittierdailynews.com/*
// @include http://*.dailybulletin.com/*
@swaters86
swaters86 / nav.sql
Created February 23, 2015 21:42
/*sports*/
select top 200 t.Profile_ID, t.Name, t.Parent_id, case when exists (select p.avis from web.dbo.profile p (nolock) where p.Avis = t.Avis and p.Parent_id = t.Profile_id) then 1 else 0 end as Children, case when IsNull(relp.url , '') <> '' then relp.url else IsNull(t.URL, '') end as URL, case when IsNull(relp.TargetURL , '') <> '' then relp.TargetURL else IsNull(t.TargetURL, '') end as TargetURL, case when ISNULL(relp.TargetCategory, '') <> '' then relp.TargetCategory else IsNull(t.TargetCategory, '') end as TargetCategory, web.dbo.fGetProfileLevel('GA','1875') as Sublevel from web.dbo.Profile t (nolock) left join webextras.dbo.profile_extrafields ext (nolock) on (ext.Avis=t.Avis and ext.ProfileID=t.profile_id and ext.Varname='ProfileIDRef') left join web.dbo.profile relp (nolock) on (relp.Avis=t.Avis and relp.profile_id=cast(ext.VarValue as int)) where t.Avis = 'GA' and t.Profile_ID > 0 and t.Parent_ID = '1875' and t.Profile_ID NOT IN (SELECT [ProfileID] FROM
@swaters86
swaters86 / sampleoutput.txt
Created February 16, 2015 20:36
CCE Objects Deleted
===========================================
Site GUID
-------------------------------------------
An error has occurred! #8134
Divide by zero error encountered.
DL 55D76001-50DD-4DB4-920E-56067E51A351
An error has occurred! #8134
Divide by zero error encountered.