Join us on May 2nd, as we discuss preparing for DDoS attacks, building resiliency, overcoming obstacles and key preparations to make now before ransomware attacks.
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...
I'm using SQL Server 2000 Profiler to monitor several applications, and I don't understand why I'm not seeing data for some of the events that I've requested traces for. For example, my trace includes the RPC:Completed event (from the Stored...