However, when a CLR stored procedure performs data access operations through the SQL Server managed provider, an additional nesting level is added in the transition from managed code to SQL.

In this blog we illustrate how to get the pagination data from SQL server stored procedure. To create a such type of a stored procedure, we need to send a minimum three parameters (startRowIndex, ...

There are many benefits of using stored procedure, few of the reasons are to prevent SQL injection, minimize latency for batch operation, and also it improve performance by reusing compiled execution ...

Many times during sql server development we need to search for a stored procedure containing a specific text. this helps in checking for dependencies for objects in stored procedures or sometimes we ...

You can read more about adding this extended stored procedure in the help pages on the product CD. Follow the hyperlink to the readme.txt file on the Servers page under the Documentation section of ...

To run your SQL Pass-Through views for the MS SQL Server, you are encouraged, but not required, to create a data source name. You can use the ODBC administrator to create it. Refer to Data Source ...

This prevents SQL Server from making assumptions based on the way the stored procedure is called the first time and picking a plan that is inefficient for different parameters.<BR><BR>Does not ...

Looking to run SQL 2000 as a platform for an ERP app on a new box. Dual P4, 2GB RAM, up to 6 SCSI drives in any of a variety of RAID configurations.The research I've done and the ERP vendor says ...