Forum Replies Created

Viewing 15 posts - 8,626 through 8,640 (of 9,253 total)

  • RE: Min/Max Server Memory

    just a small gotcha for this. If the OS is pressured and cant free memory it could bring the server to a halt. I prefer to start low and work...

  • RE: SQL Server - Domain controller

    open the DNS snap in and add each of the DNS servers in then check the zone configs

  • RE: SQL Server - Domain controller

    open the DNS snap in and add each of the DNS servers in then check the zone configs

  • RE: Min/Max Server Memory

    Mani

    i would start with 11GB RAM for SQL and the rest for the OS. Monitor the server and check the memory usage\requirements, adjust as necessary

  • RE: SQL Server - Domain controller

    firstly have you removed DNS from the terminal server?

    have you installed DNS on DC2?

  • RE: Min/Max Server Memory

    Mani (12/18/2008)


    Hi Gail,

    We have windows 2003 EE R2 x64 with SP2 and SQL Server 2005 EE x64 with SP2.

    We have 16GB RAM.In Our SQL Server instance sharepoint Application databases are...

  • RE: Lock pages in memory

    well, depending on where you read. MSDN states that AWE is only available for 32bit Ent and Dev sql2005. Technet states AWE available for Std, Ent and Dev. This has...

  • RE: Lock pages in memory

    if you're not sure what it does why use it. What version is your OS and SQL instance?

  • RE: Updating Values Without Cursor

    phew, not a pork chop in sight LOL

  • RE: view a running trace

    set up a server side trace using the following

    SP_TRACE_CREATE

    SP_TRACE_SETEVENT

    SP_TRACE_SETFILTER

    SP_TRACE_SETSTATUS

    also the functions

    fn_trace_gettable

    fn_trace_getinfo

    to generate a trace definition use the following syntax

    declare @traceidout int

    declare @maxfilesize bigint

    declare @on bit

    set @on = 1

    set @maxfilesize =...

  • RE: SQL Server - Domain controller

    bit difficult to understand when i dont see what you see, are you able to send a screenshot of what you see in DNS MMC?

  • RE: Access Sql server Agent Windows service on remote machine

    which user have you logged on as on the other machine. Access denied is the key message here

    Your code really wants to be expanded as you are only checking for...

  • RE: SQL Server - Domain controller

    kestak (12/18/2008)


    I do not even know if DC1 is integrated

    see below for how to check this

    kestak (12/18/2008)


    1 - How do I create the right way a secondary zone for...

  • RE: SCRIPTING JOBS IN SQL SERVER 2000

    Jobs are fairly portable its the DTS packages if you have any that give the real headaches

  • RE: Backup failed with VDI Error

    jayesh_kherwadi (12/17/2008)


    Hi Guys,

    The database is on SQL server 2000

    this is the SQL2005 forum you have posted into

Viewing 15 posts - 8,626 through 8,640 (of 9,253 total)