Hi

I got the below note in the associated Microsoft URL.

https://msdn.microsoft.com/en-us/library/ms187611.aspx

Users who have the SHOWPLAN, the ALTER TRACE, or the VIEW SERVER STATE permission can view queries that are captured...

Many thanks Jacob for the explanation

How to search this key value (@keyValue) in the code?

APPLICATION: 7:0:[TMsgRefs1]:(8886087a)

Nice Question. But is this solution only confined to SQL 2012/2014? I thought we follow the same in the earlier editions too.

Read through the default trace file to see if you can find the activities happened during the period. Or else, if you have any monitoring tool say, foglight/any other, check...

Hi,

I do not think the feature is edition dependent. So you should fiind it. Go through the below MSDN link for more details.

Now there is always a possibility that the...

Awesome. Thanks for the nice Christmas Tree. 🙂

Soemthing is wrong here in the question. I guess the choice should be "only 1".

orderstatus can not be changed to "OrdeNotes" as summarynote is dependent on OrderNotes!!

Got it right. 🙂

I thought after this we may need to drop the old user too. 🙁

Nice Question. Thnx Steve!

Thnx Jacob..

Even I wrote this one . But I liked your script.

SELECT TOP 100

s.server_name,

s.database_name,

m.physical_device_name,

CAST(CAST(s.backup_size / 1048576 AS INT) AS VARCHAR(14)) + ' ' + 'MB' AS bkSize,

CAST(CAST(s.compressed_backup_size / 1048576 ...

Hi Gila

I modified the script i.e. after the specific full bkjp is completed, my script is taking the tlog backups. I infact did a restore test and it works flawlessly.

Thanks...

It was because of some reverse dns issue. It is fixed now.

I'm running the script via a job which will run by the time the full bkp job will run and will run in every 30 secs to take more frequent...