server side SQL profile would help you catch 3rd part tool initiating command with host name.

Both server and database level collation same as well?

We are looking at tool that tracks and keep history and allow us to dive into issue. We have current monitoring and in-house developed tool that allow us to go...

Thank you all who responded so far.

This is what I have

- RML Utilities

- SQL Nexus

- Idera Performance diagnostic manager

- SQL Sentry

- Red Gate SQL response

Anything else for anyone else? If...

Is this in cluster? If so, check if SQL agent service for your instance running on both nodes.

Thanks winash.

We are using RML utilities today. I will look at the SQL nexus tool as well.

We are trying to evaluate and looking at buying performance diagnostic tool that...

nope

Thanks it worked. But Why would not work with "Go" as it is batch seperater?

We do log backup regular basis but with full recovery this log has been grown out of proportion with daily nightly loading data. In this database we load lots of...

I have T-SQL script with at the end select which goes into job step and I need that in ANSI.

There are lots of professional tools.

Visio

Erwin

etc.

Is the Rollback process being blocked by any other process? Please check that you rollback operation is not blocked before you make move.

new group with 4 id and being owner of new schema. db_denydatawriter to disallow insert/update/delete.

This only works with the database to do the backup and restore. if I have backup from somewhere else where the user ids are different db_owner can't restore as they...

I want to give them both backup and restore. I will look at the db_owner with backup and restore.