Thank You very much Todd.

My Trigger got executed successfully with your help

Hi ,

I had restarted the agent. It is working now.

Thank You,

Hi,

I had turned of autoclose on the database and now things are working well.

Integrity checks and backups are running well now.

Thank You very much for the help.

As autoclose is on...

Hi,

name user_access_ desc log_reuse_wait log_reuse_wait_desc state_desc

Commun MULTI_USER ...

Hi ,

Below is the error message when we are running the backup of the commun database.

Date8/19/2012 11:15:00 PM

LogJob History (DatabaseBackup - Commun - FULL)

Step ID1

Servertest

Job NameDatabaseBackup - Commun - FULL

Step...

Backups are failing for that database and integrity checks are not running successfully for that database

Hi,

CHECKDB is running for that database through out the day every few minutes.

There is no job associated with the checkdb to run through out the day. I think vendor is...

Hi ,

The required information is present in the current SQL Server Error Log.

It is not present in the Archive #1 SQL Server Error Log.

Information related to this Log file is...

Hi

The Log file of the database is present where it is supposed to be.The drive on which the log file is present is online.

Thank You,

Hi,

The log file for the database is present and the drive is online on the server.

Log files of other databases are present on the same drives and they run without...

Hi,

This is the error log message before that issue happened.

Transaction (Process ID 12) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun...

Hi ,

View definition on the schema also did not work for the user TESTDOMAIN\TestUser in the test database.

Thank You

Hi ,

Even when i had granted the database owner permissions to the user TESTDOMAIN\TestUser in the test database.. The user is till not able to see the stored procedures.

Thank You,

Hi ,

I have not dropped or altered the certificates in the master database. I have not altered any object in the resource database.

Thank You

I count not find any information relating to this in event viewer or SQL Server Logs