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...

You can accomplish through the Execute SQL Task. You can write the custom sql script to meet your requirements.

For finding job details you may find this script useful.

Running sp_helplogins will give the details of all the logins on an instance.

How long did it take...