Forum Replies Created

Viewing 6 posts - 1 through 6 (of 6 total)

  • RE: DTS Hanging

    hi sir,

    Thanks for the immediate reply.The DTS is updating the local Database's table few fields data.Actually upating the current reservation status.I give the owner as 'sa' ,It is not...

    December 9, 2007 at 8:39 pm

    #758447

  • RE: How can I pass value from one DB to another

    HI,

     I already got the solution from another post by saving the query the global variable using script component.Then execute the task from global variable.Thanks

    August 21, 2007 at 5:44 pm

    #728459

  • RE: SQL 2005 ReportserverTempDB size 5GB

    backup log dbname with truncate_only works for me.

    Thanks

    July 19, 2007 at 6:25 am

    #720716

  • RE: SQL 2005 ReportserverTempDB size 5GB

    Eliminate the log file completely

    Sometimes we just do not need the big log file. For example, I have 40GB log...

    July 18, 2007 at 12:10 pm

    #720482

  • RE: SQL 2005 ReportserverTempDB size 5GB

    I done all the steps still the log file size dont change.

     

    step 1 : ALTER DATABASE ReportServerTempDB SET RECOVERY FULL

    step2  :  DBCC SHRINKFILE

    July 18, 2007 at 11:22 am

    #720460

  • RE: server slow

    hi all,

    Thanks for the reply.When I run the stored procedure ,it took 10 minutes to exeute, in the mean time I run 'sp_who2 active',so I noticed that CPU time=426815, diskIO=152324...

    May 3, 2007 at 11:08 pm

    #704281

Viewing 6 posts - 1 through 6 (of 6 total)