you could collect an inventory scanning all your sqlserver instances or active dbmail configurations and for dbmail profiles.

ref: http://technet.microsoft.com/en-us/library/ms177580.aspx

/* is dbmail config activated ? */

Select *

from ...

Basically it means:

- Immediatly go to jail

- do not pass the GO square

- You'll not collect $200 salary

:w00t:

If corruption re-occurs, it is time to check your disks, .. double check if your case can be found in the BUGs of Service packs or Cumulative updates you didn't...

Please don't x-post.

This post has already been replied to: http://www.sqlservercentral.com/Forums/Topic1488317-391-1.aspx

of course if depends on the level of granularity of the grants for your current QA-accounts.

IMO scripting all grants may be the easiest approach.

Then, use restore db and run the...

it depends if the backup has been taken before the corruption occured.

One way of testing this is using Allens automation script : Test Your SQL Server Backups with PowerShell[/url]

As Gail stated, your "and o.type = 'abcd'" is part of the join predicate for the left join.

if you only want abcd typed rows in your result, you should move...

Of course it is a choice to just add a gender value and an indicator it is a value to be double checked.

Updating the current column content isn't such a...

Koen Verbeeck (8/28/2013)

---

craig.schlieve (8/28/2013)

---

Ahh then I see my morning caffeine kick hadn't kicked in and I misread. I apologize in that case. My statement that this needs to...

kapil_kk (8/28/2013)

---

But what abt the scenario for which I posted the question...

How can I implement this:

Scenario is: Currently if made any changes in...

if that meets the requirement, it's ok.

What will happen to your trigger if someone inserts data of multiple ProjectID / ProposalID / SolutionId / UnitID in a single batch ?

Keep in mind exceptions do occur !

e.g....

- I haven't played much with "merge", because of the issues with it I hear from time to time.

I think you should remove the "values" keyword before the select top...

- You are still using the deleted object in the insert trigger.

did you try the easy way ... split the trigger in two ?

1 trigger only for inserts

1 trigger only for updates