Different Results on Different Machines

BPYMKJ

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â€

Anu D

Thanks for your post!

I have logged a support ticket for you and will email you soon.

BPYMKJ

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

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