Where is this class :

"Win32_PerfFormattedData_MSSQLSERVER_SQLServerMemoryManager"

I can not find it in my server and not in MSDN.

You can use a Window Script Host popup methode to popup a message and the message box will terminate itself after a defined time (second).

This methode is not an Event...

Add this script to your Activex script task to reboot the Server.

'To reboot the local machine

 strComputer = "."

'To reboot other Machine

' strComputer = "10.231..."  or Machine name

Set objWMIService = GetObject("winmgmts:"...

You can use SQL DTS to shutdown the Server and SQLDTS FTP to FTP files. 

Use WMI Class Win32_OperatingSystem in the DTS Package to reboot the Server.

You may need to create a DTS package and a VB script

below is using WMI to detect and start the Service.

' =======================

'Local Server

strComputer = "."

sServiceName ...

Andy,

You can kill the Connection ID with SQLDMO.

This is a VB module I used to kill all other connections except my connection. I hope this may help other.

'--------------------------------------------------------------------------

' Kills...

Thank you all for helping me out.

This script works for me:

exec sp_msforeachtable "sp_changeobjectowner '?' ,'dbo'"

And thank you Brian K for your article on msforeachtable.

Regards... Ang

Hi ceneja,

I am unable to find 'sp_msforeachtable' in the books online.

Can you give me a little more detail on your script? or your stored procedure?

Thanks...Ang

Thanks Andy.

This statement works:

EXEC sp_changeobjectowner 'Andrew.T1', 'dbo'

Thanks alot... Ang

Yes, all tables were created explicitly with owner name.

And how can I replace the owner name with 'dbo'

The table was created with the owner's name.

To select the content of the table, I need to provide the owner's name.

"Select * from Andrew.T1"

Otherwise, if I use

"Select * from...

The book is 'Professional SQL Server 2000 Programming' by Robert Viera and publisher is Wrox. Chapter 32/ page 1174. It says

- SQL-DMO is no longer the recommended approach to manage...