You might be have something like this in your query window.

ALTER PROCEDURE P

AS

..

..

..

..

-- Verification

EXEC P

Comment out the last line.

-- Verification

--EXEC P

Alter your SP again & verify the results.

Please share the execution plan of stored procedure.

Failover clustering is supported in SQL Server Enterprise and SQL Server Developer, and, with some restrictions, in SQL Server Standard.

Before Installing Failover Clustering

http://msdn.microsoft.com/en-us/library/ms189910.aspx

I started my post with this.

I agree on the limitations of CREATE PROCEDURE. On the same...

SQL Server automatically creates a fair number of schemas that we arn't using, particularly after an upgrade. As an example there are schemas for each of the built in...

Use INSTEAD OF trigger for DELETE

1.DELETE N identity row (in your example 3).

2.UPDATE the identity rows more than N

3.UPDATE FKs as well. (if any)

Or

3.Can be defined the...

'INSERT INTO' calsue expect table to EXIST but 'SELECT INTO' doesn't. Try the code below.

CREATE PROC test_delete

AS

BEGIN

BEGIN TRY

BEGIN TRAN

--INSERT INTO table1

SELECT 1

INTO table1

...

Well I can understand the scenario & your worries / frustration as well. I have experienced it. I don’t remember exact code that caused the issue BUT here is something...

Lynn Pettis (11/10/2011)

---

swetha2813 (11/10/2011)

---

I have two columns in which column1 has interger and column2 has data like this 'Sat Oct 01 00:00:00 GMT-0400 (Eastern Daylight Time) 2011'. In the oracle...

It could be the...

To trace deadlock events, add the Deadlock graph event class to a trace. This event class populates the TextData data column in the trace with XML data about the process...

Kudikai (11/10/2011)

---

Here is a script I tossed together based on something I read in the 70-432 book. It will reorganize indexes or rebuild indexes based on thresholds. The variables...

Log truncation occurs at these points:

•At the completion of any BACKUP LOG statement.

•Every time a checkpoint is processed, provided the database is using the simple recovery model. This includes both...

Adventure Works Sample Data Warehouse

http://msdn.microsoft.com/en-us/library/ms124623.aspx

Microsoft SQL Server Community Projects & Samples

http://sqlserversamples.codeplex.com/