Blog

Avoiding prefix 'sp_' in the name of user stored procedure

Posted by Venkatesan Jayakantham in Blogs | SQL on May 10, 2012

Avoiding prefix 'sp_' in the name of user stored procedure in SQL Server

By nature, if the stored procedure is created with the prefix sp_. SQL Server will start search for the stored procedure in the master database. After wards, it will search for the local database which in turn a major problem. To avoid this,

We need to access the stored procedure using Fully Qualified Name,

DatabaseName.SchemaName.ProcedureName

This Feature is Sponsored By

DynamicPDF Merger is a developers dream for interacting with any existing PDF documents. Merge, append, split, form fill, flatten stamp and so much more.

post comment

COMMENT USING

PREMIUM SPONSORS

iPhone, Android & Web Development Services

Over-C is a holistic consortium of communications and technology specialists. We build, deploy and market both business as well as consumer products and solutions.

More Blogs from this Blogger

Programmatically find out when SQL Server service is started Query to Create comma separated Output. Concatenate row data into a single data in SQL Server Uncommitted new row cannot be deleted. SET or SELECT -- is there any performance difference? Telnet client in Windows Vista Stored procedure execution on SQL Server Startup Changing the path of the MDF and LDF file for the database Inline Declaration and value assignation in SQL Server 2008 DIFFERENCE BETWEEN DROP AND TRUNCATE

View All

SPONSORED BY

DynamicPDF ReportWriter Suite

PDF reports have never been easier to create. With our included WYSIWYG Designer, you can layout your reports, set up your data source and let DynamicPDF ReportWriter do the rest.

Follow @twitterapi

Latest Blogs

Mathematical Symbols in Views Restricting numeric value in Textbox Creating Inner Join on Multiple Tables in SQL Server Bind GridView with MS Access Database Table in ASP.NET Difference between IEnumerable and IEnumerator Project Cost Estimation Basic Aspects of Security and Control Zoom Image in Different Way in ASP.NET Gridview with checkbox with check all option Download SAP Crystal Reports for Visual Studio 2010 - Its Free

View All

Poll Result All Polls


What is the best product to build Mobile apps?

What is the best product to build Mobile apps

PhoneGap Icenium Xamarin Studio KendoUI Mobile JQueryMobile Native iOS/Android

Options	Votes	%
PhoneGap	2	2.74
Icenium	0	0.00
Xamarin Studio	1	1.37
KendoUI Mobile	1	1.37
JQueryMobile	61	83.56
Native iOS/Android	8	10.96
Total	73	100%

In Focus

Avoiding prefix 'sp_' in the name of user stored procedure