No announcements
-
0 VotesFull 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 ...Unanswered | 2 Replies | 65 Views | Created by Yauheni Kroukin - Wednesday, February 20, 2019 5:23 PM | Last reply by Yauheni Kroukin - Thursday, February 21, 2019 3:45 PM
-
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 | 60 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 | 17702 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 | 224 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 | 282 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 | 335 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 | 338 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 | 447 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 | 483 Views | Created by Xavier03 - Thursday, November 8, 2018 9:41 AM | Last reply by Xavier03 - Friday, November 16, 2018 6:01 AM -
0 Votes
Full-Text search failing after importing data tier application
Hi, I am getting an error when trying to run a full text search on any database in SQL server Version: Microsoft SQL Server 2017 (RTM-GDR) (KB4293803) - ... -
0 Votes
One query is slow after reboot of server - have to "Rebuild All" indexes to make it fast again
My SQL query looks like this: SELECT imageProvider,count(*) AS 'rowcount' FROM tblImageInformation where lastUpdated < ...Answered | 2 Replies | 566 Views | Created by Hamann IQ - Monday, November 5, 2018 7:49 AM | Last reply by Hamann IQ - Wednesday, November 7, 2018 10:00 AM -
0 Votes
solidwarks error
The executable file "C:\Users\andre\OneDrive\Documents\SOLIDWORKS Downloads\SOLIDWORKS 2016 x64 SP02\PreReqs\SQLServer\SQLEXPR_x64_ENU.exe" ...Unanswered | 2 Replies | 470 Views | Created by omarherooo - Monday, November 5, 2018 12:40 PM | Last reply by Olaf Helper - Monday, November 5, 2018 1:18 PM -
0 Votes
Microsoft SQL Server 2016_SP2_13.0.5026.0 - Information on Support Date
Hello, I tried to seek information on Search Product Lifecycle interface and did not found information about Microsoft SQL Server 2016_SP2 ...Answered | 2 Replies | 531 Views | Created by Walt Corp - Tuesday, October 30, 2018 6:02 AM | Last reply by Walt Corp - Tuesday, October 30, 2018 9:05 AM -
0 Votes
Count based on dates
I am trying to get a count of the number of tickets based on ...Unanswered | 1 Replies | 493 Views | Created by Saikotha93 - Monday, October 22, 2018 8:13 PM | Last reply by A2605 - Monday, October 22, 2018 10:22 PM -
0 Votes
How to find replace characters like à  in a column
I have recently imported a database from a .xlsx file and I've found that several columns have character strings in them like 'ö' where I am expecting to expect to see 'ö'. I'm ...Unanswered | 1 Replies | 1035 Views | Created by Josh Repp - Tuesday, July 24, 2018 7:54 PM | Last reply by Kevin Urquhart - Wednesday, October 17, 2018 12:19 PM -
0 Votes
Database with Full-Text Catalog Restore
Hi. I seem to be missing the full-text files on my source (2005) database "myDB"after I backed it up and restored it to a couple different destinations for test ... -
1 Votes
Check Available Rooms
I have the following table in Sql Server 2017, Booking(Id, CustomerId, RoomId, ReservationDate, CheckInDate, CheckOutDate, Status, AccountId) Room(Id, ...Answered | 3 Replies | 673 Views | Created by RJ Evangelista - Saturday, September 29, 2018 9:36 PM | Last reply by Visakh16 - Sunday, September 30, 2018 8:20 AM -
0 Votes
Fulltext Search including brackets and full stop
I am trying to implement a solution that if for instance the database holds the following text "Carbon Dioxide 0.2M (2mml)" a user should be able to ...Unanswered | 1 Replies | 563 Views | Created by farahijahromi - Tuesday, September 25, 2018 3:49 AM | Last reply by Olaf Helper - Tuesday, September 25, 2018 5:48 AM - Items 1 to 20 of 1341 Next ›
No announcements
