Search results for query: *

I have OracleXE 10.2 installed on my office PC. The Oracle services start up automatically at boot time. I'm curious about the amount of memory it's using when I'm not actively using the database. I've seen it vary from 9000K all the way up to 142000K. I know for a fact there are no...

I have a question regarding how the Oracle 10g Express Edition calculates the 'Space Allocation' amount that is displayed on the Administration > Storage page. For instance on my desktop installation the Space Allocated figure is given as 770mb. That figure is 105mb Lower than the figure I get...

Here's the scenario. My company has a need to create several scheduled tasks on a large number (100+) users PCs. I thought I could do this by creating a batch file (MyCommands.cmd) that executes several "AT" commands to create the scheduled tasks. That part works. However, I cannot edit the...

In Access 2003 using a multi-page tab control, is it possible to create a single control (say a calendar control) that will appear on ALL pages? I have a report selection form with various parameters specific to the reports, but all the reports share a common parameter of Start Date. I'd like...

I'm using both Access2000 and 2003. I have a routine that refreshes my linked MSSQL table attachments by requiring a logon to the SQL server. All the linked tables have primary keys. When linking a View, the user is prompted to 'Select Unique Record Identifier'. The users frequently click...

On a multi-user laptop running Windows XP Home Edition. Are the settings selected for Startup using Start -> Run -> MSCONFIG specific to a user or are they set for all users? If they are specific to a user, where are the settings/selections stored? On a laptop heavily infected with spyware...

Are there procedures for cleaning out older rows in the following tables in msdb: dbo.sysdbmaintplan_history dbo.backupfile dbo.backupset dbo.backupmediafamily dbo.backupmediaset They seem to contain information back to the startup of the server. I don't use maintnenance plans for my backups...

Can an Access MDE file created by Access2000 be opened successfully by higher versions of Access (i.e. Access2002/2003)? Are there any special considerations to be observed when creating the MDE under Access2000? Our users have a mix of 2000/2002/2003 and we are looking for the lowest common...

I'm attempting to execute a stored procedure from VBA using an ADODB connection. So far it works as expected, but I have a question: What is the advantage or disadvantage if any in declaring a parameter for the stored procedure call in the following ways: ObjCmd.CommandText =...

I have an Access97 report with a pair of imbedded linked Word documents. I cannot get Access to reliably refresh the linked documents displayed in the report when they change. The Documents are linked, not embedded. Is there something I can do in VBA to force a refresh to bring in the...

We are using Seagate Info 7.5 to schedule a Crystal report. The report contains ActiveX objects (Word Documents) in the detail section of the report. When this report is run thru Info, changes to the ActiveX object do not appear. That is if I update the linked Word dcoument and re-run the...

With search down, I'll resort to a (hopefully) simple question. What determines the version of the ADO library available on a workstation (NT or 2000) to include in references? I work in a very mixed OS environment. The version of ADO library on the NT stations ranges from the 2.5 version all...

Is there a graceful way within a stored procedure to detect if a linked server connection is up? I'd like to be able to gracefully exit a procedure and return a meaningful message if a connection cannot be established to a server that may be down from time to time.

Am I running up against some file name length limit in SQLServer2000? Here is my job step to backup the transaction log: EXECUTE master.dbo.xp_sqlmaint '-D timberscale_mgr -Rpt "E:\SQLData\MSSQL\Backup\timberscale_mgr\Maint_Rpt\LogBackup.txt" -DelTxtRpt 2DAYS -WriteHistory -VrfyBackup...

1) What is the easiest way to determine if Analysis Services/Tools have been installed on a MSSQL 2000 server (not workstation)? 2) Are there any special steps required to migrate a SQL 7.0 OLAP package to a SQL2K Analysis Services package? Will the SQL 7.0 package migrate at all?

Is there any way to determine which DTS package is being run from the encrypted command? I know the /~S refers to the server and /~N is the package name, but how can I translate the encoded name back into the package name? ie: DTSRun /~S 0xEC4F1686388C57C7068EDDF19740834D /~N...

My company wants to use Log Shipping to maintain a backup database that will also serve as the reporting database. That is all queries should run against the backup server. We've tested the Log shipping procedures and they seem to be working OK for keeping the data in sync. One big problem we...

I just upgraded my Client tools to SP3a for SQL2000. I'm running XP-Pro, SP1. Now, in Enterprise Manager after I expand the list of databases and click on any of them I immediately get an Internet Explorer script error as follows: An error has occurred in the script on this page. Line : 307 Char...

Is there an easy way to export EMail messages from Outlook Express so they can be imported into Outlook2000. The PC's are not on a network. Outlook Express is on Win98, Outlook2000 is on XP-Pro.

My organization is looking at Log Shipping as a possible solution to disaster recovery and reporting issues. In order to keep long-running queries off the primary server, the plan is to establish a 'warm' backup server ,use log shipping to keep the two instances in near syncronization and run...