you can use execute sql script task and there you write one script of select * into...

also gets the category name and filters out the report server jobs.

SELECT sysjobs.name 'Job Name',

syscategories.name 'Category',

...

SELECT job.job_id,notify_level_email

,name,enabled,description

,step_name,command,server,database_name

FROM msdb.dbo.sysjobs job JOIN

msdb.dbo.sysjobsteps steps ...

Thanks Lowel,

how to insert the currentdate into AA table with new policy number

i want code for all databases backups out in single lines of script it is for full,diff

all logins and password are saved in master database.

you need to script out of users from master database and excuete in your target server

and fix the logins /Users

you can learn from http://www.sqlservercentral.com/articles/XML/87685/

good queries

In the Creation table we can create a trigger on table.then easily we will know

By Using these scripts we can know the large space tables on the database.

Thanks SQLDBA Arjun for providing this

Nice Question about 2008R2..!

the average should be under 15ms with maximums up to 25ms. If your numbers are below these values then your I/O is in good standing and no additional disk bottleneck...

--Cursor to check with all other records

While @@fetch_status=0

Begin

Set @cnt = @cnt-1

yaa its creating table varibe only