Same steps as recovering any database to a point-in-time, I would guess. I don't know what "the TDE" database is, though.

Restore from the appropriate Full backup, using the With...

You can definitely get that with ranking functions, or with Min/Max, more efficiently than with a cursor.

;

WITH CTE

...

For a job, you just pick that the step type is an SSIS package, and then tell it where the package is in the details for the job step.

Here's how I do that:

SELECT DATEADD(month, DATEDIFF(MONTH, 0, GETDATE()), 0),

DATEADD(month, DATEDIFF(MONTH, 0, GETDATE()) + 1, 0)

You can use a variable, parameter,...

RedGate has a product that will do that for you.

Without that, I expect it will be a matter of querying things like:

select *

from sys.sql_modules

inner join sys.servers

on definition like '%' +...

The problem is a deadlock. Carriage returns won't cause that. You need to find out what the deadlock is being caused by.

Dave Ballantyne (2/15/2011)

---

Big meeting on friday to best decide how to handover all my knowledge to co-workers.

First big change i need to do today is was told to make the...

Enterprise Manager??

If Enterprise Manager is pinging anything from my computer, I'm really confused, since I haven't used that in almost five years! 😀

(Does this have an analog in SSMS?)

Grant Fritchey (2/14/2011)

---

GSquared (2/14/2011)

---

GSquared (2/14/2011)

---

Tom.Thomson (2/11/2011)

---

Yes, and now as a result of nadabadan's reply to Brandie our favourite Saint is feeding the troll. Will...

GSquared (2/14/2011)

---

Tom.Thomson (2/11/2011)

---

Yes, and now as a result of nadabadan's reply to Brandie our favourite Saint is feeding the troll. Will this wear him...

If the view references the table that is being updated, then a lock on the data in the view will block the update. That can result in a deadlock.

nadabadan (2/8/2011)

---

GSquared (2/8/2011)

---

nadabadan (2/8/2011)

---

GSquared (2/7/2011)

---

nzngh (2/6/2011)

---

It was an Interview question, surly I couldn't answer it. I have tried it in any possible way that I know but I got only...

WayneS (2/13/2011)

---

I thought you Floridians broke out the coats when...

Tom.Thomson (2/11/2011)

---

Yes, and now as a result of nadabadan's reply to Brandie our favourite Saint is feeding the troll. Will this wear him down...

Given the specification, I'd implement two parameters, one for delimiter, one for byte count. If the delimiter is null, and the byte count isn't, use the byte count, otherwise...