Forum Replies Created

Viewing 15 posts - 9,061 through 9,075 (of 9,244 total)

  • RE: How to know a server have dual/quad core?

    Gordon (7/30/2008)


    Perry, can you elaborate a bit more on which part of the CIMV2 you used?

    WIN32_Processor, as i pointed out previously this class returns an instance for each core that...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: How to disable windows authentication on sql server

    from server config point of view you only have the options of

    mixed mode

    windows

    From the logins point of view you could remove builtin\administrators and any other windows groups\users, etc and this...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: How to know a server have dual/quad core?

    its easier to get the server tag id and check the manufacturers website LOL

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: How to know a server have dual/quad core?

    MANU (7/30/2008)


    I think the properties you are talking about are present only in Windows Vista edition and later ones:

    http://www.microsoft.com/technet/scriptcenter/topics/vista/wmi2.mspx

    Do let me know if I understand it wrong.

    Manu

    the root\CIMV2 namaespace should...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Connecting SQl Server 2005(64 bit m/c) to Oracle 8 (32 bit m/c)

    Windows 2003 x64 does allow some apps to install in 32bit mode for compatibilty but i'm not sure about the Oracle client, use the 64bit v10 if you have it....

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Moving Stored Procs along with Database.

    sounds like you'll need to check the application to find what procs are being called and from where

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Error while Restoring Database

    if sql server is running under a network service you will need to assign permissions to the folder you are referencing in the code.

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: One Click Installation Scripts

    start here

    http://technet.microsoft.com/en-us/library/bb839483.aspx

    and keep reading 😉

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: how long do you keep your log backups?

    if keeping log backups remember you also need the base backup(s) they are derived from

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: How to create new instance in sql server 2005

    jimlafantasie (7/29/2008)


    do you just run the install several times?

    Thanks.

    that is exactly what you do, specifying a new instance name each time

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: How to know a server have dual/quad core?

    yes, run it as a VBS script. Check the property you have added, try running the script as i supplied. Can you post the script you ran

    oops my bad, soory...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Keeping backup files that is only 2 days old and delete the rest

    your welcome 😉

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: How to know a server have dual/quad core?

    SQL ORACLE (7/29/2008)


    So far only did SQLServerLifer give a right direction.

    Device Manager does not provide the number of core processors.

    System Information from System Tools does not provide this information either.

    I...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: How to know a server have dual/quad core?

    a WMI query should produce this too

    strComputer = "."

    Set objWMIService = GetObject("winmgmts:\\" & strComputer & "\root\CIMV2")

    Set colItems = objWMIService.ExecQuery( _

    "SELECT * FROM Win32_ComputerSystemProcessor",,48)

    For...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: How to know a server have dual/quad core?

    you could ask your windows administrator or get the product type and tag and consult the server manufacturers website, if its Dell for example you could use the service tag...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

Viewing 15 posts - 9,061 through 9,075 (of 9,244 total)