When working with larger SQL Server databases that contain thousands of objects, finding a particular one can be a difficult and time-consuming task. Likewise, when working with an unfamiliar database, it can be hard to locate specific keywords and snippets of SQL code. Microsoft's SQL Server (SSMS) software doesn't offer the powerful and deep search capabilities that are built into Redgate SQL Search, a free add-in for SSMS. Redgate SQL Search enables DBAs to find all the references to a database object in a SQL Server system and quickly navigate to that object.

• Redgate Sql Search Not Working

To make that happen, Redgate SQL Search can be used to look for or text comments within tables, stored procedures, functions, views and other database objects.

Redgate Sql Search Not Working

I am using SQL Compare Red Gate Red Gate to make comparisons between 2 DBs on 2 different SQL Servers. For this, I have created a SSIS package which encompasses an Execute Process Task. I have passed following as an Executable: C: Program Files (x86) Red Gate SQL Compare 10 SQLCompare.exe and as an argument: sqlcompare /Server1: 'serverip ' /Database1: 'dbname ' /Username1: 'userid ' /Password1: 'password ' /MakeSnapshot: 'E: Folder AUDITserver1.snp ' This Execute Process Task is to create a.snp file of server 1 and to compare it with server 2. This used to work fine before. Bagas reloader. However, recently, I have upgraded SQL Server 1 from 2012 to 2016. I have also re-created a linked server connection for Server 1 on the server where the comparison package is being run.

However, I am getting an error. The description is: Execute Process Task Error: In Executing 'C: Program Files (x86) Red Gate SQL Compare 10 SQLCompare.exe' ' sqlcompare /Server1: 'serverip ' /Database1: 'dbname ' /Username1: 'userid ' /Password1: 'password ' /MakeSnapshot: 'E: Folder AUDITserver1.snp' at ', The process exit code was '70' while the expected was '0'. I tried running it via command prompt as follows: cd C: Program Files (x86) Red Gate SQL Compare 10 sqlcompare /Server1: 'serverip ' /Database1: 'dbname ' /Username1: 'userid ' /Password1: 'password ' /MakeSnapshot: 'E: Folder AUDITserver1.snp ' /Options:CaseSensitiveObjectDefinition And now facing an error as follows: Unexpected error: A duplicate object name has been found. This may occur if the SQL Server that you are registering is case sensitive but the case sensitive option is not set. Closed as off-topic by, Oct 27 '17 at 14:14 This question appears to be off-topic. The users who voted to close gave this specific reason:. ' Too localized - this could be because your code has a typo, basic error, or is not relevant to most of our audience.

Consider revising your question so that it appeals to a broader audience. As it stands, the question is unlikely to help other users (regarding typo questions, see for background).' – Mikael Eriksson, McNets, Mike Walsh, Mr.Brownstone If this question can be reworded to fit the rules in the, please.