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

It's not an elegant way of doing it, but you could schedule your job to run every 45 minutes starting at midnight, and include an initial step to check that...

Please will you post your table DDL in the form of a CREATE TABLE statement, some sample data in the form of INSERT statements, and, given that sample data, the...

Try building your ALTER_TABLE statement as a @sql variable. Then you can PRINT @sql as well as EXEC (@sql). If any of the statements fail to add the...

Parameter name is Param1 for the first parameter, Param2 for the second, and so on.

John