Search results for query: *

Hi All, I'm sure somewhere on MIcrosoft.com the marketing guys have their spin articles but I have a client pushing back on using VB .Net versus (C ++) or C # Has the new version of VB .Net overcome that old issue with the non compiled Version 6 ? Here's their question...

Do you know how to retrieve valuable data stuck in some Exchange 2K data files recovered from the Exchgsrvr\MDBDATA fiolder on a crashed Win2003 SBS Server. I have since re-installed SBS2003 and Exchange 2000 but I can't seem to see any documentation to see if I can recover the files. I dare...

How to Update from Single Row/Many columns to Single Column/Many Rows In SQL Server2000 I want to try to create a stored procedure that uses the following select statement which pulls all the column names from a single row in a table: We'll Call it A SELECT name FROM syscolumns...

In SQL Server2000 I want to try to create a trigger or at least a stored procedure that uses the following select statement which pulls all the column names from a single row in a table: We'll Call it A SELECT name FROM syscolumns WHERE [id] = OBJECT_ID('dbo.A') To create a...

Anyone know how to get the utility in XP that lets you choose which drivers will load and how startup will run. I remember it as a graphical applet with listings of startup dlls and applets and a checkbox for each to deactivate them. I think it's here in XP but maybe I am remembering something...

RunningVB6 (SP5) on WinXP Pro SP1 I am trying to run the active X we created which had run before and has all the updated files to run but I try to run it from my IDE and I get the error message System error &H80004015(-2147467243). The class is configured to run as a security ID different...

In Crystal 8.5 using the ActiveX Viewer on IIS5 We have a hyperlink which we wanted to use but make it non specific for the server We have tried Localhost but that does not seem to work Hardcoding and Naming a specific server works https://tcbserver8/TCBWorks/initial_contact.asp?CaseID=...

In Crystal 8.5 using the ActiveX Viewer on IIS5 We have a hyperlink which we wanted to use but make it non specific for the server We have tried Localhost but that does not work This works https://tcbserver8/TCBWorks/initial_contact.asp?CaseID=3535.00 This does not...

In the SQL Server TSQL does LEFT JOIN return the same records as LEFT OUTER JOIN ? If not what is the difference ? Thanks, AJ

I am trying to limit a Group to show records with a sum which falls within a range. The range is part of the stored procedure and filled in by the users but I keep getting an error message stating "A number or Currency Amount is Required HERE" Right Before the Parameter...

IS the beginning of a new day in Date Time format in SQL server 2000: A) 12:00:00 AM OR B) 00:00:00 AM ? C) Makes no Difference I have heard that A is actually 12 Noon a nanosecond before the PM cycle since PM is actually 12:00:01 Thanks for the Reply

DateDiff (m,{Exception Phase.PhaseStatusDate} ,{Exception Phase.RefDate} ) I keep Getting the Error Message "Missing )" and the Cursor is Blinking DateDiff (| right here to the left of the month interval value. This happens in Both Crystal and Basic Syntax I'm missing something...

Running CR 8.5 page server against SQLserver2K database, I have a main report with 4 embedded sub reports. All of them at the same sub report layer no 2 or 3 level sub reports... I get SQL Server error, File <Filename>.[On Cache/Page Server: <servername.pageserver> Is this a time out error...

I am trying to print the Task Usage Page but the only one that prints is the first page of 4. When I look at them in Print Preview indeed the first one is bright and the last 3 are a bit greyed out. What am I missing BTW the File was created and currently in Project 2000. Thanks AJA

Does someone have a &quot;can opener&quot; to unlock this data? I have a tblConsumer Table with a Consumer ID I also have a tblDisablility table with ConsumerID, DisablilityType, Cause They join on ConsumerID. DisabilityType has a 1,2 or 3 to rate the primary, seconday and third type...

Here's the full message Server: Msg 106, Level 15, State 1, Line 1329 Too many table names in the query. The maximum allowable is 256. Any Ideas on how to work around this limit ?? Thanks AJA

Using SQL2K I have an inbound Date Param @FiscalYear and it is a char(4) I want to use it in a Variable called Date Range Previously the code was written for use in Dynamic SQL so the whole things was written in a String context. What I am having trouble getting the correct syntax for...

Working with Oracle 8.17 DotNet Web Application pass parameters to an Oracle stored Procedured which then populates a Crystal 8.5 Report: Using a proc which has an IN Parameter p_event which is a varchar2 We want to pass it mutiple values using a multi select HTML list box and pass it to...

Using Oracle 8.17 and a Dot.Net web Interface, we use a selection list box as a multiple choice option and it returns event ID's such as 453, 563 in a controlled string format with comma seperated values. The inbound parameter is : P_EVENT IN VARCHAR2 DEFAULT 'ALL' we ar attempting...

As a Newbie, I have used several views which each use a preceding view until the final view is used by a stored procedure which feeds several reports. I know this should be able to include all steps into a single SP, but I'm not sure of the construction of such an SP Can anyone give me a clue...