Question is:

How can I know what were the droped objects from the default trace.

Can I use a function from SQL Server?

The default trace can be read from inside the sql server? do I have any function to read it?

Hi,

I tryed this funcion:

USE ReadingDBLog

GO

SELECT

Operation,

[Transaction Id],

[Transaction SID],

[Transaction Name],

[Begin Time],

[SPID],

Description

FROM fn_dblog (NULL, NULL)

WHERE [Transaction Name] = 'DROPOBJ'

GO

but this gave nothing....

I have the simple...

Thank you very much. I will test it today.

I just cannot create it. the sintaxe seems very complicated.

I don't have problems. I just can create it. It's my first time with triggers.

Hi Gail,

What do you mean by stop using select?

What other possibility to I have available to select from a pre existing view?

tks

Thank you for the reply GM.

example:

select * from vw_teste

pivot (AVG(ocorrencias) for metodoctb IN ([tipo 1],[TIPO 2],[TIPO 5],[TIPO 7])) as teste

this has average.

I don't want average..

That's what I have looked in the first place. But I always have to put na operator like AGV.

I don't want any average.

I want to have always those 4 columns but some times some do not have values.

Hi,

It's four different columns.

thanks

Thank you.

But this means that there will be no SPTK for SQL Server 2014?

same happen if I connect from inside a vmmachine

thanks