Recent content by wooddsw

I have a log shipping process running and the machine on which the subscriber is sync'ing is IO constrained. Is it possible to set Recovery Mode on the subscriber DB to SIMPLE? I know FULL is required on the publisher but is strikes me that when transactions are being applied to the subscriber...

I would appreciate any suggestions on the following code and why I'm getting the following error message: Msg 8156, Level 16, State 1, Line 14 The column 'added_by' was specified multiple times for 'A'. Code select * from sfdc..contact C inner join ( select * from avenue2..activity G...

While running DBCC ShowContig on a SQL 2000 server I've discovered some strange outputs. DBCC SHOWCONTIG scanning 'ContactLog_Audit' table... Table: 'ContactLog_Audit' (1495676376); index ID: 0, database ID: 96 TABLE level scan performed. - Pages Scanned................................: 133627...

I've basically taken the current production server image and installed it onto a test box using Symantec Server Recovery product. I changed the computer name and IP so it didn't conflict with the current production box. Installed a separate instance of SQL2000 on that server and used Sages...

I'm currently in the process of decommissioning AccPac due to a merger. My current configuration is an application server which connects to our may SQL server that houses the databases. I'm attempting to install a local copy of SQL2000 on the app server and ultimately disconnect it from the...

Just discovered my own solution.... When creating the Calculated Field, I just need to use the 2 fields from the data source, in this case Target and Distinct Call fields, in their own formula. ie. =Target/DistinctCall When these 2 fields are using in the aggregate calculation the summary of...

I understand I can create a calculated field but I need to reference the summary cells within the PivotTable and they aren't available in the Fields listbox of data source columns to choose from. When I try and paste the following formula into the Insert Calculated Field and add it i get...

I have a pivot table that resembles: Calls Targets January 100 25 February 50 10 March 25 5 etc I need to calculate a ratio from this pivot table which I can do in the cell adjacent to the Targets value and copy down all...

Found out I can add this line to the end of the formula ' ' The formula will then return a blank character rather than the array. Crystal formulas return the last value they evaluate. In this case it is the array declaration and thus an array is being returned. I did have to change the...

I have a Main/Sub report task that I'm trying to modify. The report is a sales call tracking report and the sub report gathers time off territory from the database which is used in calculating a calls per day average. This subreport fires from the main report header one time and collects...

Just encountered a problem today with our FTP site exceeding our T1 bandwidth capacity and impacting all connectivity. When the FTP service is stopped processing goes back to normal. This FTP site is used for SalesLogix CRM and there are no files in any of the directories where staging of...

I am using PrintReport. I did just this morning resolve it. Rather I should say stumbled on it. It appears it was the RunAs credentials as I suspected. I tried several different logons and then when back to my own logon and it started working. It worked only once so far so I'm going to...

I have a VB 6.0 SP6 application that processes order files. It is setup to run either unattended as a scheduled task with a command line parameter or via a form interface. The appl generates a report at the end of the run via a Datareport designer. Now the bug… When I run the appl via the...

I’ve developed the attached query that needed to perform a Union. Previously a view, this query now needed to incorporate a dynamic where clause as well as receive a ‘Product’ parameter. The conditional logic works properly when executed in ISQL. When attempting to use this SP as a datasource...

When looking at TOP 2 I was surprise to see that the result in TOP 1 (2004 date) wasn't the max date (2006 date). I really only want the TOP 1 result to be correct (2006 date)