Venkat rules! Your tutorial is the best available on youtube. You are the best teacher I met in my life.I watched all your videos. I'm the biggest fan !
Is there a way to audit the activity of a certain login in SQL? For example, I want to know everything that user "Test" does after he logs in. Is that possible?
IN CASE OF ANY ISSUES THAT LOCK OUT ALL USERS, FOLLOW THE STEPS BELLOW TO REMOVE THE TRIGGER FROM THE SERVER 1-OPEN A CMD WINDOW AS ADMIN (RUN AS ADMINISTRATOR OPTION) 2-EXECUTE THE COMAND TO ACCESS THE SERVER VIA SQLCMD sqlcmd -S SERVERNAME -U SA -P passwordhere -d master -A 3-IT'll OPEN A CONNECTION ALLOWING SQL COMMANDS EXECUTION 4-RUN THE DROP TRIGGER COMMAND HIT ENTER DROP TRIGGER [TRIGGERNAME] ON ALL SERVER 5-RUN THE "GO" COMMAND AND HIT ENTER TO EXEUTE THE DROP STATEMENT GO 6-THE TRIGGER IS NOW REMOVED FROM THE SERVER
Venkat rules! Your tutorial is the best available on youtube. You are the best teacher I met in my life.I watched all your videos. I'm the biggest fan !
Venkat, we really think you so much for covering triggers all the way to the bone... its been really appreciated.
I watched 10 of your tutorials yesterday. That makes a great day :-) I really enjoy learning - thank you very much!
Awesome sir Ge
Nice use of a Trigger! thanks :D
very nice
Is there a way to audit the activity of a certain login in SQL? For example, I want to know everything that user "Test" does after he logs in. Is that possible?
very gooood please back to sql yaaaaaaaaaaaaaaaaaaaaah!!
please help in creating logon trigger to restrict specific IP address, as i didn't found the table which you explained.
how can i prevent user from login using sql management studio but allow user to login using c# application
Help...I tried this video now i cant login to SQLserver and how can I revert it and login to SQLServer as I am locked out :((((
IN CASE OF ANY ISSUES THAT LOCK OUT ALL USERS, FOLLOW THE STEPS BELLOW TO REMOVE THE TRIGGER FROM THE SERVER
1-OPEN A CMD WINDOW AS ADMIN (RUN AS ADMINISTRATOR OPTION)
2-EXECUTE THE COMAND TO ACCESS THE SERVER VIA SQLCMD
sqlcmd -S SERVERNAME -U SA -P passwordhere -d master -A
3-IT'll OPEN A CONNECTION ALLOWING SQL COMMANDS EXECUTION
4-RUN THE DROP TRIGGER COMMAND HIT ENTER
DROP TRIGGER [TRIGGERNAME] ON ALL SERVER
5-RUN THE "GO" COMMAND AND HIT ENTER TO EXEUTE THE DROP STATEMENT
GO
6-THE TRIGGER IS NOW REMOVED FROM THE SERVER
@@ronaldorconde Thank you so much Ronaldo :) It worked for me successfully.