No announcements
-
0 VotesFull-Text Index have limit number of rows
In below link, there are "There are other failures that can impact the indexing process itself and prevent the population from completing:" phrase. In that ...Unanswered | 1 Replies | 142 Views | Created by Adele Vance - Wednesday, June 5, 2019 9:19 AM | Last reply by Comeau P - Thursday, June 6, 2019 7:57 PM
-
0 Votes
Does registry path to get instance of sql server constant for all versions? Path : @'SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names\SQL' ?
I am thinking to use following path to check instance for all sql server version (From SQL server 2005 - SQL Server 2017) Path : @'SOFTWARE\Microsoft\Microsoft SQL Server\Instance ...Unanswered | 2 Replies | 242 Views | Created by AngelVpd - Friday, May 24, 2019 8:58 AM | Last reply by Hari VS_Kid - Tuesday, June 4, 2019 8:40 AM -
0 Votes
Fast searching via sqlserver stored procuedure
Hi friends, Following sqlserver 2012 stored procedure I am calling from vb.net which is used for product searching by code and by name ...Answered | 3 Replies | 149 Views | Created by malikasad - Thursday, May 30, 2019 10:32 AM | Last reply by scott_morris-ga - Thursday, May 30, 2019 2:45 PM -
0 Votes
How can I have a clustered key index on an id field that is'nt unique?
Hi! I'm kind of new to sql server so this probably sounds like a stupid question to you who been in the game for a while. I understand that if you make one ...Unanswered | 3 Replies | 375 Views | Created by wenzzzel - Saturday, May 18, 2019 3:10 PM | Last reply by wenzzzel - Saturday, May 18, 2019 8:34 PM -
2 Votes
SSRS Matrix Sort Order
Hi, Could you please help me to display the data as per the SQL Query Result in a SSRS Matrix Report. I have tried deleting the sort order from the group ...Unanswered | 9 Replies | 447 Views | Created by Mohammad Afshaan Shaikh - Thursday, April 25, 2019 6:36 AM | Last reply by Mohammad Afshaan Shaikh - Tuesday, April 30, 2019 8:50 AM -
0 Votes
Sqlcmd: Error: Microsoft SQL Server Native Client 10.0
Hi All .need help .. When I am running this from cmd on my sql 2008 database server: sqlcmd -U sa -S mymachinen_name\MSSQLSERVER , ...Answered | 3 Replies | 11676 Views | Created by rickepm_ms - Sunday, February 22, 2015 3:36 PM | Last reply by mojie379120 - Tuesday, April 23, 2019 5:55 AM -
0 Votes
SQL Sever Query
Hi, i am trying to retrive required data from the below ...Unanswered | 3 Replies | 1325 Views | Created by Mohammad Afshaan Shaikh - Wednesday, April 17, 2019 10:13 AM | Last reply by Dedmon Dai - Monday, April 22, 2019 1:33 AM -
0 Votes
No results of SQL Full-Text Search
Welcome, I have a problem with results of searching by using SQL Full-Text Search. The FTS engine not finding the phrase ... -
1 Votes
Best and simple way to know,who created/dropped/altered the database?
Hello What is simple and easiest way to know,who created/dropped/altered the database? Thanks in advance.Answered | 3 Replies | 966 Views | Created by Irfankhan1995 - Sunday, March 17, 2019 4:42 AM | Last reply by scott_morris-ga - Sunday, March 17, 2019 12:34 PM -
0 Votes
Full text search and 3 character ISO 4217 Currency Codes
Hey there, faced with behavior of SQL Server full-text search which is not clear for me. Will try to explain use case. Imagine that I have a column in ...Answered | 3 Replies | 1017 Views | Created by Yauheni Kroukin - Wednesday, February 20, 2019 5:23 PM | Last reply by Yauheni Kroukin - Tuesday, March 5, 2019 9:25 AM -
0 Votes
SQL 2008 R2 Evaluation Version Download
Hi I need SQL 2008 R2 with SP3 ,Evaluation Version for my lab environment but unable to find it on the microsoft site. Could anyone help ...Unanswered | 1 Replies | 925 Views | Created by Sen Dhil - Tuesday, February 19, 2019 6:38 AM | Last reply by Olaf Helper - Tuesday, February 19, 2019 6:54 AM -
0 Votes
MSSQL support breaking with latest brew
Steps to setup MSSQL in MacOS would be to, brew install unixodbc brew install freetds --with--unixodbc (Installs freetds along with unixodbc ... -
0 Votes
FREETEXTTABLE bad results containing line break
Found a very strange behavior with FREETEXTTABLE which I believe is a bug. Essentially if there is a Line Break (line feed or carriage return - doesn't matter) it radically changes the rank given to ... -
3 Votes
Full Text problem indexing .eml files in SQL Server 2008
Hi, I have a database that will store a table consisting of email files in a VARBINARY(MAX) data type. In SQL Server 2005 (9.0.4053) I have had no problems. However, in ...Unanswered | 8 Replies | 18621 Views | Created by RJL61 - Wednesday, March 3, 2010 11:44 PM | Last reply by Lastdim - Wednesday, January 23, 2019 3:30 PM -
0 Votes
Error message
Lately, when trying to login to a particular Web page I get the following error message. Can someone help? Thanks. A Database Error Occurred Error ...Unanswered | 1 Replies | 1088 Views | Created by GaryPetersen - Wednesday, January 16, 2019 2:33 PM | Last reply by Av111 - Wednesday, January 16, 2019 2:41 PM -
0 Votes
Question about licensing
We purchase MSSQL 2012 enterprise in 2012 but installed MSSQL 2008 Enterprise. We now need to upgrade to 2012. Do we need to pay again or are we good?Unanswered | 1 Replies | 1168 Views | Created by Doug Lesser - Wednesday, January 9, 2019 9:18 PM | Last reply by Olaf Helper - Thursday, January 10, 2019 7:14 AM -
0 Votes
Separate data in column Status INTIME and OUTTIME wise into two columns
I have data in column now i want to separat it status wise one col Status(1)IN and ...Unanswered | 2 Replies | 1197 Views | Created by Akhterhussain - Tuesday, December 18, 2018 2:52 AM | Last reply by Visakh16 - Wednesday, December 19, 2018 2:19 PM -
0 Votes
Does a view automatic adapts the datatype of the "sub-tables" when this is changed?
I have a view created with the statement below. The view is just an example to illustrate my question. The view is named vMy2View and contains a UNION of 3 ...Answered | 5 Replies | 1205 Views | Created by Hamann IQ - Thursday, December 6, 2018 9:36 AM | Last reply by Hamann IQ - Thursday, December 6, 2018 10:17 AM -
1 Votes
Searching for a SQL Server Database by name
Hello! I'm trying to locate a SQL Server Database within our infrastructure to try and resolve an issue which we are receiving email notifications/alarms ...Answered | 2 Replies | 1334 Views | Created by AndyBeds1 - Monday, November 19, 2018 4:37 PM | Last reply by AndyBeds1 - Friday, November 23, 2018 1:19 PM -
1 Votes
A table having two columns with same name
Hi, I have an issue in SQL. Wherein, I want to select a desired column from the table. But, there are two columns with that name. For eg. ...Answered | 4 Replies | 1372 Views | Created by Xavier03 - Thursday, November 8, 2018 9:41 AM | Last reply by Xavier03 - Friday, November 16, 2018 6:01 AM - Items 1 to 20 of 1349 Next ›
No announcements
