Home Forums SQL Server 2008 SQL Server Newbies Job - Scheduled update table in another databaes nightly - please review and comment on script / process RE: Job - Scheduled update table in another databaes nightly - please review and comment on script / process

  • Firstly, it should be GIS.dbo.GISDaily and not dbo.GIS.GISDaily.

    Secondly you can leave the database in simple recovery.

    USE DBT;

    GO

    IF OBJECT_ID('GIS.dbo.GISDaily', 'U') IS NOT NULL

    DROP TABLE GIS.dbo.GISDaily;

    GO

    SELECT *

    INTO GIS.dbo.GISDaily

    FROM GIS_Info

    GO

    The SQL Guy @ blogspot[/url]

    @SeanPearceSQL

    About Me[/url]