Search results for query: *

Thank you for your help. The database was labeled as LOADING in Enterprise Mannger and there was no hand underneath it. When I tried the statement sp_removedbreplication 'otgcopy2' I received an error message stating that the database was still loading and could not be removed. I even ran...

I was restoring a database using T-SQL and received an error that the restore was terminating which resulted in the databse displaying in a loading state in Enterprise Manager. I received the following message when trying to delete the database: 3724: Cannot delete the database otgcopy2 because...

The recovery mode is full.

I need to recover some missing records but I have a problem. My transaction log is 88GB which has been growing since 3/29/03. My last good full backup was completed on 6/8/03 and differentials occur throughout the week. I need to recover data from 6/10/03 that is missing from a table. Can I...

Hello! I was wondering if there were any utilities or Oracle functions that can be used to read Redo logs. I have a situation where I would like to view a transaction that took place a couple of days ago. Or maybe I am looking at the wrong logs, any advice? What is the recommended method of...

I solved my own problem. Amazing what a little bit a sleep and an embarassing post can do.

Hello All, I have posted my code which is lenghty. The problem I am experiencing is that my base table is not being updated. Any suggestions? declare @Event varchar(3),@F_Name varchar(20),@L_Name varchar(25), @M_Name varchar(15),@Social varchar(9),@Sex varchar(1), @Patcomm...

I was wondering if there was anyway to get around having to open an Access 2000 database exclusivley in order to import/export forms, modules and reports. I currently have two database that I support being used by multiple persons. One is a development Access 2000 database and the other is a...

I have been reviewing literature about a product called Log Explorer. Being that the functionality to view online transaction logs for SQL Server is not available yet I needed to find something to do it for me. The product Log Explorer allows you the ability to review transactions in SQL Server...

I am trying to set-up a test server(ServerB) to mirror my production server (ServerA). I have set-up ServerB with all of the same databases and devices that are on ServerA. When I restore the master.dat file from a back-up on ServerB I receive several error messages refering to database...

I have a need to pause a macro for a minute and resume execution after the minute has passed. Are there any macro commands that can be used to do this? Can this be accomplished using the timer interval property. If so how?

My problem is unwanted concatenated carriage returns (char(13)) and line feeds (char(10)) in tables. I would like to create a stored procedure to search for and delete the concatenated characters. I have managed to track the problem linking the table into MS Access but I would like to be able...

Thank you LuvASP and Stan123 for your suggestions.&nbsp;&nbsp;I finally created the following code for my counter:<br><br>CREATE TRIGGER doctoridITrig ON tjohnso.tstvalid_doc FOR INSERT AS<br>DECLARE @maxss char(4), @maxsd int, @chrDOC char(5), @chrDOC1 char(5)&nbsp;&nbsp;&nbsp;/* FOR...

The following code displays a trigger that I have created to generate an id number that always has to display as five characters. The field type is char but the id number format has to display as a character and 4 integers, for example: T0001.&nbsp;&nbsp;The problem is that the code will work if...