Different Results on Different Machines

A free Management Studio add-in to search for SQL in your databases

Moderator: dom.smith

Different Results on Different Machines

Postby BPYMKJ » Tue Aug 19, 2014 11:12 pm

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â€
BPYMKJ
 
Posts: 3
Joined: Tue Aug 19, 2014 11:00 pm

Postby Anu Deshpande » Fri Aug 22, 2014 2:38 pm

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
Anu Deshpande
 
Posts: 692
Joined: Mon Apr 20, 2009 3:53 pm
Location: Cambridge

Postby BPYMKJ » Sat Aug 30, 2014 5:30 pm

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
 
Posts: 3
Joined: Tue Aug 19, 2014 11:00 pm

Postby BPYMKJ » Sat Aug 30, 2014 5:32 pm

If you use SQL search to do an exact search for “INSERT dbo.Personâ€
BPYMKJ
 
Posts: 3
Joined: Tue Aug 19, 2014 11:00 pm


Return to SQL Search 2

Who is online

Users browsing this forum: No registered users and 0 guests