you can do one thing

1. create a intermediate table

2. insert

SELECT @msg = ISNULL(@msg+CHAR(10),'')

...

i dont think you can see the older version of Sp unless you are preserving it in Audit table with the help of DDL trigger.

HOw did you figure out this ?...

if...

post your script

that depends on the volume of data.i guess you don't have high...

Shamshad Ali (6/2/2010)

---

There are 210 tables, 24 views, 280 SPs, 50 functions with DB size of 8 GB. I am looking for a quick way to figureout the indexes issues....

i would say

1 run the exec plan.

2 capture the scans and lookup there.

3 modify/create indexes.

4 again run the exec plan to see the improvement.

Ravi-376012 (6/2/2010)

---

ContactID BIGINT NOT NULL IDENTITY(1,1) PRIMARY KEY,

FName VARCHAR(50) NOT NULL,

LName VARCHAR(50) NOT NULL,

Address1 VARCHAR(255),

Address2 VARCHAR(255),

----,

StateID INT,

.....)

Now I have two options one is to have a State lookup table using

StateID...

PradeepVallabh (6/1/2010)

---

I have a lock on the update statement.....After carefully examining the execution plan i noticed there is a 93% Cost on Clustered Index Update pk_xyz_abc....Is there anyway to tune...

elutin (6/2/2010)

---

As promised, another version. It contains much more code, but it's probably the fastest way to do what you require:

--We need to copy the data from the master table...

Always try to keep column's name and their datatypes same.

post your problem according to the article referred in my signature to get faster response

i dont think it can be...

it could be because of windows patch or sql server patch/Service pack