Try the script below

Insert into table1 (RID, Action, ActionDate, ActionBy, EffectiveDate)

Select ID,'New to No', '11/14/2008', 'XYZ', '11/14/2008' from table2 where (Posting=1111) AND (Status = 'New')

Check if the folder exists and check if the files inside the path also exists

C:\Program Files\Microsoft SQL Server\MSSQL\data\

Thanks for the replies guys

I try to run the setup again and choose to upgrade sql. MSSQLServer Service status is starting so I start Distributed Transaction Coordinator in the services...

This is the code snippet I saved. it works on sql 7 (I think should also work with sql 2000). Try it first in your test server

USE master --use master...

Thanks a lot Jeff 🙂

Ohh... I see thanks jeff 🙂 does express edition have an osql utility? can i use it? or it is just the same?

DECLARE @path varchar(1056),@msg1 varchar(1025),@msg2 varchar(512),@msg3 varchar(512)

SET @path = 'D:\servercheck'+'_'+convert(char(8),getdate(),112)+'.txt'

SET NOCOUNT ON

DECLARE @crdate DATETIME, @hr VARCHAR(50), @min-2 VARCHAR(5),@cmdtxt as varchar(255),@count_rows varchar(200)

SELECT @crdate=crdate FROM sysdatabases WHERE NAME='tempdb'

SELECT @hr=(DATEDIFF ( mi,...

Problem was solved. We take the database to offline mode then switch the database to online mode then the database becomes available 😀

Godd Day guys,

The error I encountered 3 days ago occur in 1 of our production database. The database is in suspect mode and the error in the errorlog are as...

Thanks for the replies

@manu-2

- SQL Server Inatance is not Clustered

@Edogg

- "Auto Close" property is disabled

as of today the problem did not occur

Did you check the disk drive where the backup resides to see if you have enough disk space for the transaction log backup you scheduled?

is this what you want?

select name as 'DB Name',convert(varchar(50),crdate) as 'Date Created',cmptlevel as 'Compatibility Level',

filename as 'File Path',@@servername as 'Server Name'

from master..sysdatabases where convert(char(8),crdate,112) = convert(char(8),getdate(),112)

are you getting the backup filename to the msdb database? or you want to get the date and time where the mail is to be delivered?

Thank you for the inputs guys. When I received the error in my server i already checked the drive where in the mdf and ldf is and the size of...

No. as of the error occured until now I have not restarted the machine. The only solution i made is to restart the services then the database is accessible again....