I need to implement Merge replication with a scenario like a Central Main server, 4 Office Servers located at each country office, and each machine having sql exp开发者_如何学JAVAress insatalled on th
I\'m using Merge Replication. The Identity range management is AUTOMATIC I HAVE A TRIGGER ON COMPANIES TABLE WHICH INSERTS ROWS IN SERIALNUMBERSCHEME TABLE which has documentID as identity column
Can I (How do I) configure Sql Server 2008 to notify an operator if any step in the Job fails? I have a Sql Server job with several steps to update data from multiple different sources, followed by o
When i run a mysql select statement, it 开发者_如何学运维takes very long because i have already previously deleted a very large number of rows.
I have an interesting database problem. I have a DB that is 150GB in size. My memory buffer is 8GB. Most of my data is rarely being retrieved, or mainly being retrieved by backend processes. I would
Closed. This question does not meet Stack Overflow guidelines. It is not currently accepting answers.
How to detect a column included in WHERE clause but used in indexed? Little Background: Until the time the table has few 开发者_JAVA百科number of records things will be okay, once it started having
I\'m deploying a client application to several thousand windows machines. Each machine will use a sqlite database as a local datastore, ultimately开发者_运维知识库 writing data to a remote server. So
i used the following sytanx drop database filmo; and got the following error: ERROR 1010 (HY000): Error dropping database (can\'t开发者_如何学JAVA rmdir \'./filmo/\', errno: 17)