Answer Questions

• M.KhoshZaban Service Broker 64-bit Edition

  Does anyone know if the Service Broker is supported on the 64-bit edition of SQL 2005 Thanks! yes.it supports 64-bit. I am using one 4 64bit CPUs with 32 G memory's server for testing,now it's woking perfect. Sure is, both in Itanium and AMD64. Also, 64-bit editions can communicate with 32-bit editions and the other way around. HTH, ~ Remus ...Show All

• Don Parsons Calculated Members slow to display in Excel PivotTable

  Hi, I have created an Analysis Services 2005 cube, and am viewing it using an Excel PivotTable. When using Excel 2003, normal members display instantly, but when I place a calculated member in the PivotTable's data area it sits for several minutes before displaying. The calculated member (Gross Margin Percentage) was created with the expression: [Measures].[Gross Margin]/[Measures].[Net Sale] Net Sale is a data field from the Data Sourc ...Show All

• Juany Can This Be Accomplished in My Time Dimension in my AS2005 Cube?

  In my AS2005 cube, I have a time dimension with the following attributes: year, quarter and month. Also, there is currently no hierarchy by design. Is there a way to make a custom attribute/time period that reflects the last 12 months (R12M) and work in the same manner such as year, quarter and month The time dimension would then have: years, quarter, month and R12M. As a result, a user can drop a measure such as Sales Amt and then add ...Show All

• ZBufferMan Receving error with no description

  I have designed quite a few reports over the past few weeks, and today I received the following error: An error occured during local report processing. The definition of the report /Discharge7.rdl is invalid. Exception of type: 'Microsoft.ReportingServices.ReportProcessing.ReportProcessingException' was thrown. I've never seen this error before. I've gotten errors with typos in names of fields in my expressions, but I've never gotten an error ...Show All

• Hollow.e Unable to install SQL SERVER 2005 Books online

  Hi,   I am trying to install sql server 2005 books online after downloading the file    SQLServer2k5_BOL.msi from microsoft downloads. I have Windows XP SP2 and .net framework sp1. I am receiving the following error message when double clicking on the installer file "This installation package cannot be installed by the windows installer service. You must install a windows service pack that contains a newer version ...Show All

• betolea Deployment 'utility' script using sqlcmd

  Hi all, I'm looking at creating a sample utility script that will invoking scripts to deploy some SQL code. For example, a utlity script that will run a SQL script, and on successful completion, execute the next script. Having not used SQLCMD at all before, and being very new to SQL2005 (< 1 month) please guide me if there is a better way of invoking this... For example, a way of avoiding the xp_cmdshell invocation! The fol ...Show All

• McPlot SQL Server Enterprise Manager

  I am trying desparately to build a user defined function on the Microsoft SQL Server 2000 viewer and when it is performed I get the following message: [Microsoft][ODB SQL Server Driver][SQL Server] Maximum stored procedure , function, trigger, or view nesting level exceeded Is there any problem using sql MAX() built in function How can I resolve this issue The UDF code is: CREATE FUNCTION TestFunc (@Syn int) RETURNS int AS BEGIN IF @Syn IS NUL ...Show All

• decrypted Major problem with REPLACE-expression in the Derived Column Transformation

  I'm importing a csv-file delimited with semicolons. Firstly I LTRIM the columns "in place" and the data imports fine. All the numbers in right columns in the target table. Then I add another Derived Colum Transformation to replace decimal character comma (,) to a dot (.) in order to convert the string/varchar value to numeric. But here I run into trouble. Running the task ends in success but the result in the target table (same as abov ...Show All

• Jason Honingford DatabaseMail setup problems

  I'm bust to setup a mail nothification system by using DatabaseMail. The setup of the database mail was ok. I'm able to send a test mail. After that I modified the SQLAgent's Alert system. I enabled the mail profile and as Mailsystem i choosed Database Mail with the mail profile the one I created in during the database mail setup. No I like to use this when a job fails or an alert is fired. So I created an operator. ...Show All

• videomontbleu Virtual Labs - No Connection message

  A couple of us are trying to use the SQL Server 2005 Virtual labs at http://msdn.microsoft.com/sql/  .  We complete all the prelim steps successfully but when we click on "Start the Lab" we get a blank page with "No Connection" in the middle.  The clock ticks and the system thinks we are doing the lab.  How can we get a connection   or is the server down   or are there no available resources left ...Show All

• Rana Basu SQL Replication

  I have an end-user question about what replication solutions are available in SQL 2005 for the following configuration. We are looking for a replication option that will allow instant replication of changes made to the database at a remote office with a WAN connection. This is a manufacturing operation and the aplication in use requires those changes to be instantly replicated to the primary SQL server located in the data center. The vendor tha ...Show All

• Ralf_from_Europe yukon's transactional replication

  Hi yukon gurus, Does yukon transactional replication supports immediate update on subscriber with text, image and binary data types tnx and regards, ArisenX y thank you very much for all the response, i'll test it and i'll send a feed back... best regards and more power to all of us! Yes, changes to the publisher will be replicated to the subscriber, provide you do not use WRITETEXT and UPDATETEXT. ...Show All

• John Cramer System.Transactions issues

  Hi Is it necessary to have the connection open code inside the transaction scope to be able to use transaction features. I wrote a code which has the connection.open outside the transaction scope and it wasn’t working correctly. When i moved the connection.open inside the transaction scope it started working fine. Apart from this is there any special setting i need to do (DTC related) while working with System.Transaction and SQL Server 2000. ...Show All

• 10e matrixData parameter scope must be set to a string constant

  Hi all, I am using the runningValue to set alternating color for the MatrixColumn I have. Basically I have 2 dynamic Columns, group 2 is under group1. Group1 is Catagory, Group2 is Style. The data field is one field - in this case, sales. I need to alternate background color for each catagory. I used iif(runningValue(Field!Catagory_Name.Value,CountDistinct,Nothing) Mod 2, "#...","#...") to set backgroundColor for Group1 ...Show All

• Joie Cariaga Reporting Services - Variables/Parameters - Is this a bug?

  When creating a Reporting Services report and declaring local variables as part of your query in a dataset there is sometimes a problem. When you hit run in the Data section and the “Define Query Parameters” box pops up, all the variables are not there. Sometimes when you go to properties (…) of that dataset the parameters are gone. Is this a bug This is happening both in RS2000 and 2005. Thanks Not an ...Show All