Yes. Maintenance Plan does this job.

Use PIVOT operator.

Welcome.

Mistakes happen sometimes.

Change the foreign key constraint name from MANAGER to FK_MANAGER.

Welcome.

1) Using SSMS generate scripts to create table and indexes.

2) Run the scripts in the other server.

3) Export the data.

declare @string varchar(2000)

select @string = 'bla bla bla XYZ yatta yatta text text text etc...'

select substring(@string, charindex('Z', @string) + 1, len(@string))

Use CHARINDEX function.

Yes.

1) Detach the database

2) Move the files

3) Attach the database

UPDATE [MyTable]

SET column3 = column2

WHERE column2 LIKE '%thisvalue%'

AND account = '105'

Sugesh,

Recently, I was in similar situation. I guessed the process name and ended it using Task Manager.

It worked.

Suresh B.

End that external process using Windows Task Manager.

You are welcome.

This is enough:

UPDATE [MyTable]

SET column3 = column2 where account = '105' --trying to move records to account 105

Remove:

FROM (SELECT column2 FROM [MyTable] WHERE account = '101')