Different Results on Different Machines

BPYMKJBPYMKJ Posts: 4
edited August 30, 2014 12:32PM in SQL Search
Hello,
I am having difficulty regarding SQL Search. I am trying to perform an exact search for a string with a space:
“insert dbo.MYTABLENAMEâ€

Comments

  • Anu DAnu D Posts: 876 Silver 3
    Thanks for your post!

    I have logged a support ticket for you and will email you soon.
    Anuradha Deshpande
    Product Support
    Redgate Software Ltd.
    E-mail: support@red-gate.com
  • 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
  • If you use SQL search to do an exact search for “INSERT dbo.Personâ€
Sign In or Register to comment.