Does the actual update statement of a table affect Merge Replication?

SQL Server Replication

Index ‹ SQL Server

- Previous
  - 1
    - Missing SQL Server Management Studio Hi, I am a novice at SQl Server, so apologise in advance if you think this is a really stupid question. I have a windows XP laptop with Visual Studio 2005. I installed SQl Server 2005 Developer Edition but do not see the SQl Server Management Studio anywhere. The only thing in Programs/ SQL Server 2005 is SQL Server Configuration Manager. I then uninstalled it & installed SQL Server Express but encountered the same issue. I would like to install the Developer Edition if possible. I have tried uninstalling & reinstalling a few times but it does not work. Could someone please help in resolving this. Appreciate it! Tag: Does the actual update statement of a table affect Merge Replication?
  - 2
    - Install SQL 2005 Ent Eval Edit on Vista X64 User not found ... Details: OS Vista Ultimate (64-bit), Harware: Intel Core Duo 2 2.13 Ghz, 4 GB RAM, Serial ATA WD Raptor 150GB. Installed all the service packs for Vista. All hardware configured and running. IIS is running, .Net 2.0 is running. During the install I get green flags across the board for all items. Regardless of what I install, when it gets to installing the DB Engine it throws an error: TITLE: Microsoft SQL Server 2005 Setup ------------------------------ SQL Server Setup failed to execute a command for server configuration. The error was [Microsoft][SQL Native Client][SQL Server]Windows NT user or group 'MARK-PC\SQLServer2005MSSQLUser$MARK-PC$MSSQLSERVER' not found. Check the name again.. Refer to the server error logs and Setup logs for detailed error information. For help, click: http://go.microsoft.com/fwlink LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=setup.rll&EvtID=29521&EvtType=lib%5codbc_statement.h%40Do_sqlScript%40OdbcStatement%3a%3aexecute_batch%40CnfgSQL%4080%40x3c29 ------------------------------ BUTTONS: &Retry Cancel ------------------------------ The url above takes me to a web page with this: ID: 29521 Source: setup.rll I have tried not using the built in system account locally on my machine which I am logged into as with Admin rights. I have tried creating another Admin level account, and using it. I have tried using the accounts listed above specified as "domain account", and have always specified Multi Mode Authentication and set a password for the "sa" account. No matter what, I get the error above. Tag: Does the actual update statement of a table affect Merge Replication?
  - 3
    - Temp table for repeatedly used sub query Hi, Here is my query which lists all orders for products supplied by Supplier-3. A typical Query on the Northwind database i wrote is like this.. Select * FROM [Order Details] WHERE ProductID in (Select ProductID From Products where SupplierID = 3) The subquery in Red was used in multiple places in one of my Stored Procedures.. So what i thought was - use a temp table to store the resultset from this subquery, and then use the temp table instead of querying the Products table everywhere.. My Query looked something like this.. Declare @ProductIDs TABLE (ProductID int) INSERT INTO @ProductIDs Select ProductID From Products where SupplierID = 3 Select * FROM [Order Details] WHERE ProductID in (Select ProductID FROM @ProductIDs) Well, I expected an increase in performance with the latter approach, but seems my Stored Procedure is taking more time with the second solution.. Would be glad to see ne explanation on this behavior.. Thanks in Advance.. Tag: Does the actual update statement of a table affect Merge Replication?
  - 4
    - AutoNumber in T-SQL Select Statement I cant get ur solution.......... Tag: Does the actual update statement of a table affect Merge Replication?
  - 5
    - custom subtotals in a matrix I tried the following: =iif(InScope( "matrix1_AtYear" ) and InScope( "matrix1_customer" ),sum(fields!count1.value),var(fields!count1.value)) The Grand total will display the Variance, however it looks at the dataset to caculate this value. I'm doing all my grouping caIculation at the report level, not at the data set level. I want it to look at the total per quarter columns and use those number to come up with a variance. For instance the first row of the matrix I displayed above, I want to see (1001-200)/1001*100 = 80 . Tag: Does the actual update statement of a table affect Merge Replication?
  - 6
    - Duplicate records Yet another option is to stage your data file into a sql server table and then select distinct from there. Tag: Does the actual update statement of a table affect Merge Replication?
  - 7
    - Estimating growth of mdf file size... Hi, how can I estimate the mdf file size's growth as record inserted Tag: Does the actual update statement of a table affect Merge Replication?
  - 8
    - How do I write multiple pipeline buffer to multiple targets based on a calculated value in the pipeline buffer Using a script component asynchronously, you can add as many rows as you need. Building a loop based on your division math, you can loop through each "needed" row and call the AddRow() method. Code Snippet dim iterations as integer = row.qty / row.max_qty_value 'I'll let you figure out the rounding/etc to get the correct iterations dim counter as integer = 0 dim holder as integer = row.qty while counter < iterations output0buffer.addrow() if (holder > row.max_qty_value) then output0buffer.newqty = row.max_qty_value else output0buffer.newqty = holder end if holder = holder - row.max_qty_value end while Something like that. Tag: Does the actual update statement of a table affect Merge Replication?
  - 9
    - Performance issues with large fact tables(1.5 mill rows) and large dimensions (one dimension 20k another 50k) Hi, I would suggest to disconnect the proactive caching, solve the perfromance problems and then re-activate the proactive caching. Just to make sure the performance problem is not due to the proactive caching on the server. Regarding the performance issue, make sure you have unrestrict aggregation for all attributes (I do not remember if this is the correct name). For creating better aggregations use the AggregationManager including in the samples, this is allow to create the aggregations based on the QueryLog more efficiently then SSDS (do not ask me why, but I already prove it). If you had hiearchies do not forget to create the attribute relationships, AS2000 would create them automatically for you, AS2005 does not. Make sure that the key for each level is unique, otherwise your data will wrong if the mebers are not unique. Create the key as collection of the keys of the ancestors plus the current level if needed. Hope it helps. Tag: Does the actual update statement of a table affect Merge Replication?
  - 10
    - Assigning a particular flat file record to a string variable Hey all! Okay, can I assign line x of a flat file to a variable, parse that line, do my data transformations, and then move on to line x+1 Any thoughts In other words, I'm looking at using a for loop to cycle through a flat file. I have the for loop set up, and the counter's iterating correctly. How do I point at a particular line in a flat file Thanks for any suggestions! Jim Work Tag: Does the actual update statement of a table affect Merge Replication?
  - 11
    - Question regarding connections with MSAccess I have a Access 2002 (saved as 2K format) front end to a SQL Server (2000 I believe) and everything worked fine until I added 30 new fields to the main table. All of these fields are data type Bit and all are initialized to zero. I can add new records without any issues. The problem is that any time I try to update or delete a record I get the dreaded "Write Conflict..." msg in Access. If I use an older version of the system without refreshing the linked tables I have no problems. This behavior is also exhibited if I try to update/delete a record directly in the table so I know it is not something in my forms. Any help would be greatly appreciated. Ron Tag: Does the actual update statement of a table affect Merge Replication?
  - 12
    - Percent Available Measure Problem My novices foray attempt into the field of BI is to build a simple Network Availability solution and is proving challenging. The problem is the Percent Available Measure and how to maintain its value as aggregation distorts its meaning when compared to the Device & Department Dimensions; 100% should remain 100% no matter the aggregation. I tried to convert the following SQL, which is used to return the Percent Availability of a device or group into a Calculation Member: Code Snippet (PercentAvailable*TimeDelta*1.0)/NULLIF(TimeDelta,0) My failed MDX attempt is this: Code Snippet ([Measures].[Percent Available]*[Measures].[Time Delta])/IIF(IsEmpty([Measures].[Time Delta])), 0, ([Measures].[Time Delta])) Please educate as to handling the Percent Available measure. I wish to know if it is possible to use it as a measure, maintaining its DB value, or would a calculated member be more appropriate. The Fact Table is below and contains sample at Daily intervals. Thanking you in advance, Ian Code Snippet AvailabilityFact FK_Time datetime FK_Devices int FK_Departments int Packets_Sent int Packets_Lost int Time_Delta float Percent_Available real Tag: Does the actual update statement of a table affect Merge Replication?
  - 13
    - Overcoming the openquery 8000 char limit & problem with using Call mystoredproc() in open query Does anyone know why this statement would fail I have created my own assembly which is on the server and when i run the mdx query call myassembly.mystoredproc() it returns data, but now when I use call myassembly.mystoredproc() it returns an error. using an mdx query this works fine call AsmTest.Asm.Analysis.TestClass.NameMe() When using openquery i get an error select * from openquery(NV, 'call AsmTest.Asm.Analysis.TestClass.NameMe()' ) OLE DB provider "MSOLAP.3" for linked server "NV" returned message "Prepare is not safe during execution of the NameMe stored procedure.". Msg 7321, Level 16, State 2, Line 1 An error occurred while preparing the query "call AsmTest.Asm.Analysis.TestClass.NameMe()" for execution against OLE DB provider "MSOLAP.3" for linked server "NV". linked server definition USE master GO /* Add new linked server */ EXEC sp_addlinkedserver @server='NV', -- local SQL name given to the linked server @srvproduct='', -- not used @provider='MSOLAP.3', -- OLE DB provider (the .2 means the SQL2K version) @datasrc='nvsifwfp', -- analysis server name (machine name) @catalog='ARTSDW' -- default catalog/database Tag: Does the actual update statement of a table affect Merge Replication?
  - 14
    - Still getting: "Unable to connect to the remote server..." please help! Hello I'm getting the error messege: " Unable to connect to the remote server. The attempted operation is not supported for the type of object referenced" This message occurs with any report, including other ones that I build. It has this error when when under the http://localhost/reports/ .... path. And also when adding a report viewer component in Visual studio and running the web site project it still get the same error. These reports work properly if I browse anly to http://localhost/reportserver/ ..... ; I have completely removed IIS , & all SQL Server 2005 components, and re-installed. I am still receiving the same error. I saw some same problems with that in other websites and still can't get the right solution I tried to configure the Surface Area Configuration - remote connections to Local and remote connections also TCP & TCP and named pipes- still doesn't work. I tried to configure Sql Server Management studio Express - properties- security and to set SQL server and Windows authentication . still getting the same error I also tried this solusion by this site here: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1756698&SiteID=1 But still getting the same problem. please help me to solve this problem I'm so desperate with that after searching so much for a solution. Thanks in Advance Miki Tag: Does the actual update statement of a table affect Merge Replication?
  - 15
    - SQL EXPRESS TIMEOUT See the problem does not occurr at the ADO nor the queries i run. It acctually happens before any code I wrote runs, it happens at LOGIN. I use the Login controll from VisualStudio 2005, this control sets it self and there are no properties as far as connections The only connection property can ser prior running any code is the one on the Web.config file which have the following string connection: This is my connection string on the web.config file on my site: prity much standard connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\ASPNETDB.MDF;Integrated Security=True;User Instance=True" Adding any Timeout option here dosen't do anything because ASP.net 2.0 ignores it. As far as I understand when i try to LOGIN on the site, the controll tries to open the ASPNETDB.MDF but SQL Server EXPRESS aparently dettaches it after some period of unactivity so the controll simply TIMES OUT this is because SQL Server Express have to RE ATTACH IT and of course this will take more than 15 seconds to complete... This is a very Idiotic functionality of SQL express far worse than that there is no way to configure the database unlike SQl server 2000 there is the Enterprise manager the one for SQL server Express is a read only and is USELESS. So the problem as you see is on the Sql server Expresss who after a period of Database inactivity it D-Attaches the ASPNETDB.MDF Database. and when a LOGIN request is received SQL server Express tryies to re attached and Suceeds after 30 seconds, but unfortunately that is too long for the Connection to wait an it craps out.. Any info on how to resolv this problem of hell please let me know THANKS in Advance Tag: Does the actual update statement of a table affect Merge Replication?
  - 16
    - Cloud of Confusion: Running SSIS packages on 64 Bit SQL Server It is clear to me that in order to be able to use certain SSIS components (for example the Excel jet provider) I must launch my packages using the 32bit DTEXEC located at Program Files (x86)\Microsoft SQL Server\90\DTS\Binn. However, when I do this it seems that there are other components of the package that no longer work as expected. To test this I have created a simple package with two tasks (Run64BitRuntime is set to False): 1. Data flow task importing data from Excel 2. Execute SQL Task which does a simple select (select 1) from a Native OLE DB SQL data source (same SQL Server on which packages are stored). This task contains no input or output parameter. When I try to execute the package using the 64bit DTEXEC, task 1 fails with the following error (as expected): Code: 0xC0202009 Source: connection1 Connection manager "SourceConnectionExcel" Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040154. An OLE DB record is available. Source: "Microsoft OLE DB Service Components" Hresult: 0x80040154 Description: "Class not registered". When I execute the package with the 32bit DTEXEC, task 2 fails with the following error Code: 0xC002F210 Source: Execute SQL Task Execute SQL Task Description: Executing the query "" failed with the following error: "Attempted to read or write protected memory. This is often an indication that other memory is corrupt.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. Now here is the confusing part: When I change task 2 to use the .Net provider instead of the OLE DB the package works fine. According to the MS documentation, both of these providers are supported on 32 and 64 bit so am I missing something One more thing to note: before I was able to use the 32 bit DTEXEC I had to re-register it as described in this KB article: http://support.microsoft.com/kb/919224 Tag: Does the actual update statement of a table affect Merge Replication?
- Next
  - 1
    - Constant CPU usage on server when using SQL Server 2005 Management Studio I have the same issue - Vista, SQL Management Studio with SP1 spikes the CPU in services.exe with frequent UuidCreate calls during spike. If I start management studio with no registered servers, no CPU spikes, but as soon as I register a server or connect to a server one in object explorer, spikes start. New queries do not cause spikes, so this appears to be a caused by workbench monitoring of service status. Tag: Does the actual update statement of a table affect Merge Replication?
  - 2
    - SP_Change_Users_Login It's hard to say without knowing what the purpose of these users is. It also looks like you've had this situation before the upgrade. If you just want to make all users map to the same login, you can create the login, like Raul indicated, and then you can map the users that have a different SID to this same login by using the ALTER USER ... WITH LOGIN statement that I discussed at http://blogs.msdn.com/lcris/archive/2007/02/19/sql-server-2005-some-new-security-features-in-sp2.aspx . This should make all users have that login's sid. But you should understand how you got in this situation in the first place - were these users supposed to really map to the same login From some background on how logins map to users, it may also help to take a look at this: http://blogs.msdn.com/lcris/archive/2007/03/23/basic-sql-server-security-concepts-logins-users-and-principals.aspx . Thanks Laurentiu Tag: Does the actual update statement of a table affect Merge Replication?
  - 3
    - Partitioned View Problem Hi all, I am designing 3 p:artitioned views for 3 tables. Those tables grow up in 1.5 millions of rows per month (each one), so I decided to partition those tables monthly. The issue is that if I want to create the views with more than 256 months (256 tables) SQL Server says: 'Server: Msg 106, Level 15, State 1, Procedure Jugadas, Line 258 Too many table names in the query. The maximum allowable is 256.' Is there any workaround for this Another solution maybe PD1: I've tested with less than 256 tables and it works fine, I can update and query the tables (except for a couple of querys where I've got to join 2 or more of the involucred views in which case I got a similar error saying about a 260 table limit). Tag: Does the actual update statement of a table affect Merge Replication?
  - 4
    - how to get all data from database on sql server 2005 how to get all data from database on sql server 2005 in to a file. File is include scripts can build another database as the same old database. include data in all table Tag: Does the actual update statement of a table affect Merge Replication?
  - 5
    - Linked server memory consumption Hi all, I have two database server, named it DB_A and DB_B. I want to establish a linked server of DB_A in my DB_B. There's a script in DB_B that queries data from DB_A but only execute periodically. Does linked server consume large memory or CPU when it didn't use Thanks in advance, Hery Tag: Does the actual update statement of a table affect Merge Replication?
  - 6
    - Querying 1 member from 2 hierarchies in same dimension? I've tried to do this: select ({[Date].[Fiscal].[Fiscal Year].&[2004], [Date].[Calendar].[Calendar Year].&[2004]}) on 0 from [Adventure Works] but it errors with Members belong to different hierarchies in the function. Then I tried: select ({[Date].[Fiscal].[Fiscal Year].&[2004], [Date].[Calendar].[Calendar Year].[All Periods]}, { [Date].[Fiscal].[Fiscal Year].[All Periods], [Date].[Calendar].[Calendar Year].&[2004]}) on 0 from [Adventure Works] Two sets specified in the function have different dimensionality. Tag: Does the actual update statement of a table affect Merge Replication?
  - 7
    - Visual Studio closes when data source has changed Phil Brammer wrote: Just know that using SSIS in a source control environment *can* cause problems. The XML is not easily "diff-able" and as such sometimes versions get corrupt. Just something to consider. I know people use it regularly without problems though, too. I had one client using a 3rd party source control system (sorry - cannot remember the name, but it was not Subversion) that regularly corrupted the DTSX files because it wasn't handling them as Unicode correctly. FWIW, I have had hundreds of packages in TFS for months and have never had issues with corruption. Tag: Does the actual update statement of a table affect Merge Replication?
  - 8
    - OLTP Database Design help for bank's customer table Hello,friends 1) CustomerID 2) FirstName 3) MiddleName 4) SurName 5) Title 6) Marital Status 7) Education 8) Occupation 9) Annual Income 10) Line of Business 11) DOB 12) Father Name 13) Mother Name 14) SpouseName 15) Gender 16) Email 17) MainTel 18) Home Tel 19) Passport Number 20)---------------------- 21)- - - - - - - - - - - 100)------------------- Above mentioned list is a snapshot of our customer master table ,which contain approximately 100 attributes related to a customer. We are designing an application for banking sector (but NOT Core banking solution),for which we may need to capture variable number of addresses for bank's customer,i.e more then three types of addresses Fixed,Temporary and Communication addresses(which is generally the case with all banks). A single address includes address1/address2/city/country/state/pincode fields. In context of OLTP database, We have option to put multiple addresses in child table but that involves various joins at the time of data retrival and slow down the query. As another option we can can create redundent addresses columns(address1/address2/city/country/state/pincode) in master table that will accumulate addresses if demand for more then three type addresses arises(although there is reasonable numer of extra addresses is expected, i.e 10) Database is expected to serve the records of 25 million(approx) bank's customer,so does someone can suggest me how to maintan the balance between two approches. Tag: Does the actual update statement of a table affect Merge Replication?
  - 9
    - Need drillthrough for just one month--but cube goes back two years BIGuy--we never found a solution. Tag: Does the actual update statement of a table affect Merge Replication?
  - 10
    - Data Mining Client for Excel Is it at all possible to use this tool without any connection to SQL Server (mine data in Excel Worksheets only) Or is it required to connect to SQL Server From reading the documentation, one minute I get the feeling this is possible, then the next section I get a feeling it's not. Can anyone help Thanks. Tag: Does the actual update statement of a table affect Merge Replication?
  - 11
    - microsoft decision tree algorithm Thank you for your answer, Jamie. but my question is how to split the continous INPUT attribute (The target variable is assumed automatically to be continuous in the case of regression tree). Tag: Does the actual update statement of a table affect Merge Replication?
  - 12
    - DBCC SQLPERF WaitStates / OLEDB OK ... how many of you run dbcc SQLPERF(waitstats) to display analyze SQL Server 2000 resource utilization How about sp_waitstats This is a very useful stored procedure that takes the sqlperf output and aggregates it over common wait types. If you've had to work on a sick SQL Server box, I've found this pretty useful to help pinpoint bottlenecks. While there's plenty written about the various wait types, there seems to a shortage of stuff written about acceptable or expected values! I am experiencing some performance problems with some procedures running on the EE of SQL 2000 w/SP3 on a server with 12 GB of RAM & 8 CPUs. Since no major locking issues stood out, I ventured to see what types of waits were occurring. Using both dbcc SQLPERF(waitstats) and sp_waitstats I found 98% of the waits where the OLEDB type. First I've never seen a single wait type be responsible for such a large %. For this type of wait, SQL Server is waiting for a OLE DB provider to service its request. High transactions or slow connection speeds in a distributed env are a big cause of these. This can be caused by slow authentication, outdate MDAC or incorrect DB Providers. (OK, I have to admit I haven't seen this type of wait before) Has anyone else encountered this type of wait I've seen various I/O Latch waits in the past but this is the first time I've seen OLEDB. If you've seen this, what were the steps taken to remedy this situation Thanks, JoeT Tag: Does the actual update statement of a table affect Merge Replication?
  - 13
    - Sql 2005 Management Studio I have the same requirement. If you found a solution, can you please post it Thanks, Tony Tag: Does the actual update statement of a table affect Merge Replication?
  - 14
    - DTS Package problem? I have set up a couple of DTS local packages to run ActiveX scripts creating XML files and copying them to our webserver (on the same domain). I can run them OK manually via the 'Execute' package command in the drop down list when I right click on them and also get the 'Package successfully run' message back on running them, but when I schedule them to run overnight I find the SQL Server Agent reports them as 'failed' . What am I doing wrong Tag: Does the actual update statement of a table affect Merge Replication?
  - 15
    - SQL mail using external mail server Hello We are using SQL Server 2000 SP4 Standard Edition and would like to use the e-mail function to monitor certain alerts. However, an e-mail server (SMTP server) is not installed on that box, but on a different IP address within the network. I have set up the e-mail operator, enabled e-mail in SQL Agent and set the Mail Configuration in Support Services. However, on testing I get the following error : Error 18030: xp_test_mapi_profile : Either there is no default mail client or the current mail client cannot fulfill the messaging request. Please run Microsoft Outlook and set it as the default mail client. As I cannot install Outlook on this server, I am now stuck. Has anyone a suggestion how I can overcome this issue Thanks, Marcel Tag: Does the actual update statement of a table affect Merge Replication?
  - 16
    - Synchronization fails I think Support code 80070008 has something to do with memory on the device. Go to Start => Settings => Memory and kill any un-needed processes. Then try to Sync again. SC Tag: Does the actual update statement of a table affect Merge Replication?

KeithFranklin

Suppose your using Merge Replication.

2 Users in 2 locations issue updates to the same table. 1 updating 1 column and the other updating another column. Now in reality the actual Stored Procedure issuing the update statement is passed in all the possible columns that could change and builds an update statement that updates all columns even the ones that havent changed.

Will this break Merge Replications conflict tracking Or does SQL Server 2005 Merge Replication pickup that in reality the 2 updates only in reality changed the values in 2 columns.

Top

Re: Does the actual update statement of a table affect Merge Replication?

Mahesh Dudgikar

Firstly, if you are using row level tracking, updates to different columns at 2 sites will result in a conflict.

Now, is this a user stored procedure that will do the updates to all columns If so, then yes, it will affect the conflict detection. From merge replication perspective, all columns are changed and it will flag it as a conflict.

Why do you need to update all the columns

Top