What is tail log backup? Where can we use it?
Latest Answer: Tail Log Backup is the log backup taken after data coruption (Disaster). Though there is file corruption we can try to take log backup (Tail Log Backup). This will be used during point in time recovery.Consider a scenerio where in, we have full backup ...
How to deny insert, update, delete, update permissions for a specific user of a specific user database?
Latest Answer: So what context is the user in? A role a datareader? Datawriter?You want no permissions?USE Drop USER In a role?EXEC sp_droprolemember 'rolename' , 'Member'single objects?Revoke SELECT, ...
How to display list of tables from a particular database in MS-SQLHow to display description of that particular table?
Latest Answer: Submit a query on the SYS.TABLES table to get all of the data about the tables in a specific database. Be sure to specify the database that you are targeting.USE -- Specify your target database name (without the brackets)GO SELECT ...
What is the difference between Subqueries and Joins? Which is better and Why? Give an example of each.
Latest Answer: Join is a Methodology to get a data from more than one table, its work under the condition. Example: If we want to display the Employee no and his Department no SELECT Empno,Deptno FROM Emp,Dept ...
What is the Difference between Attach and Restore of a Database?
Latest Answer: Database attach is faster as compaired to Database Restore. SO if you have both options then may be you can choose Database attach than Database Restore. ...
How many levels a trigger can be nested? Explain about nested triggers.
Latest Answer: There are up to 32 nested trigger levels. ...
How optimisation and Performance in Sql Server 2000 can be achieved?What are the steps involved?
How we can pulish the connectivity of SQL query to the HTML file or web page? Please Explain.
Latest Answer: Normally connection of SQL file to a web page can be done in two ways1. Through the code2. In web config fileIf we give through the code, we need to alter the relevant pages, where as if we give through web config , this will be a common file and will ...
Latest Answer: For primary key if that record is being refered by some other (Child Table) sql server won't let you to delete that record.While creating relationship if you had mention "Delete Cascade" option and then if you delete the ...
It's working in MySQL but not in SQL-Server.
Latest Answer: Use a procedure which will delete record from child table first and then it will delete the same record from parent tableSame thing can be achieved using cascade delete and cascade update, this feature was not there in sql server 7.0 ...
View page << Previous 1 [2] 3 4 5 6 Next >>
Go Top
