User Identification: In virtue of Data base server Identification tries to find whether you are registered user in the database or not. It applies to whole database server.
Authentication: It applies for special Privileges for a user in the database. Like whether a user is authenticated to run system procedures or not. Or whether he is authenticated to create new users or not.
If you have the better answer, then send it to us. We will display your answer after the approval.
Can we generate a trigger for two tables? if so what is the query to generate a trigger for two tables employee table and department table with employee having department no.
I was asked in an interview... "Suppose u have a field with UNIQUE KEY. can u leave two or more cells NULL in SQL Server 2005...If Yes then Why...if NOT then Why.....