Ninja's_RGR'us (1/6/2012)

---

Autostats will rebuild all the stats it needs. However if you have created stats manually then you need to copy those. If you changed stats settings you...

drew.allen (1/5/2012)

---

ChrisM@home (1/5/2012)

---

drew.allen (1/4/2012)

---

You'll need to post sample data illustrating the problem and...

Ok got it....

If the database is online and you plan to perform a restore operation on the database, before starting the restore operation, back up the tail of the log...

Thanks everyone.

Regards,

Skybvi

drew.allen (1/4/2012)

---

Actually, why are you using a subquery in the first place. Doesn't the following give you what you want?

UPDATE PLU_1

SET DSPL_DESCR = replace ([DSPL_DESCR],'"','in')

WHERE AND DSPL_DESCR LIKE '%"%'

AND...

drew.allen (1/4/2012)

---

The problem is that your REPLACE function is increasing the length of the string beyond the maximum allowed and you haven't correctly accounted for that fact. Given your...

ChrisM@home (1/4/2012)

---

where VND_ID NOT IN (select VND_ID from PLU_1

Where len(DSPL_DESCR)=40

AND DSPL_DESCR LIKE '%"%' )

This is functionally equivalent to Phil's LEFT JOIN.

You could also use NOT EXISTS as a correlated...

Hi,

I am not joining any table , its just a subquery..

Hope my query will clarify you more:--

update PLU_1

SET DSPL_DESCR = replace ([DSPL_DESCR],'"','in')

where VND_ID NOT IN ...

That...

Is this question applicable for sql server 2005?

I mean, will it work concurrently in sql server 2005?

Regards

Skybvi

Are you able to do with help of sp_help_revlogin ?

Regards,

Skybvi

Perry Whittle (12/21/2011)

---

To stop services remotely open the services.msc on your machine. In the top left of the services console where you see "Services (local)", right click and select "connect...

Correct

Regards,

Skybvi

Send mail task

This really helped me..

Thanks a lot koen

Regards,

Skybvi