Reputation
4,743
Top tag
Next privilege 5,000 Rep.
Approve tag wiki edits
Badges
2 18 41
Impact
~481k people reached

16h
revised Error converting data type nvarchar to float. Oracle Linked Server
explain why setting nls_lang to American fixed the problem
16h
revised Error converting data type nvarchar to float. Oracle Linked Server
added 264 characters in body
1d
accepted Error creating database on new storage in SQL Server 2008 R2 Failover Cluster
1d
awarded  Popular Question
1d
answered SQL Server data folder access rights
1d
answered Error converting data type nvarchar to float. Oracle Linked Server
1d
comment Error converting data type nvarchar to float. Oracle Linked Server
Hello, @PJMahoney, the problem is with the client not the source table. I can run the same query against the same data from another identical server without error
2d
asked Error converting data type nvarchar to float. Oracle Linked Server
2d
comment How to:: Master-Master replication
Let us continue this discussion in chat.
2d
comment How to:: Master-Master replication
Not sure I understand what you mean by risky. If an insert is received by each master for the same table, the second insert will simply get the next increment value, n+1.
2d
comment How to:: Master-Master replication
Stick with master-master then as you would eliminate the need to run the change master command on the first master. You can still keep replication going and lock down your second server by restricting login access to it.
2d
comment How to:: Master-Master replication
What is the purpose of each server in your configuration?
2d
revised How to:: Master-Master replication
added 1247 characters in body
2d
revised How to:: Master-Master replication
added 1247 characters in body
2d
answered How to:: Master-Master replication
Aug
22
answered Mysql error “#1030 - Got error -1 from storage engine” when doing insert/update queries
Aug
21
comment Create a SQL Server Redirect (Alias / Linked Server)
Outside SQL Server, via a DNS (bind, Active Directory) server or your hosts file.
Aug
20
awarded  Notable Question
Aug
20
comment Mysql error “#1030 - Got error -1 from storage engine” when doing insert/update queries
Hi, I don't see the innodb_force_recovery option in your my.cnf file. If it is there, you should remove it.
Aug
19
revised MySQL growth 500k records/day
deleted 4 characters in body