Red Gate forums :: View topic - Different Results on Different Machines
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Search 2
SQL Search 2 forum

Different Results on Different Machines

Search in SQL Search 2 forum
Post new topic   Reply to topic
Jump to:  
Author Message
BPYMKJ



Joined: 19 Aug 2014
Posts: 3

PostPosted: Tue Aug 19, 2014 11:12 pm    Post subject: Different Results on Different Machines Reply with quote

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”
This returns results for me and my coworkers on other machines, but not on my current machine. I would like to get the same results on my current machine as on other machines.
I have checked many times that I am searching the exact string, database, and objects as on other machines, and I have looked at my permissions and cannot see any differences. When I do the exact search on another machine, it works. Other than this exact phrase, SQL Search appears to be working as normal.
I have tried the following:
1. Uninstall and reinstall SQL Search, reboot
2. Hit reindex when searching.
3. Delete all files in C:\Users\myUserName\AppData\Local\Red Gate\SQLSearch 2
4. Had a coworker log into my machine (searching the exact string did not work)
I am using Windows 7 and have both SQL Server 2005 and SQL Server 2008 R2 installed.
I really do not know what else I can try. Thank you in advance for any advice.
Back to top
View user's profile Send private message
Anu Deshpande



Joined: 20 Apr 2009
Posts: 692
Location: Cambridge

PostPosted: Fri Aug 22, 2014 2:38 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
BPYMKJ



Joined: 19 Aug 2014
Posts: 3

PostPosted: Sat Aug 30, 2014 5:30 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
BPYMKJ



Joined: 19 Aug 2014
Posts: 3

PostPosted: Sat Aug 30, 2014 5:32 pm    Post subject: Reply with quote

If you use SQL search to do an exact search for “INSERT dbo.Person” it will find it in the stored procedure using either SQL Search 1 or SQL Search 2. If you search for “INSERT dbo.Quick_Note” it will return no results in SQL Search 2. The pattern appears to be that SQL Search 2 will not find anything of the pattern “INSERT dbo.XXX_XXXX”.

I was only able to test SQL Search 1 at work. I have no idea how to safely download a program to open a .package file on Windows 8.1 ... I admit I may be missing a very easy step (http://www.red-gate.com/products/old-versions).

Thank you for the quick response, I really appreciate it.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group