Cluster Admin and Configuration Manager both work for starting and stopping services, and as far as I know you can use SSMS as well. It's the Services applet that...

Yes. Make sure that "-" appears in cnsmr_accnt.cnsmr_accnt_crdtr_rfrnc_id_txt at position 2 or later. Read the Books Online pages for CHARINDEX and SUBSTRING so that you understand how they...

I'm guessing that [font="Courier New"]charindex('-',cnsmr_accnt.cnsmr_accnt_crdtr_rfrnc_id_txt)-1[/font] evaluates to 0 or less.

John

Actually, yes, my caveat doesn't apply in this instance, since all we're doing is applying an existence test. It's where you're taking a value from one table to update...

Beware - this will bite you if any row you are updating (call it table1) has more than one match in the table you are updating from (table2). You...

Yes indeed. It was an error in the code that I posted, but I...

What, even though there were 0 users fixed? My...

That syntax is deprecated and you should avoid using it where possible.

i tries this

ALTER USER [ram] WITH LOGIN [ram]

but it giving following error :-

Msg 102, Level...

You need to go into each database and use the ALTER USER command on each user that is affected, in order to associate it with the login on the new...

I don't think you can use that syntax. You could try sp_executesql with an output parameter.

John

Lowell (12/15/2011)

---

you left out the requored colaltion, but

the WHERE statement looks correct to me:

1. it's checking one specific table

2. finding only the columns that are lower cased

3. findinf only...

It needs to come immediately after the predicate to which you want it to apply. Try swapping the order of the AND lines.

John

Use the COLLATE clause, like Lowell showed you.

John

I'm guessing your database has a case-sensitive collation. Look at the name of the table you created, and look at the name of the table you're trying to insert...

Eric

How did you create the table?

John