Answer Questions

• Vesa Problem with remote replication

  I have a number of dialup users who are trying to replicate against a master database.The first few times worked fine.but now each user is getting the following message "The process could not change generation history at the publisher" Any help or pointers gratefully received many thanks David J. Thanks, do you mean increasing timeout in SQL Enterprise Managers properties If it is ...Show All

• kjmsolutions Deserialization failed: version 2.0 is not a compatible version

  I saw this question before with no answer. I'm trying to develop reports in SQL RS 2000 and Visual Studio 2003. My machine has both SQL 2000 & SQL 2005, SQL RS 2000 & SQL RS 2005, VS 2003 & VS 2005 installed. When I try and open an RS 2000 report in VS 2003, I get the following error: Microsoft Development Environment is unable to load this document: Deserialization failed: Version 2.0 is not a compatible version. The ...Show All

• pps Working with SQL Server 2000 diagrams

  I upgraded my laptop from SQL 2000 to SQL 2005 (Developer Edition). I cannot able to see database diagrams in SQL Server 2005 through SQL Server Management Studio.   Note: If I go to the local machine I can able to see it (the local/remote machine running SQL Server 2000 Standard Edition )   any ideas would be greatly appreciated.         Thanks Michelle Di ...Show All

• davros-too get unspecified error when browsing data of CUBE in Analysis servise

  Please give me solution, I am getting this message when I am browsing data of cude "Unable to browse data of <cude name>    unspecified error" please tell me the solution of this. Sir, I have SQL Server 2000 installed on Windows 2000 Advance Server. On same machine I installed MS Analysis servise. By default Analysis service have FoodMart2000 database which have some cubes and dimension. When I right click on c ...Show All

• macky100 June CTP: cannot install: Office 2003 Web Components

  THe June CTP of Sql Server 2005 fails with this message: Please insert the disk: Microsoft Office 2003 Web Components. [Ok] [Cancel] Of course: (1)  I already had Office 2003 web components installed, and had performed a re-installation just to make sure. (2)  Inserting my disk of Office 2003 Pro does not work. (3)  The dialog box does not let you browse on disk. (4)  I have no indication of what specific file it wants. (5)&n ...Show All

• Seven Alive Only apply border to left and right of stacked column bar chart

  Hi. Is it in anyway possible to only add borders to left and right sides of a column in a bar chart. I can see in the xsl definition schema that style does allow left, right, top, bottom tags. But if i replace the <Default>4.5pt</Default> with left, right, top and bottom and accordingly 4.5pt and None - the result doesnt seem to be any different. What i need to do is to create columns like this where y is for instance Yellow and b i ...Show All

• Perry G. Transmission Queue problem

  " noWrap width="1%" bgColor=#b71c0c> 1. Yosi   29 Temmuz 12:19     secenekleri goster Gonderen: "Yosi" <yus ... @bizitek.com> - Bu yazar n yazd mesajlar bul Tarih: Fri, 29 Jul 2005 02:19:00 -0700 Konu: Service Broker Cevapla | Yazara Cevap Ver | let | Yazd r | Sadece Mesaj | Asl n goster | Kald r | Kotuye Kullan m Bildir I'm trying the service broker features of SQL Serv ...Show All

• Jimmm Performance with simple calc on FirstNonEmpty

  Asume a simple query with a view measures on columns and 100 of 2000 members of a parent child dimension on rows. ==> Profiler Query duration 950 ms Added a calculation member - code see below and include the member in the query the response time ==> Profiler Query duration 5500 ms increaes about 500%! The special point "Effective area in m2" uses the "FirstNonEmpty" Aggregate function - while we switch for testing to ...Show All

• Tonny Petersen TCP low window when connecting to SQL 2000 Server and make a request

  Hello to all ;o) I have a big problem with our SQL Server and XP Clients. SQL 2000 with Windows Server 2003, 1GB 3Com 3C996-SX Fiber Card Clients Windows XP Pro SP1 When i transfer Files to the SQL Server all seem to be okay. But when i try to request data from SQL over a special Client which collects data from the SQL database, i often get a TCP low window and the client breaks the connection with some stupid errors. Sometimes ...Show All

• Tvercel Paging large Results in SQL 2005

  lets say we have more than 100 000 rows in Table1, and we want to view each 10 rows alone.... and by pressing on a NEXT button we will see the other 10 pages.... there is 2 buttons : NEXT and PREVIOUS so can anyone tell me how to do that in SQL 2005, and what is correctly called. I have found a code that does use ROW_NUMBER in order to view results between 2 numbers, example: rows between 10 and 50.... but It is not what I want, so please I need ...Show All

• Digital-Pioneer Data Access Differences in SQL Server 2005

  Hello, We have a large set of applications that we developed and build for use with Borland InterBase (5.x-7.x). We have moved/migrated off of Borland InterBase to MS SQL Server 2005. We are find some situations where InterBase was an more elegant solution and finding it difficult to find the right way to change our applications to achieve the same result. In InterBase, our Database Transactions allowed our user to make changes to the DB ...Show All

• CapTain BLue SQLExpress ASP3.0 Permissions and Connectivity

  I'm teaching a class where the curriculum uses ASP 3.0, I thought it would be a good idea to introduce the students to VSNET 2005 web express as an editor and SQL2005 Express for a database. I'm having second thoughts since I can't seem to get ASP to successfully access the database (No problems with ASP.NET) OS: XP pro I've created the following in the Database: A simple database using managment studio ASQL login for the IUSR_ (a ...Show All

• BoseMK Error in Deploying an Analysis Services Project

  Hi, I am trying to deploy an Analysis Project and I get the error: Error 1 The Description element at line 292, column 29 (namespace http://schemas.microsoft.com/analysisservices/2003/engine ) cannot appear under Envelope/Body/Execute/Command/Batch/Alter/ObjectDefinition/Database/Cubes/Cube/Dimensions/Dimension. 0 0 Any idea Thanks in advance, --Dimitris Doukas Hi, This is a defect th ...Show All

• CSharpNewbie22 PrimeOutput : difference between 'Output' and 'output buffer'

  When overriding the PrimeOutput method in a custom component, you get as parameters the outputIDs and the output buffers (of type PipelineBuffer). using the outputIDs you can get IDTSOutput90 outputs. As I interpret things, each output is associated with one output buffer. When you want to output rows, you add rows to the buffer. But what do you use the output (IDTSOutput90) for Regards, Henk If you have ...Show All

• zu Show / Hide Parameters on a Report

  Is there any way to get the parameters to remain visible after clicking on a report link Currently, when I click my report link and pass parameters, the new report loads with all the parameters hidden even though they normally appear fine when you go to the report straight. Now, there is a way to make them visible by clicking the "Show / Hide Parameters" button on the far right of the screen. However, I would really like to hear of a way ...Show All