I have triggers,views,functions,stored Procedures for a table. When I am dropping that table which objects are deleted?
IBM,
607Write an sql query to sort a table according to the amounts in a row and find the second largest amount.
569
What is a trigger and its types?
If I delete a template from the list in sql studio, will it be deleted from the hard disk? : sql server management studio
What is stored procedures?
Explain what is the difference between a local and a global temporary table?
Can sql server 2016 run on windows 7?
What is difference between primary key and foreign key?
What is the security principal at the database level that represents your session?
Explain about system database?
How to trouble shoot if unable to connect SQL Server
What do I need to start working with sql studio? : sql server management studio
How do you handle datasets larger than 50 gb?
how to trace the traffic hitting a sql server? : Sql server database administration
What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.
what are isolation levels? : Sql server database administration
How you can find out if an index is useful to the optimizer?