And late! 😀

Dev (11/15/2011)

---

ashuthinks (11/15/2011)

---

What is the use of Table Hint in SQL like NOLOCK, READUNCOMMITTED

please explain this with example. i'm newbie

also why it cannot...

I had @@rowcount in mind! Not too sure if it holds the correct value in the trigger but it should.

The problem with this is the high cost of getting that info.

I'd much rather use something else like the rowcount or something.

That being said it would still be option 197...

I don't understand why you need to do that. Can you explain more what you're doing?

Ok, do you have backups of those dbs?

please run checkdb with those switches => ALL_ERRORMSGS, NO_INFOMSGS

I only need the code you have in that textbox for SSRS. Nothing else.

It's...

What did checkdb returns?

What db did you run the package on?

The only obvious answer to this problem is reload the package from QA env. Which I guess you thought...

Yes it's possible.

Can't help you without seeing your code.

What code did you use?

Dev (11/17/2011)

---

Even qualified DBAs can do this messup...

DELETE FROM <TABLE1>

WHERE a='X' -- OOPS... Forgot to select before I hit...

What's the exact code you used?

The error you get?

Or the wrong results vs the correct results?

Dev (11/17/2011)

---

Ninja's_RGR'us (11/17/2011)

---

That's called a maintenance plan.

Backup, test the backups.

Keep the backups as long as necessary.

Shit happens, you can <mostly> prepare to repair the damage.

Change control management is...

Ninja's_RGR'us (11/17/2011)

---

That's called a maintenance plan.

Backup, test the backups.

Keep the backups as long as necessary.

Shit happens, you can <mostly> prepare to repair the damage.

Change control management is an extra protection...

= (1 - SUM(C1 + C2 + C3)) / SUM(C5)

Put an IIF to avoir divide by 0 error.

HTH.

PS You're avatar is not showing here. Unless it's a big red X.