Category: SQL Server 2008
Powershell issue with output characters changing to ?
On PowerShell command pipe to export CSV add Encoding Unicode if characters change to ? Credit: Idera execute xp_cmdshell ‘powershell
Sage EDI IN Intermediary Email
I have found users don’t always read the logs from the Adaptus EDI Module anymore in Sage Line 500. There
Use T-Sql to find triggers on specific database
Credit: Joe Stefanelli on Stack Overflow I wanted a simple way to find triggers on a specific database, Joe Stefanelli
SQL Server 2008 – Find which stored procedure is part of a scheduled
Find a stored procedure (or any text) inside a scheduled on on SQL Server 2008 and 2012 by querying the
Maintain MSDB email tables
Credits: SQL Server Central SQL Authority Microsoft Docs Microsoft Docs We recently had an issue where MSDB was growing very
Find processes which have been using tempdb
Credit: Microsoft TechNet On some occasions a few MS SQL databases have exhausted tempdb space, this was due to users
Sage Line 500 EDI IN Intermediary tables inner join on sql query
On ocassion I need to look at what is in the EDI IN modules intermediary tables, scheme.eiordtm has an annoying
Method of working out check digit for an SSCC code
Method of working out check digit for an SSCC shipping code in SQL on a system with Sage Line 500
Apply ALLOW_SNAPSHOT_ISOLATION and READ_COMMITTED_SNAPSHOT to SQL Server
We needed to enable ALLOW_SNAPSHOT_ISOLATION and READ_COMMITTED_SNAPSHOT to specific databases on a SQL Server 2008 instance, I found to do