No announcements
-
0 VotesSqlcmd: 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 | 11105 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 | 1047 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 | 701 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 | 789 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 | 725 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 | 18353 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 | 858 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 | 917 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 | 963 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 | 982 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 | 1103 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 | 1111 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 | 1266 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 | 1148 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 | 1198 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 | 1150 Views | Created by Saikotha93 - Monday, October 22, 2018 8:13 PM | Last reply by A2605 - Monday, October 22, 2018 10:22 PM - Items 1 to 20 of 1344 Next ›
No announcements
