Viewing 4 posts - 1 through 4 (of 4 total)
Script is really helpfull, after some changes it is running now also on case sensitive servers and several times in the same wquery(added drop before create table)
USE master
GO
SET NOCOUNT ON;
/*...
February 11, 2015 at 3:49 am
I mean the difference of Orderid and OrderID, case sensitive systems think, that there are 2 different variables.
October 16, 2014 at 2:06 am
After correcting the spelling mistakes ( if you run this query on a case sensitive instance) you will receive 2 rows!
October 16, 2014 at 12:44 am
This updated script runs also on a case sensible SQL 2014 version:
USE [master]
GO
if exists(select 1 from sys.sysobjects where name=N'InstanceAnalysis_PerformanceBaseLine' and type=N'P')
begin
Drop procedure [dbo].[InstanceAnalysis_PerformanceBaseLine]
end
/****** Object: StoredProcedure [dbo].[InstanceAnalysis_PerformanceBaseLine] ...
September 24, 2014 at 4:27 am
Viewing 4 posts - 1 through 4 (of 4 total)