Answer Questions

• Danny_FADBA Enable and disable websync.log

  Hi, is there a way how to enable / disable logging on web merge synchronization into the file websync.log The file exists in the ISAPI folder, on some machines there are some messages, on others there is nothing. There are Timeout messages on the client during synchronization and we need to find where is the problem, if it is on the server side or if it is a network error or something else. Thanks, Pavel ReplIsapi Settings: Property Value SNAC version (sqlncli.dll) 2005.90.1399.0 Logging Enabled FALSE The web sync log should be enabled by default. On the IE replisapi.dll diag page, what do you see the status as ReplIsapi Settings ...Show All

• Taliesin* Data Type in DSV

  I have Varchar column called "Age", which capture patient age. and I am trying to use grouping property of the Age dimension, since it is varchar type, the grouping is messed up, such as 20 - 4, 40 - 5. So I say, ok, I need to cast to int, so I change my age dimension to int, but the fact table need to be changed too, so I did cast(age as int) as Age, however I got error: maxlength applies to string data type only, you cannot set column 'Age' property MaxLength to be non-negative number. Any advice Dear Friend, First when U Chages any data type in Fact Table. First remove all references in Cube. Suppose U want to change Age Datatype then first remove Age Measures from Cube or if any other reference is there like ...Show All

• Paul B. (SubReports) Is it possible to...

  Here's my dilema. Our organization has two db servers. One is Oracle and the other is SQL Server. Oracle contains our HR information on all employees and SQL Server contains information on various projects that we are undertaking. The HR system (Oracle) contains Employee ID's, Names, addresses, phone numbers, etc. SQL Server has information about the varous projects and Employee ID's of who is assigned to those projects. I have a report that has two data sources (one to each server) and two datasets (each populated from the two datasources). I would like to have a single table that displays the project and the name of the person who's assigned to that project. This would be achieved by linking the tables on similar information, which is th ...Show All

• Sanjeevani Slow Cube Performance in Excel

  Hi all, I have an Analysis Services 2005 cube that I am linking to in Excel 2003 via a pivot table. The cube is based on a single fact table with around 6 million rows and 7 measures. I have 5 dimensions, none of which have more than around 200 rows. I have set up aggregation and am using MOLAP. My problem is that querying the cube in Excel takes around one minute, whilst performing the same query in the cube browser in BI studio is instant. I have captured the MDX for each of these in Profiler. The scripts are below. BI Studio SELECT NON EMPTY [{59956A97-57AB-4CAF-8A5B-E7753FDA221C}Pivot16Axis0Set0] DIMENSION PROPERTIES MEMBER_NAME, PARENT_UNIQUE_NAME ON COLUMNS, NON EMPTY [{59956A97-57AB-4CAF-8A5B-E7753FDA221C}Pivot16Axis ...Show All

• SOG Luebeck Hidden columns/blank PDF page(s)

  I have been trying for some time to create a columnar report where certain columns can be hidden as requested by the user. I have tried placing the complete column set in the report, and then hiding a subset of columns, but blank pages are produced when rendered to PDF since the report body does not appear to shrink as columns are hidden and justify themselves to the left. I have tried a table, list, and matrix to no avail... Does anyone know of a workaround, a trick, or even a hack that may accomplish what I am after Thanks. Oh well, guess there is no way to do it. I have seen many other posts of people trying to do the same thing. I wish someone from Microsoft would just say it's impossible so I could forget about tryin ...Show All

• Scott McKeown Package changes made and saved revert to prior state when package closed and re-opened

  I copied and added an existing package as a new package to a project and have been having trouble with settings reverting to those for the original package after I modify and save the changes for the new package. Sometimes happens with the save itself, other times it happens when I close and re-open the package. Most cases are with connections that revert back to the original file reference, but there are also control flow and data flow elements that keep reverting back to either settings from the original package or defaults that result in the re-opened package being in error. Not sure how to get around this issue short of developing the new package from scratch which I'd rather not do since it is fairly complex. Any help anyone can provi ...Show All

• hanumanth Ordering data in SQL EE by VB

  How I can ordering data in SQL EE by VB 2005 EE. Thanks. Imports System Imports System.Collections.Generic Imports System.ComponentModel Imports System.Data Imports System.Drawing Imports System.Text Imports System.Windows.Forms Imports System.Data.SqlClient Imports System.Diagnostics Imports System.Configuration Public Class Form1 Private Sub Table1BindingNavigatorSaveItem_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Me .Validate() Me .Table1BindingSource.EndEdit() Me .Table1TableAdapter.Update( Me .Database1DataSet.Table1) End Sub Private Sub Form1_Load( ByVal sender As System.Obj ...Show All

• stensby Between + '%'

  helloo I have this table Id Code -- -------- 1 10101001 2 10101002 3 10102001 4 10102002 5 60101001 6 60101002 7 60102001 8 60102002 9 60201001 10 60201002 11 70101001 12 70101002 I need to query this table by the following (select id, code from table1 where code between '1' + '%' and '7' +'%') to get all values of codes between (code starting with 1) and (code starting with 7) or for example: (select id, code from table1 where code between '602' + '%' and '7' +'%') ------------------------------------------------------------------------- Im not getting correct answers or let be specific in the second query im not getting codes starting with 7, im only getting codes >= 602 but less that 7, so 7 is not incl ...Show All

• Jacobeo Job Activity Monitor

  Is there any way to modify the layout of the Job Activity Monitor After I resize columns and/or the size of the window, when I close the window it does not save. I assume this is a "feature". Any plans on fixing this Thanks!!! No, this is not possible.  This would be a good suggestion to file on Microsoft Connect: http://connect.microsoft.com/SQLServer/Feedback/ . Paul A. Mestemaker II Program Manager Microsoft SQL Server Manageability http://blogs.msdn.com/sqlrem/ I agree, you open the Job activity monitor, size the screen exactly how you like it, widen the left pane so you can see the job names in full, pull up the splitter so you can see more of the history det ...Show All

• eginde xp_instance_regread whitespace escape character

  When I try and run the following: exec master.dbo.xp_instance_regread N'HKEY_LOCAL_MACHINE', N'Software\Microsoft\MSSQLServer\MSSQLServe\ExtendedProcedures', N'Xp_regread&Allowed&Paths', @SmoDefaultFile OUTPUT SELECT ISNULL(@SmoDefaultFile,N'') AS [DefaultFile] It returns an empty result set - but it WORKS if I choose something in the registry without whitespaces. Does any one know what the escape character is or if it is & why doesnt this work Found workaround, used Andrew Novick's xp_regread wrapper displayed here: http://www.novicksoftware.com/UDFofWeek/Vol2/T-SQL-UDF-Vol-2-Num-41-udf_Sys_RegReadStr.htm ...Show All

• Anthony Bellissimo Report Builder: Add custom parameter in the filter?

  I need to add a custom filter that is not part of the model's fields. It just a static param that needed for calculate the report total cost column. For example: prompt user for Cost in the filter, then output the Total Cost as a result of Cost * #Items(in the model). I know this can be easily done in Report Designer Value expression. Can it be done in Report builder ...Show All

• davidlks Specify excel sheet as a configuration property.

  Hi, I'm just starting with SSIS and want to create a reusable package which imports from an excel file which can be specified at runtime. I can expose the filename of the excel file as part of the connectionString property but the sheet is the openrowset property which is a custom property and therefore isn't exposed as part of the external configuration. Does this make sense Is there an easy way to specify the sheet to import at run time Regards, Anthony. Hi: I have a variable which changes my sheet name in a dynamic sql string. (the string is elect * from [Sheet1$] where keyfield is not null) When I try use this in Excel Source Editor - SQL Command from variable, I get an error: Code:0x8 ...Show All

• Kennon2005 Problems importing access reports

  I am trying to import my access reports into Reporting services and it doesn't seem to be working.. i am getting this message in my OutPut box in VS 2003 " Error : An error occurred while the report [REPORT NAME] was being imported: The server threw an exception. " it ended up not importing even one report out of over 100+ reports!! just wondering what could be the problem and how could i fix it Current actions already taken: "updated reporting services to SP4", "updated SQL server to SQL Server 2000 3a", and "lastly i am downloading the SP1 for VS 2003 and will install it" Just wondering if someone else had already ran into this problem and cause help me out.. ...Show All

• Fabrice MARGUERIE While exporting to Excel, some cells have wrong border style.

  Hi! May be someone already had this issue While i do export - it goes just fine, but border style of some cells goes wrong.. And i just can't find why - style setting seems to be the same. For, example i have this style set to sell, but i end up with having all borders in Excel document. In 'Properties' Default style for border is set to None. <Style> <BorderStyle> <Left>Solid</Left> <Right>Solid</Right> </BorderStyle> <TextAlign>Right</TextAlign> <PaddingLeft>2pt</PaddingLeft> <PaddingBottom>2pt</PaddingBottom> <BackgroundColor>=IIf( RowNumber(Nothing) Mod 2, "#ECE9D8", "White" )</BackgroundColor> <PaddingRig ...Show All

• kdancer100 Retrieving actual sales value from the Time Series Model

  Hi, I have built a Sales Forecast model to predict the sales value. Along with making historic predictions for previous time periods I also want to retrieve the actual sales values for those periods. How can I achieve this in a time series model I also would like to know how do mining models store the data. Do they store the data in the same table/view format as their respecive data source view or in the Model Content format. Thanks Jamie Use SELECT * FROM [Model Name].CASES You will get the data back in (essentially) the data source view format. ...Show All