RSS and ATOM Feed Boosting Engine

Which command using Query Analyzer will give you the version of SQL server and operatingsystem?Ans:SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY('edition')

SQL Server agent plays an important role in the day-to-day tasks of a database administrator (DBA). Itis often overlooked as one of the main tools for SQL Server management. Its purpose is to ease theimplementation of tasks for the DBA, with its full-function scheduling engine, which allows you toschedule your own jobs and scripts.

Can a stored procedure call itself or recursive stored procedure? How many level SP nestingpossible?Ans:Yes. Because Transact-SQL supports recursion, you can write stored procedures that call themselves.Recursion can be defined as a method of problem solving wherein the solution is arrived at byrepetitively applying it to subsets of the problem. A common application of recursive logic is to perfor...