I already waited for this confirmation!

thanks, Gail!

hi anoop.mig29

repair_rebuild, indicate that case find any error, this should be repaired, no data loss!

allow_repair_data_loss, allow the possible data loss, if find any error!

follow micrisoft's documentation: http://technet.microsoft.com/en-us/library/ms176064(v=sql.105).aspx

i've use policy to ensure the correct schema, default names to tables, views, proc, functions.....

applying rules of company!!!!

if I understand, then

select ayear, trim, AGroup, sum(cast(MonthlyAmt as money)) sumTrimester

from (

select *,

trim =

case

when AMonth between 1 and 3 then 1

when AMonth between 4 and 6 then...

Thanks AndyOwl!!!! your article is easy and simple to understand and very useful too!!!

that's right! sestell1!!!

I ask you, again: what's the reason for rollback? do you used kill spid? or occurs fails on server/database?

depending of reasons, isn't appropriated restart server/sql!!!

guerillaunit (8/31/2012)

---

I have an uncommitted statement in perptual rollback mode in my database. When I try to kill the SPID associated with this statement, I get the "transaction rollback...

Thanks Gail for this great article!!!!

dwain.c (8/29/2012)

---

Well, one thing that you could do if you were so inclined is to add the schema prefix (e.g., dbo.) to each referenced table in each query.

This is supposed...

well, this article can help you: dd207003

but, the informations in msdb like as job's, alerts, operators will be deleted!!!

others modifications made by users on database master and model will...

I agree totally!!!! but, developers and others users have difficulties or they don't want to agree with security implementation!!!

it's our scene, complex and funny!!!

WayneS (7/19/2012)

---

The full backup will also contain the uncommitted transactions from transaction 4 at the time that the backup finishes. If a restore is necessary, the UNDO portion of the...

read this article msdn-ms159762

maybe not!!!!

this hotfix is most specific to solve this issue!!!

see this link: http://support.microsoft.com/kb/925001/en-us