OK.... thanks to all.

What about scheduling system monitor and get the output to a csv file. Tne read from that csv file..Any issues, if it is a production box ?

Ok, I need to get total cpu utilisation of the server each hour. I was calling WMI classess through T-SQL for this purpose. But in windows 2003 WMI access is...

The best solution can be installing SP4

I am getting the same error when i open QA at the server where instance is running

I am executing the bcp from QA on the server itself. The server is having only one instance which is local

I am not getting an error whn i execute the same command without server name...

exec master..xp_cmdshell 'BCP Admin.dbo.tbl_abc out "c:\Temp\test.bcp" /T /n /b1 /m1'

Expers !!! any suggestion on this ??

sorry it is 8.00.850 with SP3

thanks a lot - Bkelley.

canu give some tips on how to do this thing (wrap this in to client code)

Trace is giving just

Begin Tran

Rollback Tran

and nothing in between  begin tran and rollback tran

Hi,

Put manual entries for MDF/NDF/ fies in sysaltfiles  table. Put new manual entry for new LDF file in sysaltfiles. for the database to be attached

Put manual entry in sysdatabases table...

this problem got solved after installing SP4

thanks a lot

I need to truncate my primary log file.......which i am not able to delete

please..................

any solution for this ???

I have two log files . so it will not create new log files while attaching

ok thankx..

But can we do something on the test setup (that i have already copied??)