ALTER VIEW dbo.[Vw_GetCurrentDate]

WITH SCHEMABINDING

/*

* A view to return one row, with one column, the current

* date/time from the built-in function GETDATE(). This

* view allows a UDF to...

Please update your article for 2012...Thanks

SELECT COUNT(1) AS [COUNT(1) Should be 8]

, COUNT([Name]) AS [COUNT(Name) Won't be 8]

, COUNT(*) ...

It would be nice if sysjobs and other table are mentioned as scripts to accent the name,steps etc.

Those bullet point should have links to refer to read related materials.

Sure give it a try. Let us know the details.How to documentation will be good.

In the msdb database these tables have the information that you need,

dbo.sysdtspackagelog,

dbo.sysjobhistory

Check BOL for more information

use BIDS to create an SSIS package.You can specify from Access to SS05.you may need to scirpt the truncate. good luck.

use SSMS and look under Managment>legacy>Data Transformation Services.Import DTS package is here.Good luck.

Right Click on the Package, and click schedule, just follow the screens and schedule your job

hi , if you install a second instance of SQL Server .

Than you should be all set!!

There is a SQL Profiler that comes with SQL Server.

You can see alot of things from SQL Profiler.

Hope this helps