All other versions support job scheduling.

You are right. You can run a query as a job.

Minimun 1 minute.

Inteactive logon restriction does not impact SQL Server.

Becuase SQL Server is a service.

Services don't need interactive logon previlage.

Welcome.

Use "Maintenance Cleanup Task" to delete older .bak files.

Maintenance Plan automatically adds date time stamp to the filename.

e.g. master_backup_200711132245.bak

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.