From the trace, I find the login is trying to reach a db that is not existing.

Is there any way to find when was the database renamed or dropped?

Thanks for the help.

I don't think this table has child tables. When I check for dependencies I didn't see any other tables that depend on the error table.

I run the...

Space means in the destination server or source server?

Here is the table structure

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[ERRORS](

[Id] [uniqueidentifier] NOT NULL,

[InnerErrorId] [uniqueidentifier] NULL,

[CreatorFK] [uniqueidentifier] NOT NULL,

[Created] [datetime] NOT NULL,

[Trace]...

We are using Sql 20082 Standard edition. Data drive has enough free space but that table stores the errors that we don't required to store more than 3 months.

To do...

Table total size is 5000MB

Thank you

Thank you. Now it is working

I started role as DBA. I want to find the permissions to the remaining users like below but when I execute this it is throwing error

Can't execute as the database...

Thank you. I am clear about that now but

Is the snapshot isolation can be applied to any type of queries. i.e. functions also or is there limit?

Is the serializable is...

To use RCSI for individual query

we have to use

ALTER DATABASE AdventureWorks2014 SET READ_COMMITTED_SNAPSHOT ON

for each transaction if it is not enabled in the db level

Thank you.

We are using the third party tool (Sql Sentry) to monitor the Sql server

Thank you.

That login is using in all applications but I didn't get any complaints from application team.

I will find out the dropped database name.

We don't have domain so we are using Sql logins only

I know the host name where the login is trying to connect and from the profile I can see the database name is master