No announcements
-
0 VotesRestoring a database by impersonating the sysadmin privilege
Dear All, In our environment we are getting frequent request for DB restoration, hence we want to automate this process and handover to our application team with minimal privilege. ...
-
1 Votes
Contains Predicate behavior
Hi Team, I am using Contains predicate along with full text catalog. SELECT * FROM sys.dm_fts_parser(N'"CM 2.1.7 Change cage & rack - Ger"', 1033, ...Unanswered | 1 Replies | 106 Views | Created by Rushyendra.P - Thursday, May 03, 2018 2:55 PM | Last reply by Rushyendra.P - Wednesday, May 23, 2018 6:40 AM -
0 Votes
How to search this kind of data efficiently?
Nowadays we have database and file system to store the data. If we store some json object in database, how can we search the json string efficiently in sql server? I know if we export the data to .NET ...Unanswered | 3 Replies | 130 Views | Created by John Smith 88 - Friday, April 27, 2018 12:01 PM | Last reply by Visakh16 - Friday, April 27, 2018 1:43 PM -
0 Votes
Search in the article using keyword
dear friends, I have a question, can I search in the article ? I have a keyword 1 "Andi" and keyword 2 "Sudarman" how can I ...Unanswered | 7 Replies | 140 Views | Created by steve_henry - Tuesday, April 17, 2018 7:11 AM | Last reply by Visakh16 - Tuesday, April 17, 2018 8:27 AM -
0 Votes
Search in the article using keyword without using Like (another faster way)
dear friends, I have a question, can I search in the article ? I have a keyword 1 "Andi" and keyword 2 ...Unanswered | 2 Replies | 126 Views | Created by steve_henry - Tuesday, April 17, 2018 7:29 AM | Last reply by Soumen Barua - Tuesday, April 17, 2018 8:10 AM -
0 Votes
Full Text Search always get an error after upload data from excel
Hy Friends I have a problem, why my SQL Got an error after I finished upload the data to SQL Server from excel when I try to search using Full text, the SQL ... -
0 Votes
Seraching for GUID in database
0 SELECT @TableParamSQL = 'SELECT ''' + REPLACE(@Tablenames,',','''as TblName UNION SELECT ''') + '''' ELSE SELECT @TableParamSQL = ...Answered | 2 Replies | 156 Views | Created by jaytaba - Wednesday, April 11, 2018 8:00 PM | Last reply by jaytaba - Wednesday, April 11, 2018 11:32 PM -
0 Votes
How to get multiple columns with the same header but different information
Hello, I am trying to create a query with individual card readers, but showing two different events and the counts for each event. I am wondering if it is ...Unanswered | 2 Replies | 258 Views | Created by MarcinVA - Wednesday, March 07, 2018 2:46 PM | Last reply by Visakh16 - Wednesday, April 11, 2018 5:34 AM -
0 Votes
Full Text Search - Change Tracking
Hi there, We have installed Full text search service to sql server express + advanced services 2017. Added some full text indexes with change tracking auto and started full ... -
0 Votes
SQL Server Full-text indexes : way to search for numbers with leading zeros
Hello All, My Greetings for the day!!! Reference to Full Text Index in my company on SQL Server 2012 : We have table with a summary ...Unanswered | 4 Replies | 375 Views | Created by contacthirenparikh - Friday, April 06, 2018 10:07 PM | Last reply by contacthirenparikh - Sunday, April 08, 2018 9:01 PM -
2 Votes
scan databases and find the table that was last used
We have a sql server box right and that sql server box has many databases. NOw i have been given a task where they say that i need to scan all the databases and list all the tables that were last ...Answered | 7 Replies | 13516 Views | Created by Jack Nolan - Thursday, February 17, 2011 4:49 PM | Last reply by Wuf_fang - Thursday, April 05, 2018 9:48 PM -
0 Votes
How do I change the level of logging by the full-text crawler process?
We have an application that makes use of SQL Server full text index on a group of tables that are updated on a regular basis. The full text catalog is configured to populate ...Unanswered | 2 Replies | 6121 Views | Created by JohnMcLusky - Thursday, August 13, 2009 1:14 PM | Last reply by Jinu Varghese - Sunday, April 01, 2018 5:34 AM -
0 Votes
Full Text Index : Prefix words
Hello All, My Greetings for the day!!! I have implemented full text index in my table. Below is the sample data While Try ...Unanswered | 0 Replies | 164 Views | Created by contacthirenparikh - Thursday, March 29, 2018 12:40 PM -
0 Votes
Azure SQL Full Text Search with .AIB file ?
Hello Team, I have Azure SQL database with tables which file data stored in varbinary. I have stored Azure Media Service Indexer output file extension like ...Unanswered | 1 Replies | 271 Views | Created by Atul Thummar - Tuesday, March 06, 2018 7:03 AM | Last reply by Atul Thummar - Thursday, March 08, 2018 8:48 AM -
0 Votes
Generating attendance report in SQL where user id is given
I am generating an attendance report in <g class="gr_ gr_11 gr-alert gr_spell gr_inline_cards gr_run_anim ContextualSpelling ins-del multiReplace" data-gr-id="11" ...Unanswered | 1 Replies | 311 Views | Created by SaShaBha - Sunday, February 25, 2018 9:40 AM | Last reply by Ousama EL HOR - Monday, February 26, 2018 4:37 PM -
0 Votes
Office 2010 IFilter support for SQL Server 2016 on Server 2016?
I am wanting docx and pdf support for the full text index in SQL Server 2016 (running on Server 2016). After much searching, it appears the latest ifilter pack is the Office 2010 ... -
0 Votes
How to search for the particular pattern from the table?
Hi Team, I have a table with the rules on short description .If that rule is available in my input data I need to perform different actions (i.e. escalate / close) ...Answered | 1 Replies | 298 Views | Created by AtyamVijaya - Thursday, February 22, 2018 2:52 AM | Last reply by Amit-Tomar - Thursday, February 22, 2018 6:38 AM -
0 Votes
Sql Server Licensing
ODBC connection(OS built-in component) vs SQL client - is the CAL license is same or differentSharepoint server connecting to SQL with service account and when multiple users are ...Unanswered | 1 Replies | 283 Views | Created by Sreevishnu Katari - Wednesday, February 21, 2018 1:53 PM | Last reply by Olaf Helper - Wednesday, February 21, 2018 2:13 PM -
0 Votes
How to generate a monthly attendance report for students.
I have a table MarkA whose fields are User_Id(Bigint),Date(Date),Time(Time),Status(<g class="gr_ gr_42 gr-alert gr_spell gr_inline_cards gr_run_anim ContextualSpelling ins-del ...Unanswered | 13 Replies | 425 Views | Created by SaShaBha - Monday, February 19, 2018 12:15 PM | Last reply by Guoxiong - Monday, February 19, 2018 5:16 PM -
0 Votes
"Full-Text Search" doesn't return any record from table, where pdf file stored with varbinary(max)
I tried my best to implement "full text search" for pdf files. When I search keyword from *.pdf file which is inserted on my "article" table having column "content" ...Answered | 5 Replies | 1361 Views | Created by Sameer Mahat - Wednesday, May 24, 2017 10:55 AM | Last reply by Sameer Mahat - Monday, February 19, 2018 7:14 AM - Items 1 to 20 of 1306 Next ›
No announcements
