I created one new database and restored old backup file with move option. I checked SQL Server error log but didn't see...
Hi Satya & Frank Kalis
Thank for your reply. When I tried DBCC CHECKDB with repair_allow_data_loss. This error occured and can't restore...
quote:Originally posted by sunilmadan
Try rebuilding the index.
Use DBCC DBREINDEX or how????. Reindex table or database ???
Please Help me.. When I tried to count(*) the row from one table. It got the error message like 'Attempt to fetch logical page (1:42724)...
Thank you. Deleting statement is really useful to me.
Sayar,I am using window NT.
derrickleggett,Can you tell me more detail about it.
Can you help me please. I just want to know how to start mssqlservice to remove server. I use osql utility (shutdown)...
Thank for very much for your reply.
During making many transactions( Like bank's tranasction), can do BACKUP with job or SHRINK DATABASE .I just want to know what...
Thank for your reply.Service pack is 3.
Could you help me please..
Database is SQL(7.0)and during making the transaction time out error occured and I can't connect Enterprise Manger. I...
When I am doing backup databases "Multiple Backup Device",the following error occured
The volume on device Dailbackup is not part of...
Thank for sharing this site.I can decrypt sp now.
Originally posted by satya
After you execute SP_RESETSTATUS make sure to restar SQL services to affect the changes.
For more information refer to...
How can I recovery suspect database?.when I used it sp_resetstatus,it can't recovery.I resolved this database with...
Thank you very much for all.
Hello all Members!
I am a new member.after I encrypted view and store procedure,how can I decrypt this. I think Alter view or sp can...
Separate names with a comma.