No announcements
-
1 VotesHow to Compare two nvarchar datatype values?
Hi All, This is sriram.I need help from you.In one of my stored procedure I have to compare two nvarchar datatype values.The values containing both numerical and ...Answered | 2 Replies | 24751 Views | Created by SriramJitendra - Wednesday, December 1, 2010 5:58 AM | Last reply by DhanuSurya - Wednesday, December 25, 2019 9:45 PM
-
0 Votes
We are trying to shrink a single database in SQL server 2008r2 , which is giving error due to insufficient space.
Hello there, We are trying to shrink a single database in SQL server 2008r2 without affecting any existing database. We are unable to shrink it as it ...Proposed | 2 Replies | 395 Views | Created by Isak Z - Wednesday, December 11, 2019 7:03 AM | Last reply by Cathy Ji - Thursday, December 12, 2019 6:32 AM -
1 Votes
Licenses SQL Express and IIS-7
Hello, I like to have professional advice how to deal with licenses. Let me explain our future plan. We want to install a Windows 2019 server with SQL Express and ...Answered | 3 Replies | 711 Views | Created by servicesbyone - Thursday, December 5, 2019 4:33 AM | Last reply by Cathy Ji - Friday, December 6, 2019 1:27 AM -
0 Votes
Real Time synchronisation of Remote server and client sever MS SQL database
Hii, Can anyone help me out, how to synchronise sql database available on server with the local database ? The database should get update in real time ...Proposed | 8 Replies | 646 Views | Created by Sandeep_Gupta2210 - Monday, November 25, 2019 1:51 PM | Last reply by Dedmon Dai - Tuesday, November 26, 2019 7:13 AM -
1 Votes
Can't install Dabase Engine or SQL Server Replication
I received error code 1639.See the below screenshot. I tried to rerun the installation manager as ...Unanswered | 7 Replies | 819 Views | Created by Kingsql - Wednesday, November 20, 2019 10:26 PM | Last reply by Cris Zhan - Monday, November 25, 2019 8:11 AM -
0 Votes
Severity: 16 Error:258, OS: 258 [Microsoft][SQL Server Native Client 11.0]Shared Memory Provider: Timeout error [258].
SQL 2012 crashed with following error: The description for Event ID 17052 from source MSSQLSERVER cannot be found. Either the component that raises this event is not installed on ...Unanswered | 1 Replies | 858 Views | Created by PascalJC - Friday, October 11, 2019 7:02 PM | Last reply by Cathy Ji - Monday, October 14, 2019 3:49 AM -
0 Votes
can we deploy SmartConnect database to a client that only has SQL Runtime license ?
can we deploy SmartConnect database to a client that only has SQL Runtime license ?Proposed | 1 Replies | 822 Views | Created by Jignesh Khatri - Thursday, October 3, 2019 6:41 PM | Last reply by Dedmon Dai - Friday, October 4, 2019 5:46 AM -
0 Votes
SQL Server Configuration Manager
Hi, Thanks in advance, If anyone can help on this error! Tried almost solutions ...Proposed | 2 Replies | 959 Views | Created by Moses Sebastian - Saturday, September 7, 2019 8:37 AM | Last reply by Dedmon Dai - Monday, September 9, 2019 7:56 AM -
0 Votes
Connection Timeout Pre Login-Handshake
Hi, We are running an ASP.Net MVC 5 application (Net Framework 4.5.2) ...Answered | 9 Replies | 1987 Views | Created by BreninMike - Tuesday, June 4, 2019 6:39 PM | Last reply by Peter Kandra - Wednesday, August 28, 2019 10:05 PM -
0 Votes
Newest Version Of SSMS Missing Feature
Database -> [Database Name] -> Connections -> right-click on connector name -> Refresh Credentials. This would prompt me for my Microsoft credentials and allow me to enter in my ...Proposed | 3 Replies | 1283 Views | Created by JVEGAFL - Wednesday, August 7, 2019 2:24 PM | Last reply by Cathy Ji - Monday, August 12, 2019 8:31 AM -
0 Votes
SQL Server 2014 - Ring Buffer Connectivity Errors - Error code - 17830
Hi Team, We use SQL Server 2014 at client location and we are having a series of performance issues reported with respect to our application, when everything looks fine in ...Unanswered | 1 Replies | 1094 Views | Created by Shailashreev - Friday, August 9, 2019 3:33 AM | Last reply by Cathy Ji - Monday, August 12, 2019 8:06 AM -
0 Votes
SQL Server License usage
I'm planning to buy a core license for SQL Server 2016 Standard edition. My scenario is, I can install SQL server in centralized VM Server. 1.How many users can ...Answered | 4 Replies | 1406 Views | Created by Rakesh Ponnala - Friday, June 21, 2019 10:18 AM | Last reply by Cathy Ji - Monday, June 24, 2019 2:22 AM -
0 Votes
SQL server management Studio | The client and server cannot communicate, because they do not possess a common algorithm
Hello, I have SQL server 2016 sp2 operating under windows server 2012 r2 and i need to create linked server on another instance (SQL server 2008 SP4) operating under windows server ...Unanswered | 3 Replies | 1720 Views | Created by EL-ABD - Sunday, June 16, 2019 10:57 AM | Last reply by Dedmon Dai - Thursday, June 20, 2019 8:53 AM -
0 Votes
Not able to get OracleOLEDB provider in MS SQL linked server
I am trying to link Oracle server in MS SQL Server. I have already installed Oracle Client in my machine. But, nothing will display OracleOLEDB Provider in my MS SQL ...Answered | 2 Replies | 1334 Views | Created by Gani tpt - Wednesday, June 19, 2019 9:49 AM | Last reply by Gani tpt - Wednesday, June 19, 2019 1:12 PM -
0 Votes
Error occured during DB Disk Latency data source executing
HI we have application running in the SQL server 2012 and base OS windows server 2008 R2 Ent and its clustered. i am getting the below error in Health ...Proposed | 7 Replies | 1552 Views | Created by Ansar.Ali - Wednesday, June 12, 2019 6:24 AM | Last reply by Dedmon Dai - Friday, June 14, 2019 9:19 AM -
0 Votes
SQLite, WCF , SQL Server
I will be copying data from my phone to desktop and then the desktop will communicate to a remote database through WCF. The phone data will overwrite the local ...Unanswered | 1 Replies | 1493 Views | Created by usher227 - Monday, May 27, 2019 7:52 PM | Last reply by Cathy Ji - Tuesday, May 28, 2019 6:53 AM -
0 Votes
How to configure transaction-log for Dynamics CRM on-premise deployment with SQL always on group?
Hello, I have a Dynamics CRM on-premise deployment with 2 SQL Server always on group. Recently, I have the error message "The transaction log for database 'XXXX_MSCRM' is full ...Answered | 6 Replies | 1549 Views | Created by Pentium.lan - Sunday, May 12, 2019 2:53 AM | Last reply by Pentium.lan - Thursday, May 23, 2019 2:17 AM -
2 Votes
Error on get_TargetDatabaseEngineEdition SSMS 2016
Hello, after applying various updates to Visual Studio (2017) and installing Visual Studio 2015, I now get an error when trying to connect to a database using SSMS (SQL Server Management Studio ...Proposed | 3 Replies | 8518 Views | Created by TboneDoug - Friday, May 11, 2018 6:22 PM | Last reply by bzman1699 - Monday, May 20, 2019 10:08 PM -
2 Votes
Permission to access the msdb database is required for this feature to work correctly
I am using SQL Server 2012. It was running ok for a while, but today I prompt with Cannot display policy health state at the server level, because the ...Answered | 3 Replies | 23212 Views | Created by Agha - Sunday, February 10, 2013 3:22 PM | Last reply by sql_mn - Tuesday, April 30, 2019 7:59 PM -
0 Votes
ASP.NET -> GMSA -> Teiid connection
GMSA -> Teiid connection" both in development and production. Regards, Anil ReddyUnanswered | 3 Replies | 2209 Views | Created by anilreddygelli - Friday, April 5, 2019 7:28 AM | Last reply by NALUTO - Tuesday, April 16, 2019 8:32 AM - Items 1 to 20 of 645 Next ›
No announcements
