Home Forums SQL Server 2005 Administering Is there any way to flush out a stuck process in sql server RE: Is there any way to flush out a stuck process in sql server

  • I have already checed all the sql jobs and windows scheduled as well, there is no job scheduled .

    about SQL DMO:

    Most SQL Server administrative tasks are programmable by SQL-DMO, (DMO) is a set of programmable objects that come with SQL Server that make it easy to programmatically administer the databases instead of using the console we can do the following:

    Scripting Objects

    Backing up databases

    Creating jobs

    Altering tables and much more

    As it is a COM object, you can use it in any COM friendly platform.

    - the host name for DMO process is showing that database server name itself.