Different Results on Different Machines

• 
  Thanks for your post!
  
  I have logged a support ticket for you and will email you soon.

  Anu D August 22, 2014 09:38

  - 0 +
• 
  Here is how to reproduce my bug. You will need to create the following objects in a test database (I just used AdventureWorks for convenience).
  
  USE [AdventureWorks2012]
  GO
  
  SET ANSI_NULLS ON
  GO
  
  SET QUOTED_IDENTIFIER ON
  GO
  
  SET ANSI_PADDING ON
  GO
  
  CREATE TABLE [dbo].[Person](
  [person_id] [int] IDENTITY(1,1) NOT NULL,
  [first_name] [varchar](50) NOT NULL,
  [last_name] [varchar](50) NOT NULL,
  CONSTRAINT [PK_Person] PRIMARY KEY CLUSTERED
  (
  [person_id] ASC
  )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  ) ON [PRIMARY]
  
  GO
  
  SET ANSI_PADDING ON
  GO
  
  
  USE [AdventureWorks2012]
  GO
  
  SET ANSI_NULLS ON
  GO
  
  SET QUOTED_IDENTIFIER ON
  GO
  
  SET ANSI_PADDING ON
  GO
  
  CREATE TABLE [dbo].[Quick_Note](
  [quick_note_id] [int] IDENTITY(1,1) NOT NULL,
  [note] [varchar](255) NOT NULL,
  CONSTRAINT [PK_Quick_Note] PRIMARY KEY CLUSTERED
  (
  [quick_note_id] ASC
  )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  ) ON [PRIMARY]
  
  GO
  
  SET ANSI_PADDING ON
  GO
  
  
  USE [AdventureWorks2012]
  GO
  
  SET ANSI_NULLS ON
  GO
  
  SET QUOTED_IDENTIFIER ON
  GO
  
  
  CREATE PROCEDURE [dbo].[usp_Create_Person]
  @first_name VARCHAR(50),
  @last_name VARCHAR(50)
  AS
  BEGIN
  
  INSERT dbo.Person (first_name, last_name) VALUES (@first_name, @last_name)
  
  END
  
  GO
  
  
  USE [AdventureWorks2012]
  GO
  
  SET ANSI_NULLS ON
  GO
  
  SET QUOTED_IDENTIFIER ON
  GO
  
  
  CREATE PROCEDURE [dbo].[usp_Create_Quick_Note]
  @note VARCHAR(255)
  AS
  BEGIN
  
  INSERT dbo.Quick_Note (note) VALUES (@note)
  
  END
  
  GO

  BPYMKJ August 30, 2014 12:30

  - 0 +
• 
  If you use SQL search to do an exact search for “INSERT dbo.Personâ€

  BPYMKJ August 30, 2014 12:32

  - 0 +

Add comment

Please sign in to leave a comment.