Forum Replies Created

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

  • 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" 😉

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

    so your backing up via a maintenance plan are you?

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

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

  • RE: Flat File Option Missing on Import Wizard

    CrazyMan (7/29/2008)


    Windows NT 5.1 (Build 2600: Service Pack 3)

    this is your windows OS build version, i am referring to SQL2005 SP2

    the SQL product version being reported here

    Microsoft SQL Server 2005...

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

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

  • RE: Flat File Option Missing on Import Wizard

    just a thought, have you applied SQL2005 service pack 2 to the machine

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

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

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