I have experienced this very issue. The MSDTC orphaned transactions hotfix was not included in CU8, but it did make it into CU9.
Do you know what objects the object_ids in the dbcc output refer to? If they are SPs, try recreating them.
You may have to kill the spid, by running
There is no point in shrinking it. If it needs to be a certain size to accommodate your overnight process you should let it remain that size.
yes you can get problems with large single transactions and the log not growing. Making it larger manually in advance is the best thing to try. What...
I don't really understand why pressing CTRL- etc etc is better than mouse clicking?!
According to Books Online, you need to be in the 'replmonitor database role on the distribution database at the Distributor'.
You need db_owner or...
I suggest you post this on the Katmai MSDN forums..
I don't have answers to your questions, but I am attempting to do the same thing as you at the moment and I am also having problems. I am using the...
No. you need to
1. backup database
2. backup log (to disk)
3. (do whatever else)
4. backup log (to disk)
To restore the database,
1. Restore full...
How large is the table, how many rows, how many data pages? Small tables are held on shared extents and this means they have scan densities of things...
Lock Pages In Memory privilege only works in Enterprise Edition, in Satandard edition it is ignored.
Don't worry about the log files of system databases (except tempdb). There is little logging going on in master, model, msdb (usually). For tempdb,...
These are the babiesselect
name, id from sysindexes where name like '%WA_Sys%'
What is the connectivity like to your servers?
Replication is not a HA solution - it's very questionable the microsoft consider it to be one.
There is a whole heap of issues with identity columns,...
Can anyone other than Satya answer, or just him?
Or usedbcc show_statistics ('ADDRESS','IDX_ADDRESS_Postcode') WITH DENSITY_VECTOR
show_statistics ('ADDRESS','IDX_ADDRESS_Postcode') WITH...
show_statistics ('ADDRESS','IDX_ADDRESS_Postcode') WITH STAT_HEADER
for only one row
Std Edition does not have a RAM limit in 2005 so you should be ok with that. Is it 64-bit or 32?
Separate names with a comma.