You could try [font="Courier New"]sqlcmd -L[/font]. It works better on some networks than others, though. Read the sqlcmd page in Books Online so that you understand the limitations.

John

This will return 1st April from the year two years before the given date. If you need the date presented in a particular way, do that in the application....

Or you could go with 13, 26 and 39 weeks, to make it more likely that the manger will be informed on a working day. Start with a query...

Jeff Moden (7/20/2016)

---

John Mitchell-245523 (7/20/2016)

---

The reason for changing to single-user isn't to get a connection to the database; it's to remove all other connections to the database. I've done...

Jeff Moden (7/20/2016)

---

John Mitchell-245523 (7/20/2016)

---

(Didn't see this response when it was posted.)

No, I haven't. I've...

Amit

Typically, detailed output from SSIS packages isn't written to the job history. You could try piping the output to a file or a table, or even into the job...

(Didn't see this response when it was posted.)

No, I haven't. I've suggested to the original...

Jeff Moden (7/19/2016)

---

John Mitchell-245523 (7/19/2016)

---

Have a look at this page. In particular:

By the way, I don't think you need to...

Yes, because [font="Courier New"]GO[/font] starts a new batch, so your variable declarations are forgotten.

It looks as if either your differential was taken before your full, or there was another full...

Have a look at this page. In particular:

By the way, I don't think you need to switch back to multi-user....

What does this return?SELECT wait_duration, wait_type, blocking_session_id

FROM sys.dm_os_waiting_tasks

WHERE session_id = 297

You may wish to execute the query a few times to see whether it changes.

John

Edit - corrected typo in query

Steve

You're right about PARTITION BY, but you just need also to add PolicyRef to the join predicate:WITH Prems

AS

(

SELECT

PremiumRef

, PolicyRef

, PolicyPremiumDate

, Amount

, ROW_NUMBER() OVER (PARTITION BY PolicyRef ORDER BY...

Indeed. ...

Have you tried a unique filtered index?

John

What do you get if you run this query?

SELECT log_reuse_wait_desc

FROM sys.databases

WHERE name = 'tempdb'

John