I'm having some problems getting Interactive Conflict Resolution working under SQL Server 2000 SP4. I have set "Allow Subscribers to resolve conflicts interactively" under the Resolver tab for the article in the publication. I have set "Enable synchronization using Windows Synchronization Manager" and "Resolve conflicts interactively" under the Synchronization tab for the subscription. I have set "Resolve conflicts interactively" under the Other tab for the subscription properties in the Windows Synchronization Manager. However, when I generate conflicting data in the publishing and subscribed DBs and synchronize using the manager, the resolution is automatic and a warning pops up informing me that "conflicts occurred while syncronizing the data and were resolved according to defined rules." Am I missing anything here?
I'm running into problems with my replication where I get the following error: Violation of PRIMARY KEY constraint
I know what the error means, and I know what is causing it. In my case, a property is being added to an inventory item independently at the publisher and subscriber end. Each available property has a particular ID, each inventory item has its own unique ID, and of course the properties per inventory item are stored in a linking table. I am using UUIDs for the inventory items, to avoid collisions in that aspect, but the list of properties is fixed (currently only 15 - 20 available properties), so it doesn't make sense to me to have managed ranges, UUIDs, or other such things for the properties. Of course, I could apply a "source ID" to each added property to avoid these collisions, but I'd prefer not having to redesign the database, not to mention deal with the extraneous copies of properties.
My preference would be to simply have the server delete the copy on the server and take the subscriber row. I would have thought that using the "subscriber always wins" conflict resolver would have this effect, but it doesn't work for me. Is there a straightforward way of dealing with this problem? Am I missing something obvious? I've looked into a custom conflict resolver, but that seems like overkill for what must be a fairly common scenario.
For the record, the publisher in my case is SQL Server 2005, and the subscribers are SQL Server Mobile clients.
I have a couple of tables set up with column level tracking and using the "Subscriber Always Wins" conflict resolver.
I am still trying to work out why there is a conflict as the only updates to these rows happen at the subscriber.
What I am finding is that a conflict occurs and there appears to be a delay between the conflict being recognised and then resolved.
The reason I know there is a delay is because this is playing havoc with a data extract that relies on the updates from the subscriber.
For instance, I have a job on which the status is changed. That status change triggers an extract via BizTalk to another system. BizTalk, via an SQL adapter extracts the data from the server and I find that some of it is missing in the extract.
I go and look into the database at the raw data and find that the data is in fact there.
I have certain triggers running which set up export flags in the database to say this data should be exported. This works perfectly when there are no conflicts.
In each case where data has not been extracted, a conflict occurs.
Is there any way to guarantee that the conflict will be resolved at the same time as the synchronisation is complete - i.e. within the same transaction?
I thought replication was supposed to be a single transaction - you get it all or you get nothing.
I'm interested to hear from anyone who has experienced this behaviour.
I am doing a work were i have to syncronize data between a Publiser (PC, SQL SERVER 2005), and a subscriber (Pocket PC, SQL CE MOBILE). I studied lots of articles and i managed to put the syncronization to work, the problem is in conflict resolution!
The subscriber can´t insert or delet, only update!!
For exmple: I have a table that contais the quantity of a product X, for example 100 units, this goes to Pocket, but later arrive move 100 units that are increased in the PC, so we get 200 in the PC, (but 100 in Pocket), no problem if i syncronize now (Pocket will have 200 too), but if remove in Pocket for example 50 units, i've changed the same column in both Publisher and Subscriber database, if i syncronize now, i'll have a conflict, the final result should be 150 of product X in both databases (100 + 100 - 50), but the Publisher wins the conflict and the final result is 200!
I never worked with stored procedures and in microsoft theres and article called How to: Implement a Stored Procedure-Based Custom Conflict Resolver for a Merge Article (Replication Transact-SQL Programming), but they dont explain it very well and i dont know how to do my own stored procedure and implement it to the merge article.
in my own stored procedure i'll have to do some calculations to get the result i want, maybe using some table for the additions and subtractions. (Does the com based Addition resolver do this for me???)
Maybe you have experienced some problem like this, and could help me!
How should i do the stored procedure?
Oh, i tried to use de addiction resolver and the average resolver of com based but nothing happed, dont know why, i read some stuff and i think the addition could solve my problem, but it doesn´t work, i read above what you said and installed service pack 1 for sql 2005, but i instaled and nothing happened! When i change to the resolver that the subscriver wins, it works, why addition dont work?
executing the first script listed below resulted in the error message (translation):
Message 7890, Level 16, Status 1, Line 1 Error when registrating Endpoint. Potential port conflict ...
use AdventureWorks; go CREATE ENDPOINT SQLEP_AWPersons STATE = STARTED AS HTTP ( PATH = '/AWpersons', AUTHENTICATION = (INTEGRATED), PORTS = (CLEAR), SITE = '*' ) FOR SOAP ( WEBMETHOD 'PersonInfo' (NAME='AdventureWorks.dbo.uspGetPersonInfo'), BATCHES = DISABLED, WSDL = DEFAULT, DATABASE = 'AdventureWorks', NAMESPACE = 'http://Adventure-Works/Persons' )
I changed the port in the script to 8084:
PORTS = (8084),
Error Message 102: Wrong Syntac near ')'.
I changed the port in the script to '8084':
Error Message 7888: The stated IPv6-Address is not supported. The server is potentially not configured for the IPv6 Connectivity or the address is not formated in an known IPv6-Format.
I'm trying to setup the Interactive Conflict Resolver in my C# app via RMO. (using SQL Server 2005)
The only article I can find on MSDN or anywhere is involing T-SQL. Can someone please shed some light on this for me specificaly on the subscriber side.
I am using MSDE 2000 for my replication. the problem is that althought at time creating publication it inserts GUID into every table but if one table in 2 nodes has same primary key, it inserts only one row ( accorrding to prority ). there are some Conflict Reslover methods that can be used for this purpose. i wanted to ask that is there any other way for me to resolve this conflict. i am asking for a new way because my database schema has been created and a lot of coding behalf of that schema has been done.
Hi, I'm replicating a database between two instances of Sql 2000 using Merge Replication. I have no custom resolvers at present but I'm seeing something unexpected.
I created a SQL Server Agent job that contains an SSIS task. This task runs succesfully from BIDS. From the SQL Server Agent job it never completes while trying to run the SSIS task that needs to open an WS_FTP command line window to run an sftp step and then close.
I had this working on my local machine, Windows XP SP2, using the SSIS service using the local system account with "Allow Service to Interact with Desktop" checked. I needed to check this option for it to work. Otherwise the routine just hung without completing or an error message.
On our test machine running Windows 2003 with SP1 the SQL Server Agent and SSIS services are set to run under the NT Authority/NetworkServices account. I set the permissions on this account based from the list shown at SQL Server 2005 Books Online, Selecting an Account for the SQL Server Agent Service ,http://msdn2.microsoft.com/en-us/library/ms191543.aspx. I also needed to set folder permission on this account to access the files I wanted to ftp.
What I don't know what to do and that I suspect might be the problem is how to set the equivalent of, "Allow Service to Interact with Desktop" for this account. This was only an option under the local system account.
I would appreciate any ideas and guidance on how to deal with this case. Thanks.
In 7.0, an application development change has been made to defer name checking in stored procedures until exection time. This allows a clean store of the proc in the system catalog regardless of objects existing or not. At execution time, the proc is compiled, and object resolution is done. Problem - the procedure fails if object names, column names, etc are wrong or don't exist. So, during nightly cycle's the procedures bomb out.
Is there anyway to disable this 'deferred name resolution', or am I at the mercy of the developers? Can I make the resolution immediate?
Friends I have one SQL server2000 which have Mixed Mode authentication.It is working fine in PC which server instance is situating.But I have another PC which having connectvity tools of SQL Server.When I am trying to access SQL Server from the second PC through SQL authentication access getting denied.In the same time if I am accessing any of first PC's Folder using it's administrator password.Then if try with SQL authentication I am able to connect with SQL Server in the First PC from second PC .Please note SQL server instance is not in windows authentication mode .What may be the problem.Please suggest me a resolution
I am facing the Follwing error: Cannot resolve the collation conflict between "Latin1_General_BIN" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation.
Follwing is my Code: code]select * from #temp_Table a where ltrim(rtrim(Model_ID))+''+ltrim(rtrim(Set_Serial_Number)) in (select ltrim(rtrim(b.Model_SerialNo)) from #temp_Table2 b where b.Auto_Id=1)[[/code]
I just installed the SQL Server 2005 eval version on my laptop to try it out and now Outlook crashes. There appears to be a conflict with Outlook Business Contact Manager, which might be running its own database under the covers.
When I try to start Outlook I get the error message "Business Contact Manager has encountered a problem and needs to close. We are sorry for the inconvenience". The button choices are Debug, Send Report Later and Don't Send. Clicking Don't Send closes Outlook.
I found some info on modifying the registry to disable BCM, which I did, but I still get the same error and Outlook won't start. I also tried removing all of the SQL Server 2005 stuff from my path environment variable but it didn't work either.
Any suggestions would be appreciated because I depend on Outlook for my email and contacts.
I am trying to add data to 2 columns CaseResolvDatetime and CaseResolvGroupName based on the criteria: 1. for a CallID, the last datetime where Resolution='Resolved' 2. where there is no 'Resolved', the 2nd last datetime & groupname for a particular CallID
INSERT @table(CallID, ResolvDatetime, GroupName, Resolution, CaseResolvDatetime, CaseResolvGroupName) SELECT '00458176','08/1/2005 1:41:54 PM','Field Sup CoOrd','Resolved',Null,Null UNION ALL SELECT '00458176','08/9/2005 3:35:24 PM','Service Desk','Reassigned',Null,Null UNION ALL SELECT '00458176','08/12/2005 9:54:37 AM','BSSAppSvcs-Club','Reassigned',Null,Null UNION ALL SELECT '00458176','08/16/2005 10:32:40 AM','CDR SysOps','Reassigned',Null,Null UNION ALL SELECT '00458176','08/24/2005 11:18:30 AM','CDR Server','Reassigned',Null,Null UNION ALL SELECT '00458176','08/24/2005 2:13:15 PM','Field Sup CoOrd','Reassigned',Null,Null UNION ALL SELECT '00458176','08/24/2005 4:01:24 PM','CDR Server','Resolved',Null,Null UNION ALL SELECT '00458176','08/25/2005 4:29:44 PM','Field Sup CoOrd','Reassigned',Null,Null UNION ALL SELECT '00458176','08/26/2005 2:59:19 PM','Service Desk','Reassigned',Null,Null UNION ALL SELECT '00458176','09/9/2005 10:42:44 AM','Field Sup - Vic','Completed',Null,Null UNION ALL SELECT '00461166','09/7/2005 9:49:02 AM','BSSAppSvcs-Apps','Resolved',Null,Null UNION ALL SELECT '00461166','09/7/2005 10:26:42 AM','Service Desk','Completed',Null,Null UNION ALL SELECT '00461166','09/9/2005 10:19:13 AM','BSSAppSvcs-Apps','Reassigned',Null,Null UNION ALL SELECT '00461166','09/15/2005 1:15:00 PM','Service Desk','Reassigned',Null,Null UNION ALL SELECT '00461166','09/15/2005 1:15:11 PM','Service Desk','Resolved',Null,Null UNION ALL SELECT '00456633','08/08/2005 1:18:32 PM','BSSAppSvcs-Club','Completed',Null,Null UNION ALL SELECT '00456633','08/26/2005 2:02:07 PM','Service Desk','Completed',Null,Null UNION ALL SELECT '00456633','08/26/2005 3:31:36 PM','Service Desk','Completed',Null,Null
SELECT CallID, ResolvDatetime, GroupName, Resolution, CaseResolvDatetime, CaseResolvGroupName FROM @table
UPDATE @table
SET CaseResolvDatetime = CASE WHEN Resolution = 'Completed' AND CallId = (select CallId from @table where GroupName like 'Ser%' AND Resolution = 'Completed') then ResolvDatetime ELSE NULL END
SELECT CallID, ResolvDatetime, GroupName, Resolution, CaseResolvDatetime, CaseResolvGroupName FROM @table -------------------------------------------------
At the moment I get the error:
Server: Msg 512, Level 16, State 1, Line 25 Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression. The statement has been terminated.
Yet when I change the line:
"where GroupName like 'Ser%'" to "where GroupName like 'CDR%'" ... I get no error.
I am merging two databases and created two different schemas to contain the objects in the new DB. I would like the objects in both schemas to be visible to one user but I can't figure out how to make this happen. I thought I could just set the Owner of the schemas to the same User but that didn't work. At the moment, the User default schema is set to dbo. I would like the default to be both schemas but this isn't an option.
Is there any way to have multiple schema objects visible to a single user? Thanks!
I am using Allwayson to replicate a FCI to a remote site. (windows 2012R2) Although all is implemented, iam getting a strange error with the listener resources after ive made a failover test.
It keeps saying "Name resolution not yet available"from my understanding this is trying to update an entry that doesn't exist (since the user has permissions to do it).
Is there any way to set up name resolution for DTC when there are two servers with the same name? I have three servers - two production systems named "SQL" and an archive system "DMART". I want to run DTC procedures to archive data from both SQL's to the DMART. Is there any way to set up the DMART so it can properly resolve the names from each of the SQL's? They are on separate networks, but unfortunately have the same NetBIOS name.
I'm just wondering what is the resolution or execution order for a query like this (simplified version):
CREATE VIEW ClosedSales AS SELECT * from NatSales where CurrentFlag = 1 and ValidTo <> '9999-99-99' Select * from ClosedSales where CustomerId = 10
The thing I want to know is:
- If first the complete dataset from the view is calculated and the the CustomerId=10 filter is applied - Or the CustomerId=10 condition is added to the where clause in the view definition
My real case is much more complex but that is an interesting point in my performance analysis.
DropDB.sql IF EXISTS (SELECT name FROM sys.databases WHERE name = N'Caching') DROP DATABASE [Caching]
I have gotten some great answers. Now I like to ask a deeper question. This command was created for SQL Server Express, for an internal software package at my company, by an outside vendor. However, sometimes this command doesn't work 100% on all user computers. So I have two questions. 1. Is there any way to either enhance the command, or the database command, to provide error diagnostics, to find out the issue for an individual user computer, why it doesn't always work? 2. Can anyone think of any scenarios that would prevent this from working? The key element here is that this caching database is supposed to allow individuals to use a particular piece of software, when they aren't connected to the network at work. But it doesn't always work on each computer - 100% of the time - even when the computer has SQL Server Express installed, and is running Windows XP. Randy
I created a report in SSRS which incorporates an image.And I have written a code using C# to export the report to PDF. While I am exporting this report to PDF from the SSRS, the resolution of the image got decreased.
Can anyone give me a solution to configure the resolution of the image in the PDF.
An outside vendor created this command and SQL files for internal software, using SQL Server Express, which is installed on every user machine
osql -S (local)SQLEXPRESS -E -i DropDB.sql The SQL file has this: IF EXISTS (SELECT name FROM sys.databases WHERE name = N'Caching') DROP DATABASE [Caching]
This command was created for SQL Server Express, for an internal software package at my company, by an outside vendor. However, sometimes this command doesn't work 100% on all user computers. So I have two questions. 1. Is there any way to either enhance the command, or the database command, to provide error diagnostics, to find out the issue for an individual user computer, why it doesn't always work? 2. Can anyone think of any scenarios that would prevent this from working? The key element here is that this caching database is supposed to allow individuals to use a particular piece of software, when they aren't connected to the network at work. But it doesn't always work on each computer - 100% of the time - even when the computer has SQL Server Express installed, and is running Windows XP. Randy
I am practicing on vmware 2 node failover cluster for doing Sql failover clustering understanding.I did proper Ad Dc setup and configured san storage through iscsi software that I downloaded from net.I did target and initiator configuration for san storage on same Domain controller vm.Name of target is Target1 and has two initialtor for node1 and node2.It has two virtual disk assigned Quorumdisk.vhd and sqldisk.vhd.ON vmnode1 I have initialzed and formatted my both disk with proper volume and label.
Node which are participating in cluster are node1 and node2.while my windows clustering went fine,while Sql server installation on node 1,i got error IP Address conflict occured.
my DC has IP address:192.168.1.10 my Node1 is 192.168.1.20 node2:192.168.1.30 Cluster IP address is 192.168.1.35
What has cause this situation.What configuration is needed.How do I troubleshoot this problem as now I can not install my sql for clustering as also gave me Invalid network name error.Is my storage configuration not proper or IP address is in correct?Do I need to put my virtual disk in Clustered shared volume?
SP2 for SQL Server 2005 x64 has been less than happy for me.
The initial problem, mentioned in another thread, concerned SSIS client which stopped liking Data Flow components. It was solved by a removal and reinstallation of the client tools.
However, there now seems to be a problem with making use of the Teradata oledb provider within SSIS. Prior to the installation of SP2 there was no problem.
I create a new SSIS package Add a Data Flow component Within the data flow add an oledb source Create a new connection - using the Teradata oledb provider Test the connection (it works!) Use SQL something like "select * from some_teradata_table_on_the_TD_server" Click on columns, wait a second, a list of columns is returned Add a SQL Server destination (with a new SQL Server connection) Connect the two components Save the package
Click go The TD oledb source component turns bright red and the error is "class not registered"
I have uninstalled the TD oledb provider (and underlying TD components) and re-installed (32-bit and 64-bit) - no change
I have just upgraded to SQL Server 2005 from SQL Server 2000.In Microsoft SQL Server Management Studio, when I click on databaseproperties, I receive the following error:-Cannot resolve the collation conflict between"Latin1_General_CI_AS"and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation.(Microsoft SQL Server, Error: 468)Some reference suggest that I can change the database collation byclicking database properties!What can I do?
i created a query and when i run it like this i get data but when i add a value in the 2ed case for '2%' i get error. Select a.email, case when a.reportnumber like '1%' then (select b.Reportnumber from ijasSummaryNo b where a.Reportnumber = b.Reportnumber) end as Reportnumber, case when a.Reportnumber like '1%' then (select b.stonebreakdown from ijasSummaryNo b where a.Reportnumber = b.Reportnumber) end as Measurement, case when a.Reportnumber like '1%' then (select b.reportcarddate from ijasSummaryNo b where a.Reportnumber = b.Reportnumber) end as ijasDate, case when a.reportnumber like '2%' then (select c.Reportnumber from appraisalsummaryblue c where a.reportnumber = c.reportnumber) end as imacsRepNo from t_RegisterInfoTemp a Query works fine like this but when i add this (the one marked bold i get error) case when a.reportnumber like '2%' then (select c.Reportnumber from appraisalsummaryblue c where a.reportnumber = c.reportnumber) end as imacsRepNo,case when a.reportnumber like '2%' then (select c.Measurement from appraisalsummaryblue c where a.reportnumber = c.reportnumber) end as Measurement2
This is the error. Server: Msg 4414, Level 16, State 1, Line 1Could not allocate ancillary table for view or function resolution. The maximum number of tables in a query (260) was exceeded.
Hello, I want to get data from datatable as below. I am getting error: BC30516: Overload resolution failed because no accessible 'New' accepts this number of arguments. I did not understand what is wrong. Because everything is same as msdn library. my codebehind is: Imports System.Data Imports System.Data.Sql Imports System.Data.SqlClientPartial Class Default2 Inherits System.Web.UI.Page
Private Shared Function GetConnectionString() As String ' To avoid storing the connection string in your code, ' you can retrieve it from a configuration file. Return "Data Source=Database;Initial Catalog=otel;Integrated Security=True;Pooling=False" End FunctionProtected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.LoadDim connectionString As String = _ GetConnectionString() ' Create a SqlConnection to the database.Using connection As SqlConnection = New SqlConnection(connectionString)
' Create a SqlDataAdapter for the Suppliers table.Dim mailsAdapter As SqlDataAdapter = _ New SqlDataAdapter() ' A table mapping names the DataTable.mailsAdapter.TableMappings.Add("Table", "Pages") connection.Open()Dim PagesCommand As SqlCommand = New SqlCommand( _"SELECT * FROM Pages", _ connection) PagesCommand.CommandType = CommandType.Text ' Set the SqlDataAdapter's SelectCommand. mailsAdapter.SelectCommand = PagesCommand ' Fill the DataSet. Dim dataSet1 As Dataset = New Dataset("Pages") 'ERROR MESSAGE HERE...........................................mailsAdapter.Fill(dataSet1) connection.Close()LblPageName.Text = CStr(dataSet1.Tables("Pages").Rows(0).Item(1)) TxtPageTitle.Text = CStr(dataSet1.Tables("Pages").Rows(0).Item(2))TxtPageSummary.Text = CStr(dataSet1.Tables("Pages").Rows(0).Item(3)) Rte1.Text = CStr(dataSet1.Tables("Pages").Rows(0).Item(4))TxtPageimgUrl.Text = CStr(dataSet1.Tables("Pages").Rows(0).Item(5)) End Using End Sub
In order to add a data source by using ODBC Administrator, programmatically i am using SQLConfigDataSource. Thus calling SQLConfigDataSource with the fOption set to either ODBC_ADD_DSN for creating a new DSN.
Following is the stattement specified in the source code. where type_of_driver = "Microsoft Access Driver (*.mdb)"; and parameters contains the data source source credentials information such as DSN, UID, PSW, FIL, Description, DataDirectory,DEFAULTDIR and DBQ all separated by "