http://technet.microsoft.com/en-us/library/ms180099(v=sql.90).aspx

sp_makewebtask is retained for backward compatibility. New Web pages are more easily created using Microsoft SQL Server 2005 Reporting Services (SSRS).

This feature will be removed in the next version of...

Government

/* ON THE SERVER phlsql */

CREATE PROCEDURE dbo.FetchData

AS

SELECT sam_batch, SUBSTRING(sam_phonenumber, 4, 9) AS phone

FROM capabilities.dbo.aww_sample

WHERE sam_batch BETWEEN 437 AND 449;

GO

/* ON THE SERVER p42 */

CREATE TABLE #Results (sam_batch [DATATYPE], phone...

use master;

GO

DENY VIEW ANY DATABASE TO james

wrong thread :Whistling:

You can add more physical ram.

The first index is enough, if your queries search on first name and last name or just on first name.

If you have queries searching on last name then none of...

What is the exact error message?

Jonathan Kehayias has written the best blog series about extended events

http://sqlblog.com/blogs/jonathan_kehayias/archive/2010/12/01/a-xevent-a-day-31-days-of-extended-events.aspx

Data that needs to be transactionally consistent must be in the same database.

Can you try

DELETE FROM fact.WorkOrder WHERE CreateDate >= @startdate OPTION (RECOMPILE)

Can we see the actual execution plan for

DELETE FROM fact.WorkOrder WHERE CreateDate >= @startdate

1. How many indexes on fact.WorkOrder?

2. How many Foreign Keys on fact.WorkOrder?

They have a discussion thread here:

http://www.sqlservercentral.com/Forums/Topic1441532-3362-17.aspx

I agree with Koen. The only way to get the behavior you describe is if you are running under a nested transaction.

BEGIN TRANSACTION

BEGIN TRANSACTION

INSERT CUSTOMER(NAME, CITY, STATE)

VALUES('John C', 'Chicago', 'IL')

COMMIT...