Skip to content

Instantly share code, notes, and snippets.

@kappa7194

kappa7194/cerca-errori.sql

Created December 12, 2011 11:22
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save kappa7194/1466698 to your computer and use it in GitHub Desktop.
Save kappa7194/1466698 to your computer and use it in GitHub Desktop.
Download ZIP
Cerca errori
Raw
cerca-errori.sql
set nocount on
set statistics io on
set transaction isolation level read uncommitted
dbcc dropcleanbuffers
dbcc freeproccache
select
a.IdErrore
, a.Data
, Url = lower(substring(a.Url, charindex('/', a.Url, 8), len(a.Url)))
, a.[Description]
, [File] = lower(a.[File])
, a.Line
from
dbo.Errori a
where
contains(a.Url, 'tracking or management')
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment