Check Database Integrity (should I include indexes?)

Please include indexes

Shrink Database(do I need to do it?, if yes I...

You may want to consider re-indexing table by table. Between two re-indexes you can also give a wait time of a minute or so. Also you can fire a transaction...

I second that. sys.servers should give you the details.

Please refer this article for some direction.

This article does it with screen shots.

This article on SSC should be useful to you.

Sorry 😉 I posted it in the wrong...

One more cross-post. I have responded to your question here

This article explains it better.

You may find this article useful.

Appending = Inserting

Please go through the INSERT statement details on MSDN.

1)actually i want to transfer some data of these table to a different database.

2)after that i want to delete data from these tables, but each table shud have at...

If you are planning to look for fixed number of values in the IN statement, you may declare multiple variable...

I am not sure what do you mean by SQL Server Network Service. SQL Server does not install any such service during installation.

You may use the Operating System command while creating the job step and append an output file to the cscript command like below.

cscript //B E:\backup\restore_script_codismaster.vbs >> C:\csriptoutput.txt

The output...