.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
hdjk11
Shivakumaran
dfefde5
hoangnganvy1993
Post New Web Links

SQL Server 2008: Replication of IndexedView does not work correct anymore(did work in sql 2005)

Posted By:      Posted Date: November 02, 2010    Points: 0   Category :Sql Server
 

Hi,

 

I am encountering a problem with replication of an indexed view.

My current flow works fine on SQL Server 2005 (enterp.) But is does not work anymore on SQL Server 2008 (enterp.)

 

Situation:

On my server(server1), i receive 2 tables via replication from another server(server0). (lets name them tTest1 and tTest2)

I create an indexed view based on those 2 tables. (lets name it idxvTest)

This indexed view(idxvTest) is then replicated to another server(server2), and materialized as a table (tTestidxv).

Any changes made to the tables on server0, are replicated via server1 to server2.

 

The above situation worked fine in SQL 2005.

However in SQL 2008, i don't get any error messages in the replication, and everything seems to work fine..

But as it appears, changes entered at server0 are being replicated to server1, also the view idxvTest looks fine, but the data is not updated/inserted on the table at server2(tTestidxv)!!

Note: initial setup of the replication from server1 to server2 works correctly, and the snapshot is also delivered. Only the updates after the snapshot don't come through.




View Complete Post


More Related Resource Links

Getting SSRS 2005 to work on Server 2008 R2

  

I reinstalled SQL Server 2005 x64 Standard Edition SP3 on a Server 2008 R2 box and installed IIS and SSRS as well.  SQL runs fine. SSRS is installed all configs look good, but I cannot get it accessible via the browser (//localhost/ReportServeror //localhost/Reports). 

I have tried both 32 & 64 defaults in IIS AppPools and each gives me an error and I can't find any other resources as to what the problem is?

32-bit setting is giving me this error on /ReportServer:

Could not load file or assembly 'ReportingServicesNativeClient, Version=0.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. An attempt was made to load a program with an incorrect format.

64-bit setting is giving me this error on /ReportServer:

HTTP Error 500.0 - Internal Server Error, Error Code 0x800700c1

32 & 64-bit setting are both giving me this error on /Reports:

HTTP Error 401.2 - Unauthorized, Error Code0x80070005



Replication between SQL Server 2005 and SQL Server 2008

  
Hi,    We were using SQL Server Transactional Replication between two SQL Server 2005 servers. Now we are going to upgrade the Publisher server to SQL Server 2008, Distributor Server remains as SQL Server 2005.     Can anyone let me know what is the challenges we need to face when configuring Replication between SQL Server 2005 and SQL Server 2008. Replication Method - Transactional Replication Distributor/Subscriber - SQL Server 2005 Publisher     -  SQL Server 208 Regards, Fazlu.

Using SQL Server Replication for SQL Server 2005 and 2008

  
I have an ASP.NET application that uses replication, and uses the RMO DLLs to do this. I initially built the application against the 2005 version of the DLLs and have it running successfully against SQL Server 2005. However, when I try running it against SQL Server 2008 it doesn't work. Initially I didn't deploy the Microsoft.SqlServer.* DLLs with my app - instead relying on them being in place on the server on which it was installed. However, when trying to make it work against SQL Server 2008 it was looking for the 2005 version DLLs which it wasn't able to locate. Following some other advice I read online I have now swapped out the 2005 DLLs and referenced the 2008 assemblies in my .NET project. In my MSI I now also deploy (i.e. redistribute) the SQL Server 2008 DLLs to the bin folder of my ASP.NET project. Now, when I try to run the application against SQL Server 2005 it fails to load the Microsoft.SqlServer.Replication assembly. I run depends.exe against this and find that it's dependent on SQLNCLI10.DLL which is missing on my machine with only SQL Server 2005 on it. So, what am I to do? Is this possible? How do I get around this?

SSIS 2005 & 2008 BIDS and VS2005/2008 Will VS2010 work with either SSIS package?

  
I've read the old posts about having to have the BIDS version match the SSIS package version. My question is with VS2010 is there any change? Can I edit either of the old versions of SSIS packages in VS2010 or do I have to have 3 versions of Visual Studio/BIDS on my machine? TIA J

New SQL server 2008 connectioin will not work using hostname

  

We are trying to create an ODBC connection from a terminal server running server 2008 to a SQL server 2008 (also on a server 2008). When creating the connection from a server 2003 terminal server the connection is successful and i am able to gain access to my databases. However, when trying to create the same connection from the server 2008 terminal server we get an error that the server does not exist or access is denied. We have gotten the connection to work on the server 2008 terminal server but only if we use the FQDN or the IP address. We need to be able to use the hostname to make the connection easier for users who are making connections to the SQL server using access or excel.  WE have exhausted our efforts to correct this problem. We have checked DNS records and created a service principal name (SPN) in active directory. Thank you in advance for your help in resolving this issue.


"PivotTable.DisplayEmptyRows = false " in Excel pulling from Analysis Server 2008, doesn't work.

  

We display financial information, using Excel pulling from Analysis Server 2008.

 

In vba,  "ptTemp.DisplayEmptyRow = false" works fine for hiding empty rows of data on most pivot tables, but if the "account numbers" parent/child dimension is in the row fields, it doesn't.

 

The row Dimension look like this:

 

Balance Sheet

Assets

Current Assets

Cash

Total Balance Sheet

 

Income Statement

Gross Profit

Revenue

Item A

….

Total Income Statement

SQL Server 2005 Maintenance Plans - Reporting And Logging Does Not Work

  

I have a maintenance plan built on a SQL Server 2005 instance that rebuilds indexes, rebuilds statistics, checks for database integrity, performs a maintenance cleanup, and performs a history cleanup.  This job runs once per week.

In the "Reporting and Logging" section I have the following options:

- Generate a text file report is checked

- Create a new file is selected

- A valid destination folder is identified

- Send report to an email recipient is checked

- A valid agent operator is selected

- Log extended information is checked

The job seems to complete successfully and a report is created and emailed, but the only information in the report is as follows:

Quest SLSSQLMaint Utility.
Logging on to SQL Server 'DEVSQL01' with Windows Authentication
Logged on to SQL Server 'DEVSQL01'

[1] Delete old text report files...
[1] Execution Time: 0 hrs, 0 mins, 0 secs.


[2] Send DBMail or SendMail report file....

[2] Execution Time: 0 hrs, 0 mins, 1 secs.

End of maintenance plan 'DB Maintenance Plan (No Backups) [DB Maintenance]' on 9/29/2010 8:40:49 PM (Success)
C:\Program Files\Microsoft SQL Server\MSSQL.4\MSSQL\Binn\slssqlmaint.exe Process Exit Code: 0 (Success)

Where is the information about the rest of the maintenance plan?&nbs

Export PDF in ssrs 2008 vs ssrs 2005 - pdf is different, won't work with itextsharp (possibly other

  
We're migrating from SSRS 2005 to SSRS 2008. We use itextsharp (a pdf processing library) to merge different PDF outputs into one large PDF file. This was working brilliantly in SSRS 2005, but in SSRS 2008, itextsharp *can* open and parse the PDF, but itext sees the "content" section of the PDF pages as blank. So, the resulting composite PDF ends up being a series of blank pages. Acrobat 9 and a couple other PDF tools (tested linux Evince and win GIMP) seem to be able to open the SSRS 2008-generated PDF fine, but the java-version of itext, and the .net version of itext (itextsharp) see nothing but blanks.
So, I realize this points to a problem with itext, but I'm curious if anyone else is merging PDFS outputed from SSRS 2008, and what PDF tools/libraries they are using.

Much thanks!
EDonoho

Merge Replication between SQL Server 2005 and SQL Server 2008

  

Hi,

We are planning to implement Merge Replication between SQL Server 2008 "Not R2 Version" (Publisher) and SQL Server 2005 (Subscriber). Will this setup work, or there are some limitations ?


64 bit Windows 7 + Excel 2010 beta + SQL Server 2008 Enterprise SP1 = My DM Add-in does not work

  
I'm running W7 + Excel 2010 beta + SQL Server 2008 Enterprise on a full 64-bit PC.  My SQL Server 2008 DM Add-in installs properly (throws no errors), but neither the Data Mining nor Table Analyzer tabs show up on the Excel ribbon & are not available in the Add-in dialog box.  I also have all of the above on a 32-bit laptop, and both DM tabs ARE available on the Excel ribbon and seem to function properly.

As a test I uninstalled the add-in from both machines and reinstalled.  The issue was the same; the add-in shows up on Excel running in the 32-bit environment but not on the 64-bit environment. 

Question:  Is this problem due to the 64-bit environment, or could it be something else?

MERGE Replication between SQL Server 2005 to SQL Server 2008 R2

  

Hi, i have a publisher with 3 publications with below SQL

Microsoft SQL Server 2005 - 9.00.4035.00 (Intel X86)   Nov 24 2008 13:01:59   Copyright (c) 1988-2005 Microsoft Corporation  Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2)

I want to add a subscriber to the server with below SQL

Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64)   Apr  2 2010 15:48:46   Copyright (c) Microsoft Corporation  Enterprise Edition (64-bit) on Windows NT 6.0 <X64> (Build 6002: Service Pack 2) (VM)

Now when i am trying to add subscritpion to the 2008 R2 server on the publication server, i am getting below message

TITLE: New Subscription Wizard
------------------------------

For merge publications, the version of the Subscriber must not exceed the version of the Publisher.

------------------------------
BUTTONS:

OK
------------------------------

Is merge replication not possible between the 2?? Please advice. I beliwve Microsoft's new releases should support its older versions...



SQL Server 2008 / 2005 Databases Replication

  

Domain One - abc.com (IP Address scheme - 185.192.X.X)
Domain Two - xyz.com (IP Address scheme - 10.200.X.X)

There is a Forest level trust between those 2 domains.

Can you please help me if there is there any way that I can replicate the datas in 185.192.1.200 Server to 10.200.18.15 Server (which has both Ms Sql Server 2005 on it) - which will have same database in both servers. There is a chance to link those 2 servers in those 2 networks and store datas at the same time on each servers. So that if one goes down, staffs can log into another one without any down-time to access data from another server's database (which is the replica of the primary DB server). Please let me know & also if there is any good resource about that the same.


VT

Which types of replication for SQL Server 2008 R2 Replication To SQL Server 2005?

  

We have two SQL Servers, we plan to use replication to sync data from SQL 2008 R2 (one way) to SQL 2005

publisher and distributer : SQL2008R2
subscriber: SQL2005

which type of replication to apply on our case?

Snapshot, Transactional, Merge or Peer-to-Peer.

 



C++ at Work: Managed Code in Visual Studio 2005

  

Many of you are no doubt in the process of upgrading to Visual Studio® 2005, so I thought now would be a good time to relate some of my own experiences with the new compiler. What took me so long? Hey, I'm a retro kind of guy! Better late than never!.

Paul DiLascia

MSDN Magazine June 2006


AsyncPostBackTrigger doesn't work on server..

  

Hi, 
 I am new to asp.net and ajax. I have a problem while using update panel.
I have a tabcontainer with 3-4 tab panels. Inside one tab panel there is a cancel button. What i want to do is to when i hit cancel button in code behind i change active tab index to 0 so that tabcontainer shows first tab panel. I have update panel around tab container. This works at my localhost. But on server its behavior is very random. Sometimes it works sometime it doesn't. Unfortunately I am not able to debug it also. I don't know how to debug code on server. As on localhost it works correctly so I am kind of stuck. 

SQL server 2005 2008

  

i cant install sql server 2005 nor 2008 on my windows 7 os

i read about somthing like adding new account when installing sql 2008 to provision the server or so, but didnt know how,,,

can you plz help me??

 


SQL Server 2005 Merge Replication

  
We did the following: We setup a database with all of standard tables, views, etc. We then put in place merge replication for a few of the tables within this database, including a tables called "Areas". We can execute SQL statements to insert rows into this table fine. We then applied an update script for this database to change a few tables by adding fields and changing indexes, etc.  We didn't change the "Areas" table though. After the update to the database structure, we get an error when trying to insert into this "Areas" table. The error message was the following: The insert failed. It conflicted with an identity range check constraint in database 'AETest', replicated table 'dbo.Areas', column 'AREPrimaryId'. If the identity column is automatically managed by replication, update the range as follows: for the Publisher, execute sp_adjustpublisheridentityrange; for the Subscriber, run the Distribution Agent or the Merge Agent.  The statement has been terminated.   What would cause such a problem and how do we resolve it?  The structure of the "Areas" table before and after the update is the following: USE   [AETest] GO /****** Object: Table [dbo].[Areas] Script Date: 08/24/2010 17:42:36 ******/ SET   ANSI_NULLS ON GO SET   QUOTED_IDENTIFIER ON GO SET   ANSI_PADDING ON
Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend