Hi Karl,

The error log does not contain any detail about the error. Infact I checked this to find out why?. Let me check if it is in Simple REcovery model....

Hi,

After putting the db in emergency mode you can retrive the data using BCP if the data is very critical or you can restore from old backup.

OR...

Hi Sameer,

The size of the database is 112 GB. However there was no previous backup in the drive.(Infact all 353 GB space is free). If I run the backup from...

Thanks Sushila for the update. Let me give a try

Hi,

I am getting this error continously. Infact it fills my SQL server error log, but the database is running fine.

It has Windows System Error Code - 033 (33...

Hi rudy,

thanks for your valuable comments. Infact it is the reason as we have come to the same conclusion

Cheers

Hi,

My table does not contain nvarchar but does contain decimal (13,25) and numeric(13,28). I use dataLenth() function to find the length of data.

another thing is if I spilt the...

Hi all,

the restore of the SQL DB abc01(Version 15.11.) to the test server finished successfully.

So it is quite clear that the installation of the MS MDAC hotfix:

Q827452_MDAC28_x86.exe...

Hi Asha,

I would be verymuch interested to work with. I have 7 years of IT experience out of which 5 years of solid experience in MS SQL server and Sybase....

Hi Greg,

Thank you. This is what I was looking for

Great

Hi Chris,

thanks you. DBCC USEROPTIONS is what I was looking for.

Great

Hi ,

thanks to both of you for your valuable suggestion. I was thinking on that lines. Just got it confirmed from you

Hi Phil,

Yes I do have a job that recreates index every week.

What else can I do other than turing-off auto update

thanks

Hai,

I have added one more log file to the database , asked the application team to make transaction as short as possible so that the log is truncated as soon as...

Hi try this

drop table #Usrs

create table #Usrs (LoginId varchar(10), Name varchar(40))

declare @Uid varchar(10), @Cntr int

insert into #Usrs values ('AA','EEEE')

select @Uid = LoginId from #Usrs

select substring (@Uid,len(@Uid), 1)

if substring (@Uid,len(@Uid), 1)...