Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
YogeshDesai
Posting Yak Master
136 Posts |
 Posted - 2007-04-19 : 13:35:43
|
| hi Guys,What are the steps to check the database after installation of hotfix or service pack.I am going to apply post-SP4 Hotfix build 2187.I know one command DBCC Checkdb apart from this are there some specific queries or sps ?Yogesh V. Desai. | SQLDBA| |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-04-19 : 17:05:29
|
| No, that's it. |
 |
|
|
YogeshDesai
Posting Yak Master
136 Posts |
Posted - 2007-04-24 : 03:45:34
|
quote:
Originally posted by rmiao
No, that's it.
Hi Thanks,How could you find if there are any performanance issue after installation of hotfix just five min back i have noticed some errors in log.1. OLE DB ERROR ENCOUNTERED.2. Error: 50000, Severity: 16, State: 13. Error: 2601, Severity: 14, State: 3Could you help me to resolve this or any hints.?Yogesh V. Desai. | SQLDBA| |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-04-24 : 10:04:06
|
| From client apps? Usually you should check with app vendor before installing any fix pack. |
|
|
|
propanecan
Yak Posting Veteran
60 Posts |
Posted - 2007-04-24 : 10:18:00
|
| I believe error 2601 is a duplicate row error. You would have to research your data to make that determination.What windows/sp version are you running? |
|
|
|
YogeshDesai
Posting Yak Master
136 Posts |
Posted - 2007-04-27 : 05:44:32
|
quote:
Originally posted by propanecan
I believe error 2601 is a duplicate row error. You would have to research your data to make that determination.What windows/sp version are you running?
I am using windows 2003.Yogesh V. Desai. | SQLDBA| |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-04-27 : 09:44:05
|
| Have details of those error? |
|
|
|
|
|
|
Database checking after Hotfix installation