Search results for query: *

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'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...

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...

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 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...

I'm working on returning the most recent history record for a specific contact. I tried the MAX(CompletedDate) to no avail so I thought I'd try the TOP 1 method. When I change it to TOP 2 notice that the second row is a more recent date than the first row. Changing the query to TOP 1 returns...

Working with Dates/Timestamps have always been a challenge for me within SQL and based on the threads many others as well. I've been troubleshooting a problem query that's not meshing with a Crystal report. Just for kicks I displayed the query within Crystal and was surprised at the way...

I've attempted to run MSINFO32 on my XP sp2 system and am being taken to the Help and Support application. I've attempted to execute the application using the entire path at the command line and get the same result. I've also tried WINMSD and am taken to the same screen. I've only found one...

I'm attempting to troubleshoot a stored procedure performance problem that utilizes the creation of temp tables and nested user defined functions to fill the tables. The procedure runs fine although long. I ran the following to attempt to troubleshoot the performance problem: SET SHOWPLAN_ALL...

I'm trying to develop a function that will calculate a percentage increase on a cost price but need it to be to the nearest nickle. For example, 9.95 * 1.40 = 13.93. I want to be able to store that value as 13.95. So basically, I'm looking to divide the result up this way: Pennies .00 to .02...

Is anyone aware of functionality within Windows 2000 server or a 3rd party program that will compress files not accessed within a specified time frame? Novell will do this for files not access in say 90 days. I don't want to enable Windows compression at the folders level that would impact...

Recently installed Adobe Acrobat 6.0 Pro onto my XPa server farm. After painfully dealing with the roaming profiles I found a technote that documents that there must be an administrative logon session running on the server console in order for the PDFMaker to function for the user. I've tested...

Has anyone been able to accomplish something like this statement? Update tablename set substring(field,10,15) = 'value' I want to update data burried inside a text field but continue getting: Incorrect syntax near '(' Any help offered would be greatly appreciated