Dear members, we provide a solution of bugs related to sql server along with study material and interview preparation of SQL server. click below link to get your solution http://mssqlinterview.blogspot.com/

what is the diffrence in DBMS and RDBMS?

Hi, I have created a stored procedure which will delete a particular record in a table based on the input we give as a parameter. It is working fine. Here is the following code Code ------- Create procedure [dbo].[emp_insert] @Name nvarchar(15), @Age int, @DOB datetime, @BGRP nchar(10) as begin insert...

Firman, Here are a few options: Option 1 - New consolidated stored procedure CREATE PROCEDURE dbo.spConsolidated AS EXEC dbo.Sp_collecting EXEC dbo.sp_numtoWord GO Option 2 - Copy the code from the second stored procedure to the first stored procedure Option 3 - Have the first stored procedure call the...

Samkry, These events in Profiler are what you need: Stored Procedures and select the SP:Recompile. The a long execution time for a stored procedure does not necessarily mean that it is recompiling. Thank you, The MSSQLTips.com Team