Well ... in your typical scenario .... there shouldn't be any user databases !

From the moment you add a user database, you should have a DRP in place !

That DRP...

Yes, Yes, Yes ....

- master is a must !

- resource db files .... maybe ... so YES too ! but only once after every install/hotfix/cu/sp

- model ? I don't,...

I join Lynn in the advise !

sp_send_dbmail is the way to go !

Have a look in books online to see how (easy) sp_send_dbmail can serve you.

It has nice features (profiles,...

If I'm correct, the default trace isn't running by default in SQLExpress :sick:

You should enable it using sp_configure 'default trace enabled', 1

Same goes for the DAC.

If you want a...

just curious ... can you share which solution you implemented ?

What other info can you provide ??

use master

select distinct req_transactionUOW from syslockinfo

Is SQLServer errorlog showing any related info ?

Is SQLAgent SQLAGENT.OUT showing any related info ?

Did your sqlinstance...

hmmm ... must be some of my bad habits 😉

I haven't used ranking functions that much, so they don't come loosely out of my sleeves :Whistling:

I still need to...

here's another version ...

Select *

from (

SELECT

rank () over( partition by IntTranID, IntLine order by IntTranID, IntLine , BrlDate DESC) as RNK

...

The value for the top clause can be a variable .

So

Declare @mytop int

select @mytop = max(brlcount) from ...

select top ( @mytop ) ...

no dynamic sql needed !

You can...

for authorization, being the actual dbowner or just member of db_owners db group is equal.

Thank you for the feedback.

So there must have been an error in the previous application of sp3.

On a rare occasion, we have also encountered this issue .... must have been...

blue_inelush (3/2/2010)

---

I've just read the article posted by you.

I can't believe that in all this time I've lived with the feeling that after the log backups, the .ldf file size...

1) avoid the xml ! it needs to be converted in a sql usable format every time you use it

2) You requested an update statement ...

Why would you need...

blue_inelush (3/2/2010)

---

ALZDBA, I have run the script provided by you and I've minimized my .ldf files.

My Production database is very intensive, so the .ldf file will increase and increase. In...

No a log backup only marks the log content "ready to be overwritten".

It will not shrink your transaction log file !

What is the result of DBCC OPENTRAN (to be...