Forum Replies Created

Viewing 15 posts - 31 through 45 (of 48 total)

  • RE: SQL Mail

    You can either do it through the services console in windows or under the SQL Agent properties in Enterprise Mangager.  Also you might have already done this but you will...

  • RE: SQL Mail

    Have you set the SQL Agent to run under the same domain account that your mail profile belongs to?

  • RE: Backup Software and SQL Monitoring Tools ! Your Experience

    I also am using Red-Gate SQL Backup and have been very happy with it.  I currently have over 50 SQL2000 and SQL2005 instances using it and it has been a great asset. ...

  • RE: How To Clear the SQL Server Activity Log

    This is one of many reasons why I remove group Builtin Administrators group.  If you have a DBA you don't need your Sys Admin with that level of access.

  • RE: dbcc traceon

    I have an enterprise application that I battle a lot of deadlocking with.  I have always seen that when I enable the trace flags for deadlock info that they disable...

  • RE: Error attaching and restoring a SQL 2000 database

    Have you attempted to attach that database only using the data file and letting sql server recreate the log file?

  • RE: Trigger To External DB

    The only way I could see you being able to do this is if you create a linked server to this Non-MSSQL database.  As John stated before this is not...

  • RE: SQL Restore problem

    Also, I don't remember for sure but you might have to restart the instance to make the change take affect.  You will just have to try and see.

  • RE: SQL Restore problem

    I am positive that you can.  I have done it many times.  Below is the content from BOL:

    Syntax

    ALTER DATABASE database

    { ADD FILE < filespec > [ ,...n ] [...

  • RE: SQL Restore problem

    When restoring though the GUI it will not allow you to change the logical file name.  However, you can change this after the fact by issuing an ALTER DATABASE command. ...

  • RE: Database Mail Setup

    Check to see if that DB server has rights to relay to the exchange server.

  • RE: PAE Enabled

    I noticed that enterprise edition was specified for the O/S but not for SQL Server.  Was this just left out or is it only running standard edition?

  • RE: SQL Server not using all available memory

    I want to thank everyone who responded.  The microsoft article referenced in one of today's posts was exactly what I was looking for.  It is plain to see that my...

  • RE: SQL Server not using all available memory

    It must be used to manage some kind of overhead.  Thanks for you input.

  • RE: SQL Server not using all available memory

    This is a dedicated server.  There are no other applications running.  The memory settings are set for dynamic control with no maximum limitation.  I really appreciate your input.  Do you...

Viewing 15 posts - 31 through 45 (of 48 total)