Forum Replies Created

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

  • RE: Maintenance Plans ?

    Thanks for the assistance.  last week I ran your steps - well - these steps

    run dbcc DBCC SHRINKDATABASE

    then DBCC UPDATEUSAGE

    then exec sp_helpdb 'DbName'

    and all was well - I cleared up...

  • RE: Maintenance Plans ?

    Thanks.  Since no one has access to this database but myself - then there will be no unsafe entries after the first backup - am I correct - so one...

  • RE: Maintenance Plans ?

    Thanks.  Dumb question - why the 2 backups? and what does then exec sp_helpdb 'DbName' do?

     

    Also does this take a major hit on performance on my SQL server - the...

  • RE: SQL AUDIT

    Thanks.  If I want it to never run again - can I just delete it or is there anythingi special I need to do?

     

    I saw in Query Analzer that it...

  • RE: SQL AUDIT

    Thanks.  The mirroring in this article so far has been helpful. 

    Next question - it mentions setting up a trigger - once you apply a trigger how would you stop...

  • RE: backup of Database/tables

    Thank you!

  • RE: SQL AUDIT

    Thanks.  My goal is to see when and by who records from on table in the database were deleted and/or changed.

     

    Any ideas are welcome - I will also search for the...

  • RE: SQL AUDIT

    Ok - how about going forward - what is the way to do this?

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