App is already live with sa priviledges., trying to cutdown what priviledge it exactly needs.

Lowell (1/3/2011)

---

just tested this, and it works fine, assuming you have dbmail setup with a profile;

--DROP TRIGGER [TR_Logon_Trigger_Track_sa] ON ALL SERVER

GO

CREATE TRIGGER TR_Logon_Trigger_Track_sa

ON ALL SERVER FOR LOGON

AS

BEGIN

--the...

Jerry, i have gone through different articles but i am not sure if that suits my requirement. Basically i need the trigger to send me an email when someone logon's...

That was exactly what i was about to do. Thanks

Thanks

Thanks everyone. I will have to check back with developers to see if they have the capability to implement CLE. After reading all the responses i do not think it...

One of the many reasons is each db is specific to one client lets say i have 100 clients and i have 100 tables in one db then if this...

Thanks everyone. These 100 dbs are identical schema wise. We do not have a DR so we will be implementing 2 node active-active cluster for local HA.

Thanks.

Awesome, this worked like charm. I am just wondering how come this is working on other servers where we have the account changed from services console, only difference i see...

Gail mentioned below is my h/w config. Lets say i have 100 dbs, i would want to split into two instances with 50 dbs with max of 100 dbs...

Can you please give me some details like what performance hits will we come across or if you can point me to a article that would also be helpful. Thanks

Not sure what difference it would make if i do it through services console Vs SAC on stand alone. I would still try changing through SAC and let you...

If i enable column and database encryption are there any performance hits?

Thanks Gail.I should have mentioned this before. These dbs are not heavily transactional. Lets say i have 64bit sql 2008 with OS 2008 64 bit on a 64 gb Dell...