No announcements
Found 3368219 threads
-
0 Votes
Double quotes in SQL statement
Double quotes and slashes have no meaning in SQL, hence the error.Answered | 2 Replies | 3798 Views | Created by bacic-i - Wednesday, February 18, 2009 12:40 PM | Last reply by Guo Surfer - Tuesday, February 24, 2009 2:34 AM -
0 Votes
Sql Server Management Assistant (SSMA) Oracle okay for large database migrations?
Microsoft SQL Server Migration Assistant v6.0 for Oracle.Answered | 2 Replies | 2330 Views | Created by Bill The Coder - Tuesday, February 3, 2015 10:39 PM | Last reply by Bill The Coder - Thursday, February 5, 2015 4:32 PM -
0 Votes
Missing tables in MS SQL Server Migration assistant for Access 2010
id=28763 The following thread is about a similar issue, please refer ...Answered | 2 Replies | 1814 Views | Created by Ralph390 - Wednesday, October 16, 2013 7:07 PM | Last reply by Ralph390 - Thursday, October 24, 2013 7:28 PM -
2 Votes
Hi Microsoft,Would you please help to check why "Microsoft SQL Server Native Client 11.0" "Login timeout expired"?
"Unable to complete login process due to delay in login response" May be the SQL ...Answered | 2 Replies | 2074 Views | Created by Carlsonshi - Wednesday, December 19, 2018 9:00 AM | Last reply by Olaf Helper - Wednesday, December 19, 2018 9:26 AM -
0 Votes
QUOTED IDENTIFIER
But this setting must be ON for some features in SQL Server to work, for instance index on computed columns.Answered | 10 Replies | 4604 Views | Created by dfolino - Tuesday, September 20, 2011 11:26 AM | Last reply by Flynn 642 - Tuesday, October 2, 2012 4:26 PM -
3 Votes
if missing section at xml data - error : URL "mssql://SQL//DB?
nothing - if Address is missing - procedure get nothing( null data) I mean what is in the Xml ...Answered | 7 Replies | 1299 Views | Created by Port is active but Web Services was down - Wednesday, July 20, 2016 9:31 AM | Last reply by Pushpendra K Singh - Wednesday, July 20, 2016 8:20 PM -
1 Votes
Regexp pattern to add ".0" to integers
For example, "1 / 2" should be changed to "1.0 / 2.0".Answered | 2 Replies | 963 Views | Created by JohnBrooking4 - Wednesday, January 25, 2017 4:27 PM | Last reply by JohnBrooking4 - Wednesday, January 25, 2017 6:55 PM -
0 Votes
Tests passing locally, "not executed" on build server
I should also mention that there are no build errors.Answered | 5 Replies | 1230 Views | Created by L. Chen - Wednesday, June 29, 2016 10:27 PM | Last reply by Tingting MO - Wednesday, July 6, 2016 1:50 AM -
0 Votes
Issue in single quoted text in sql server 2008 R2
Hello, I am getting an error as "Error converting type varchar to float".Answered | 6 Replies | 1672 Views | Created by Navale Chetan - Monday, May 6, 2013 11:44 AM | Last reply by Navale Chetan - Monday, May 27, 2013 5:49 AM -
0 Votes
sql server Migration error
Hi judydb, Based on my test, you can get the error “The @flags parameter is not valid for a job step of type SSIS” if you use SQL Server ...Answered | 3 Replies | 2121 Views | Created by judydb - Monday, December 7, 2015 10:55 PM | Last reply by Ice Fan - Tuesday, December 15, 2015 12:45 PM -
2 Votes
The operation with action "CompositeOperation" took longer than the specified timeout "00:01:00" wcf-sql
Also, you may want to check if there is any performance degradation at the destination SQL Server side, which may be causing these operations ...Answered | 5 Replies | 2415 Views | Created by DineshNad - Thursday, April 7, 2016 5:34 AM | Last reply by Arindam Paul Roy - Thursday, April 7, 2016 7:21 AM -
0 Votes
Double quotes within a Double Quotes text qualifier
In addition to Arthur's solution, here is Jeff Moden's solution for the nested double quotes problem: "If you setup a BCP format file correctly and use ...Answered | 2 Replies | 3522 Views | Created by JesseO - Tuesday, March 5, 2013 6:56 PM | Last reply by Kalman Toth - Thursday, March 7, 2013 2:57 PM -
0 Votes
How to fix the error "Error 1205 : Transaction (Process 70) was deadlocked ...
ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Неправильный ...Answered | 19 Replies | 2232 Views | Created by Oleksandr Husiev - Sunday, September 15, 2019 1:18 PM | Last reply by Oleksandr Husiev - Thursday, September 26, 2019 2:41 AM -
4 Votes
fbwf causing "publisher could not be verified"
Please reach out to your Microsoft distributor to get assistance with the udpate.Answered | 33 Replies | 7019 Views | Created by GutschalkD - Thursday, June 20, 2013 2:09 PM | Last reply by FélixF - Tuesday, October 6, 2020 10:15 AM -
0 Votes
Removing Quotes from data in Sql Server Table
If the source is SQL, use a SQL command and in the select query for the column in question specify SELECT REPLACE(<column name>, '"','').Answered | 4 Replies | 35105 Views | Created by EMKISER - Wednesday, August 15, 2012 10:06 PM | Last reply by EMKISER - Thursday, August 16, 2012 3:07 PM -
0 Votes
Using SQL Server migration assistant for access to create a SQL Server 2008r2 database from an Access database
I can now migrate Access databases over to SQL Server 2008.Answered | 3 Replies | 1654 Views | Created by KaseyD - Monday, November 5, 2018 5:28 PM | Last reply by Venkat_19 - Thursday, February 28, 2019 8:35 PM -
3 Votes
Licence page for Microsoft Sql Server Migration Assistant (mysql) missing
Users are receiving error 404.Answered | 21 Replies | 7986 Views | Created by Bagus Haig - Monday, October 21, 2013 5:28 PM | Last reply by DaveRode - Tuesday, January 14, 2014 9:19 PM -
1 Votes
Migration Assistant Access 2003 to SQL Server 2008 R2 license file
I copied the file access-ssma.license into C:\Microsoft SQL Server Migration Assistant for Access, refreshed and it is now ...Answered | 2 Replies | 6289 Views | Created by meridius10 - Sunday, March 4, 2012 2:40 PM | Last reply by meridius10 - Monday, March 5, 2012 10:56 AM -
0 Votes
Problem migrating large table with SQL Server Migration Assistant for Oracle
genius, if the error msg only told us it was due to a timeout.Answered | 3 Replies | 4725 Views | Created by TorbjörnLilja - Monday, September 3, 2018 6:11 PM | Last reply by MSSYSDBA - Tuesday, October 16, 2018 4:17 AM -
3 Votes
Cannot get Licence Key for Microsoft SQL Server Migration Assistant for MySQL
C:\Program Files (x86)\Microsoft SQL Server Migration Assistant\) 4) Rename the file to 'ssma-license.key'.Answered | 15 Replies | 7190 Views | Created by Dusan74 - Monday, October 21, 2013 3:11 PM | Last reply by zer0_dc - Wednesday, September 24, 2014 3:36 PM
No announcements