Hi

I got the result. But I again I faced an issue. the column contains some values without ' mark. I need to extract these records also using a single query

binu

hi

Thanks. I have to update the column with a value johnson's.

Also I want to select only records that contains ' mark.

binu

Thanks

Binu

Hi

I checked event viewer I got this error

SQLServerAgent could not be started (reason: Unable to connect to server '(local)'; SQLServerAgent cannot start).

Binu

Thanks

Can u help me how to do this in SQL 2000

Binu

Hi

Thanks

If my SQLSERVER is in windows authentication mode how can I change it to

mixed mode through registry settings.pls give me the details

binu

hi

Thanks for all

But in an interview i got a question that which is the situation we need sa login other than logins with sysadmin roles.

binu

Hi

Thanks. Can U give some examples

Binu