Search results for query: *

I am having an issue. I have some services/dcoms that when they are attempting to start they first access a file share to gather some info. The problem is that when the services are located on a server that is on a domain that is different from the server holding the file share the service...

Basically I am performing the following against a table with millions of rows in it and it is taking quite a long time. EXECUTE IMMEDIATE 'ALTER TABLE <tablename> MODIFY UPPER(column) NVARCHAR2(60)' Do you have any opinions of how to speed this process up? I am not sure how oracle is handling...

Does anybody have any suggestions on how to append rows of text to a file encoded in UNICODE format? I always seem to be outputting garbage characters. Thanx for any suggestions.

If I have a field in a table of type BLOB and I update the record in some way will the full BLOB be saved n the redo log space? Thanx JB

Anybody know of a way to check for a specific service running on a server from another server via VBA? Thanx JB

I was given a full backup of a database and want to restore it. But I want to restore it with different logical file names then it was created with. Is this possible during a database restore? If not, any suggestions on the easiest way to recreate the existing one with different logical file...

I have a .dmp with data from schema1.table1 (there is a create table statement as well). I need to import this .dmp file into an existing table called schema2.table2 (same fields as table data was exported from). I have tried using IMP with all sorts of parameter variances but I always seem to...

Can someone come up with a SQL Update statement that will update an existing DATE field by adding a second to the existing value? Thanx JB

I have a site that is set with Archiving on and was looking for a little information as to what exactly is logged when an Insert statement is done and an Update statement as well. The reason I ask is the logs are taking up approx. twice as much space as the database itself. Note: before the...

I am in the process of converting some SQL Server stored procs to Oracle and ran into a whole bunch that return a result set. How can this be done in Oracle 8i? Thanx JB

I have a report that has one subreport. In the details section of the main report there are text fiels and lines that basically build a shell of a formatted report and then the subreport puts data within this shell. The only problem when the shell receives more than 5 records (for example)...

What is the easiest way to copy an instance running on a machine to another new instance that will be running on the same machine? Would exporting the old instance (full export) then importing this into the new instance be the easiest? Or could I stop the services of both instances and then...

I have an export dump from 8i and need to get it into 9i? Will 9i recognize this format or will I have to do this another way? What is the easiest way to move an 8i database instance to a 9i database instance? Thanx JB

While my laptop is connected to our domain I can see my local SQL Server Registration (registered under my local machine name). When I try booting up my laptop while not connected to our domain (but logging on using the same userid/password) the local SQL Server Registration is not recognized...

Using the following code snippet I can open up a report in Crystal but the report stays open after the script is finished. Is there a way to close the report within the script? Thanks JB Dim objApp As Object Set objApp = CreateObject(&quot;Crystal.CRPE.Application&quot;) 'get the Crystal...

I have a small network, 2000 Server and one client workstation (with one hub between them). Currently this small enviroment is set up as being part of a WorkGroup. I want to change it to be on it's own domain. How hard is it to put the existing environment onto it's own domain? What steps...

Whenever SQL Server is restarted in the ERRORLOG the following messages always appear: Starting up database 'MYDATABASE'. Clearing tempdb database. Recovery is checkpointing database 'MYDATABASE'. Starting up database 'tempdb'. Recovery is complete. ... Starting up database 'MYDATABASE'...

Is there a known bug when using DTS to export a data column that is more than 255 characters? I have a varchar column in a table that is truncating at 255 after the successful export has completed. I figure there has to be a setting that I am missing that will enable the whole string to be...

Can anybody point me to some documents that detail specific &quot;heads ups&quot; when planning/performing an upgrade of an Oracle 8i database to Oracle 9i? I searched on Oracle's technology network and most of the stuff I found was info on how and why I should contact Oracle Consulting...

I am developing a backup strategy which includes backing up a database as well as some extra files that are supposed to be synchronous with some data stored in the database. Pause sql services Warn all that about to stop sql services {wait 5-10 minutes} Stop sql services Copy extra files to...