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...

write an update statement in stead of the delete / insert.

Keep in mind, you need to check if it actually updated a row (@@rowcount)

Because if it didn't, you'll have to...

I would start sqlprofiler, your cleaning up of data may have caused some application to fail, hence it is trying to do its work, but rolls back time and again...

If you can, start with an empty table, because it will handle the partition shift at the apply partitioning time.

At insert time, it will put the data in the correct...