you could experiment with your trigger using :

SELECT T.text

FROM sys.dm_exec_requests R

cross apply sys.dm_exec_sql_text( R.sql_handle ) T

WHERE R.session_id = @@spid

hard to say.

I can drive from here to Rome in my 2CV in 5 days.

I can do the same with my Porshe in 5 days if its engine isn't allowed...

Do also check the actual database owner for the involved databases.

If you performed the restore, the database will have your userid as owner unless you've executed sp_changedbowner after the recovery.

Exactly what I've been preaching over here 🙂

Configuration nor budget is my call in this case :Whistling:

But this being the first case since this new hosting company is in charge,...

we always use a windows domain account as service account for our sqlserver instances.

Are there firewalls involved ? If yes, did you open the needed ports ?

6 spindles:

4x136GB -> 2 RAID1 volumes -> C-drive and D-drive

2x300GB -> 1 RAID1 volume -> E-drive

I hope they upgraded all hardware drivers before they made it available because that was...

Thank you for your reply.

Having my concerns confirmed certainly counts !

Apparently our hosting company works at "least effort" basis and doesn't heasitate to charge big piles of $$ just to...

aren't you just killing your engine using all these cursors, UDF in in-clauses, row level nested views ( who knows what is in there ) ...

How about adding a group...

could be kind of application logging that has been implemented and enabled.

Could it be an insert on a cursor-ed object (ado recordset insert) ?

unlike the old syntax ( not using the keyword JOIN ) the placement of the on-clause predicates don't play a role in determining the left part of your left join.

...

+5 stars ( and that's just because that is the maximum supported over here ) :hehe:

Well said, Jeff :w00t:

the way you did it is grouping by minute ( not taking year/month/day/hour into account )

This is how I would do it.

SELECT

datepart(mi,[startDate]) as MI,

min(startDate) as startDate,

avg(duration) Duration

FROM ...

well, consider it as if you were to write the from part in a (long) single line

In English, we read it from left to right, correct ?

Hence a left...

I'm glad SSC republished your fine article, Gianluca.

Nice work, great descussions.

did you try :

, CASE WHEN ss.enabled IS NOT NULL THEN 'Schedule is enabled'

...