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.
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...
What happens when a scheduled job runs longer than the scheduled interval time period? For example, if a job is scheduled to execute every 10 minutes and takes 35 minutes to complete, does the job execute again while it's still running...