your welcome 😉

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...

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...

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...

so your backing up via a maintenance plan are you?

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

the SQL product version being reported here

Microsoft SQL Server 2005...

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

eek now i'm getting worried 😀

how are you backing up the databases?

Via a maint plan or a custom job or maunal T-SQL script, etc?

GSquared (7/29/2008)

---

it's too high risk for us to run a script like that without knowing, from you, what's wrong with it. What if the problem you were running into...

the import wizard inside SSMS uses sql integration services so you have to have that installed.

The Oracle 10 client should be backward compatible with Oracle 8

ensure you scroll to the very top

why not just allow the sql maint plan or job to delete files after N days

thats what i thought.

when the wizard starts, after the welcome screen the next screen is the choose data source dialog. Drop down the list box "Data source" and "flat file...

how are you importing?

are you importing via SSMS?