As you only have three small strings to make initial caps I would personally stick with your first thought....

UPDATE dbo.wce_contact

SET

firstname= STUFF (lower (firstname), 1, 1, UPPER (left...

Ninja's_RGR'us (1/4/2011)

---

Lowell (1/4/2011)

---

sc-w (1/4/2011)

---

I nearly missed that post, i tried the following but it generates an error. Any thoughts?

update dbo.wce_contact set firstname = dbo.ProperCase(firstname)

Error:

Msg 1014, Level 15, State 1, Line...

I am sorry - I hadn't noticed that this was in the 2005 section - my bad!

NO, in 2005 the FT Index is not held in the database and is...

There is not default timeout like you describe. I have often left connections open for days at a time or even weeks.

It is more likely to be a bug in...

It's just a typo.

SELECT 'EXEC sp_help ' + QUOTENAME(name) FROM sys.tables

According to Books Online, SQL Azure does not support sp_procoption which is what you would use to have an auto-execute SP.

Perhaps you could have a scheduled task on a local...

Please read this article Martin : http://www.sqlservercentral.com/articles/Best+Practices/61537/

SELECT

display_term,

sum (occurrence_count) AS total_occurrences

FROM

sys.dm_fts_index_keywords_by_document (db_id ('your_database'), object_id ('your_schema.your_table'))

GROUP BY

display_term

HAVING

sum (occurrence_count) > 0

ORDER BY

display_term

Hi Martin,

One thing you should try to do is alter the design so that the "I" rows reference the related "S" row - that would make this much easier.

Before anyone...

Hi there, please take a look at this sample based on your supplied xml data and see if it makes sense and helps.

-- set up some sample data using the...

You don't need to use locking hints. The locks will be held until the transaction is committed or rolled back.

The first trick is to define what you want to exclude....

Then you can use the old double negative...

WHERE [column] not like '%[^A-Za-z]%'

where [^A-Za-z] means anything that is not a letter,...

Do you have 100-200 concurrent connections - that is all open and processing queries at the same time from the same client?

Have you checked that the application is closing it's connections when the work is done?