locked
Search Engine RRS feed

  • Question

  • Is there a search engine for Microsoft SQL Server that way other employees can search for information and that way they won't have to access SSMS? I know there is read only permissions but I was  wondering if there was another alternative to that since I will be running the server. Thank you!
    Thursday, January 8, 2015 3:42 PM

Answers

All replies

  • What information you are referring to? Are you referring meta-data of the database or actual data?

    You can try querying the database from Powershell or SQLCMD utilities instead of connecting to SSMS.

    --Prashanth

    Thursday, January 8, 2015 4:32 PM
  • You would need a front end. The search engine that you require would primarily to search a particular column in a table - this is where full-text index will help you. So, first find what columns/tables your information lies and create a full-text index on those columns, then create a Stored Procedure which will run TSQL statements against these full-texted columns and use this Stored Procedure from the front end of your search engine. If it is not feasible to provide a front end, you can give execute permission to this Stored Procedure for the users to search.

    Satish Kartan www.sqlfood.com

    Thursday, January 8, 2015 5:15 PM
  • i am referring to actual data
    Thursday, January 8, 2015 5:20 PM
  • Actually we need to know :

    what type of data ? which version are you using ? what is your expectation ?

    If searching objectives is

    "in for SQL Server Management Studio that lets you quickly search for SQL across your databases." then

    SQL Search 

    ApexSQL Search tools


    Ahsan Kabir Please remember to click Mark as Answer and Vote as Helpful on posts that help you. This can be beneficial to other community members reading the thread. http://www.aktechforum.blogspot.com/

    Thursday, January 8, 2015 9:31 PM
  • I think my boss wants to get SQL Server 2012 or 2014 and he only wants me to run the database and he wants the  other employees to use the search engine. Would SQL Search allow the employees to search for any data they want without modifying it? 
    Friday, January 9, 2015 5:11 PM
  • There are many tools to read SQL Server databases other than SSMS.  MS Excel has built in tools as well as MS Query tools.

    https://support.office.com/en-ca/article/Read-an-article-e11a7a0f-4cea-491c-b6ac-2f4197c6af82

    Friday, January 9, 2015 6:21 PM
  • what would be the best suggestion in my case? Thank you! 

    Friday, January 9, 2015 7:56 PM
  • You can connect to SQL Server via sqlcmd utility

    http://msdn.microsoft.com/en-us/library/ms188247.aspx


    Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/

    MS SQL optimization: MS SQL Development and Optimization
    MS SQL Consulting: Large scale of database and data cleansing
    Remote DBA Services: Improves MS SQL Database Performance
    SQL Server Integration Services: Business Intelligence

    Sunday, January 11, 2015 7:48 AM