Answer Questions

• moondaddy Help please some data not replicating

  Hello, We have four mobile devices that are set up for merge replication via the web. We are not receiving errors but some of the data is not coming over to the devices. If we manually add a record that record will come over, but there is data that is on the server that isn't on the devices. If we run the snapshot for each device (We're using host_name as a filter) nothing happens. If we do validation check we get errors. If we reinitialize all devices it works but the next days data (sql job populates data to the publisher db at night) isn't on the device after syncing the next morning. Any help would be appreciated. John Do you use date or time in your filters What do your filters look like ...Show All

• Pete A Expression for visibility of a chart

  Hi, I wrote the following expression in the visibility(Hidden) property of a chart. =Iif(DateDiff( "Hour" ,Parameters!StartDate.Value ,Parameters!EndDate.Value)< 24, False , True ) And it is giving me the following error. An error occured during local report processing. The Hidden expression for the chart 'chart1' contains an error: Argument 'Interval' is not a valid value. What is the problem Sincerely, Amde The interval value must be either an enum value or a string value. You have to use either DateInterval.Hour (enum value) or "h" (string value) for the first argument of the DateDiff function. -- Robert Is the re ...Show All

• Jagadeesan Performance problems with SQL commands in data flow task

  SQL statement within an OLE DB Command component is extremely slow (hours, days). Same SQL statement executed within a query window of SQL Server Management Studio takes only a few seconds. Using a fairly simple SQL UPDATE statement against a table with only 21,000 rows. Query: UPDATE Pearson_Load SET Process_Flag = 'E', Error_Msg = 'Error: Missing address elements Address_Line_1, City, and/or State' WHERE (Address_Line_1 = ' ' OR City = ' ' OR State = ' ') AND Process_Flag = ' ' Any suggestions on how to improve the performance of this task or an alternate solution are appreciated. Thank you. Thank you Phil! I just moved the queries (I actually had 4 separate queries) that I was exec ...Show All

• js123 How disable IDENTITY on column

  Hello, I have big problem with IDENTITY column in table. I must disable this function in 500 tables in my system and i don`t know how do this :( is it such way in order to do this I understand. :( it`s a pity that we can`t disable this function on all table on one moment... thanx for help I am not clear on what you want to do. Do you want to disable it temporarily on multiple tables Or eliminate it permanently I can whip up the basis of a routine to change the identity column to no longer be an identity column, but from a further reply that doesn't seem to be what you want. You can only use SET IDENTITY_INSERT ON on only one table at a time, per connection, but ...Show All

• wakewakeup Configuration

  Hi, In my package I am using some 3 to 4 database connections. Hence I can say 3 to 4 connection managers I have. Other than that I have 2 Flat file connection manager. What will be the best way to configure the same and Please let me knowwhy that is the best choice. Thanks There is no "best" way. It depends on your environment and what works for you. Personally I use XML configuration files. And I like to have a seperate configuration file for each connection manager. And I like to use indirect configurations. but that's just me! -Jamie ...Show All

• Jstun Converting a Hex string to binary

  I am trying to write a function to convert a hex string to binary. I would like it in a function so I can use it on aggregate data in queries (instead of having to cursor through the data). So, I write my function: CREATE FUNCTION HexToBinary ( @hexstring char ( 16 )) RETURNS binary ( 8 ) AS BEGIN declare @b binary ( 8 ) , @sql nvarchar ( 255 ) S ET @sql = N 'SET @b = 0x' + @hexstring EXEC sp_executesql @sql , N '@b binary(8) out' , @b output RETURN @b END Then, I try to call my function: SELECT HexToBinary ( 'E0' ) ...and I get: Msg 195, Level 15, State 10, Line 1 'HexToBinary' is not a recognized built-in function name. However, I can get it to work if I use a slightly d ...Show All

• NickNotYet No row delimiter for Fixed Length Flat File destination?

  When I use SQL 2000 DTS Export to create a fixed length flat file, the data rows are delimited by carriage return-line. Which means that when I open the flat file in a text editor like UltraEdit or WordPad, the data rows are broken out nicely (row ends at the max row length position and new row starts at position 0). But when I use SSIS to create the file, the whole file is displayed as one line in WordPad. The data rows don't end at the max row lenght position in ultraEdit neither. From Flat File Connection Manager's Preview page, I can see the data rows are displayed properly. Now I wonder if the flat file destination is a true fixed length file. Thanks so much, Tom. Ragged Right worked! ...Show All

• Patrick.I Arithmetic Operation with Dates

  Hi I'm trying to get the difference between two dates. I need to create a Calculated member to show it. I'm using this formula PeriodDays = LastDate - FirstDate For example, I have a Time Dimension, I choose two dates: FirstDate = 07/04/2006 it's identity is 300 LastDate = 15/04/2006 it's identity is 308 PeriodDays = 308 - 300 = 8 this value I need to show in a Calculated Member The Time dimension has three levels Year, month and date What happens when I choose only a month Thanks Hi, ohh, I will try to explain again I need to get how many days are between two dates, For example, I choose two dates from my Time dimension Date1 = 07/04/2006 Date2 = 15/04/2006 Days ...Show All

• Acksoft Transaction Log woes

  I'm doing some work with sets. I start with a list of all available two member sets and put them into two tables, one labled 'tbl_master' (for lookups) and the other labled tb_2. I do some sorting and end up with something like this: tbl_master tbl_2 swap a b swap a b null 1 2 null 1 2 null 1 3 null 1 3 null 1 4 null 1 4 null 2 3 null 2 3 (there are around 140000 of these rows) (the swap column is used as part of the sorting, since the source data did not come presorted) next, I do a select into that joins tbl_2 to itself on the 'a' column, and then joins with tbl_master to check if the two b's form a valid entry in tbl_master (if so, the two 2-member sets from t ...Show All

• Joseph Stalin Sorting parameter listbox on analysis services datasource

  Hi all, How must I change the mdx that is generated for the available values for a user parameter in order to get the content sorted Regards, Henk BTW the exact mdx query is given below (and the label field of the parameter is set to 'ParameterCaption'), but I would already appreciate an example of a simple mdx. MEMBER [Measures].[ParameterCaption] AS '[Organisatie].[Level 5 naam].CURRENTMEMBER.MEMBER_CAPTION' MEMBER [Measures].[Nummer en Naam] AS '[Organisatie].[Kosten Nummer].CURRENTMEMBER.MEMBER_CAPTION +": "+ [Organisatie].[Level 5 naam].CURRENTMEMBER.MEMBER_CAPTION' -- MEMBER [Measures].[ParameterValue] AS '[Organisatie].[Level 5 naam].CURRENTMEMBER.UNIQUENAME' MEMBER [Measures].[ ...Show All

• Veerakondalu SQL Everywhere - Utter Dissapointment!

  On the surface, SQL Everywhere seems like a great way to reuse code from an enterprise app using SQL Server in a SMB or home office app needing a more But in experimenting, I have been utterly dissapointed in SQL Everywhere. Key reasons for my dissapointment are the inability to write Database Independent codeusing System.Data.Common . There are instructions for doing this in the MSDN. But do they only apply to non Microsoft Databases I have the following grievances. Are these things that Microsoft plans to fix, or do they plan to leave SQL Everywhere as an inferior product 1. Limitations of query language are not well documented nor understood. SQL Everywhere uses a "subset of Transact-SQL syntax". I have not seen it do ...Show All

• Jive Dadson Error Message: Setup Failed because MSSQL$SQLExpress is disabled for the current hardware profile

  When installing SQLEXPRESS I am getting this message: Setup failed because service MSSQL$SQLExpress is disabled for the current hardware profile. Services must be set with the current Hardware Profile logon property enabled. Anybody knows how to fix this problem Eitan Can you describe the machine you're trying to install on (architecture, os, etc) Do you have MSSQL$SQLExpress service installed at all in SCM If so go to service properties and on Log On tab enable HW profile. If the service is not installed open regedit and delete this registry key: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Hardware Profiles\Current\System\CurrentControlSet\Enum\ROOT\LEGACY_MSSQL$SQLExpr ...Show All

• George Wright Create User Roles in Reporting Server 2005

  Hi, I would like to create the folders Sales, Orders and Credit under the Home folder. The Sales folder contains a set of reports that should be accessible to a group of users, similarly Orders folder contains a set of reports that should be accessible to a group of users. I do not have facility to create user groups in SQL Reporting Service. I create a user group in my machine (from Control Panel) but Reporting service is not able to view this group. I am able to add individual users to a folder, but I would like to check if I can create a group and then add users to this group. Any help in how to resolve this issue. Cheers, Hi Jarret, Thanks!! The problem was that I have to us ...Show All

• ciM2pHat4U Stored Proc hangs

  Greetings, I have a weird thing happening. I have a stored proc that when run as a script in Query Analyzer it runs fine. When I try to run it as a stored proc it starts to run but appears to hang because it never finishes. Here is the stored proc... CREATE procedure LastNotePast60 @ContactRep varchar(50) --Name of the rep passed in AS BEGIN TRAN DECLARE @PastDate smalldatetime --Variable to hold the past 60 days date SET @PastDate = dateadd(d, -60, getdate()) --Assign the value --Create the temporary tables to hold the data as we build the final list CREATE TABLE #temppersons(personid uniqueidentifier, fname varchar(50), lname varchar(50), ownerid uniqueidentifier) CREATE TABLE #temppersons2(personid uniqueidentifier, ...Show All

• Robert F Bouillon Database constraints

  Hi i would like a suggestion from all the experts in this forum as i'am involved in design of a software package which is going to be VB6.0 as front end and SQL2005 as backend..... my question here is most of the constraints like foreign key,unique,check etc do i need to put in the sql server and increase the hardware of the server or is it better to put as a class in front end and make the client thin.... with my recent experience i had observed that a record in a master table takes 6-7 minutes to delete as it has foreign key relation with 9 other tables..... kindly put on ur opinions based upon your application experience... Thanking in advance Mat First, 6-7 'minutes' to delete a record from a table with FK relations with 9 o ...Show All