Some people prefix their stored procedure names with sp_. Some people say you should never use the sp_ prefix in procedure names. What's the real scoop?
Related: Recompilation and Coding Owner Prefixes on a Stored Procedure
Never mi...
I need to execute a Data Transformation Services (DTS) package from within a stored procedure but can't find the syntax. How can I execute the package...
Here's a fun puzzle: List the top 10 customers in the FoodMart 2000 Warehouse and Sales cubes based on unit sales, and color the unit sales values the same colors as the customers' member cards. The member cards are a member property of the...