Pretty,

I am unable to locate NumberOfCores and NumberOfLogicalProcessors properties in Win32_Processor Class.

It would be helpful if someone post the script for Win 2k3, Win XP that includes these properties.

Manu

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

Have you checked

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=236203&SiteID=1

Try using the view written by Slava Oks under the below mentioned link:

Tracking VAS in Yukon:

http://blogs.msdn.com/slavao/archive/2005/01/26/360759.aspx

Hope it provides the necessary info about VAS...

Kumar,

Have you chked the existence of backup device named "SQLTMP" on the server where you r trying to restore the backup file?

Manu

DAC stands for Dedicated administraotr connection-New feature introduced in sql 2005. SQL Server 2005 provides a special diagnostic connection for administrators when standard connections to the server are not possible....

Terry,

I turned it off when data import operation was going on(but I was already late by tht time).

Lesson learnt: Keep AUTO_SHRINK OFF.

Thanks for asking.

Manu

You can alter system tables as per

http://www.sqlskills.com/blogs/paul/2008/06/12/TechEdDemoUsingTheSQL2005DedicatedAdminConnectionToFixMsg8992CorruptSystemTables.aspx

link but better to stay away from such options.

You can put the SERVER into single-user mode, then connect with the DAC...

Gila,

Data import process completed its successful execution and then auto shrink succeeded too.

Thanks for all replies.

Manu

If batch file is on the same server where sql server is also installed then what permissions do I need to provide to a user who wants to execute it...

Check these ones:-

How to Install SQL Server 2000 Clustering

http://greatpbs.com/objects/Documents/SQL%20Server%202000%20Clustering.pdf

Read High Availability using Clusters under

http://hosteddocs.ittoolbox.com/CK121704.pdf

Clustering SQL Server 2000 from 500 Feet

http://www.sqlservercentral.com/articles/Installation/clustering_a_sql_server_machine_/344/

Step-by-Step Guide to...

Thanks for the reply. What if in case I need to call dtsrun.exe(located on sql server) from a batch file that is present on some other application server?

Please suggest.

Manu

Thanks for the reply.

Manu

Gila,

I am waiting for data import to finish on its own. I dont think sql server will kill it by itself. Will it?

Patience is the only weapon with me now.

Manu

Gila,

Many Thanks. I chked just now and found that Autoshrink is blocked by data import process.

What should I do now, I created one 150 GB data file too(but it won't...

Gila,

Thanks for prompt reply. I have marked Auto shrink OFF now. Data import process is not blocked by this but its going very slow now. Already, 300 GB of data...