You don't want to issue your own BEGIN TRANSACTION in the trigger, since, as I noted before, you're already in a transaction.

That error message after the ROLLBACK is normal, to...

Jeff Moden (2/18/2013)

---

Except for Sean, we did forget to answer the original question. :blush: Thanks,...

Modest DBA (2/18/2013)

---

100% i agree with you, but the thing is also not data loads.

To curb this, i requested a data count, after every table re-load, and the difference between...

Under no circumstances should you cluster this table on Policy_transactional_ID.

Cluster the table by the most common WHERE conditions; make the clustered key unique by including the Policy_transactional_ID on the end...

declare @enddate datetime

set @enddate = getdate()

SELECT STUFF(CONVERT(varchar(10), DATEADD(DAY, -21, @enddate), 1), 3, 4, '')

Instead of constantly trying to adjust the max size, I'd suggest setting the max to "UNLIMITED", then monitoring and alerting for every file growth occurence instead.

All triggers are implicitly part of a transaction, with at least the SQL statement that caused the...

I've got scripts that will generate point-in-time recovery scripts. And generate and execute tail log backups.

I suspect you could get a script(s) from the web for that and modify...

Jeff Moden (2/15/2013)

---

ScottPletcher (2/15/2013)

---

Jeff Moden (2/14/2013)

---

ScottPletcher (2/14/2013)

---

That's a significant change!

In order, here's a quick list of the most important things to do first:

1) Make sure the DBA role will fit...

Jeff Moden (2/14/2013)

---

ScottPletcher (2/14/2013)

---

That's a significant change!

In order, here's a quick list of the most important things to do first:

1) Make sure the DBA role will fit you. As...

Do you want to test DateDesc for within the last 30 days?

If so, then maybe this (added that check to the WHERE clause):

select

activityname,

dd.datedesc,

dateadd(hour, - 5, DD.DateDesc) AS date_completed,

getdate()-1 as...

Have to admit, I just upgrated in place from SQL 2005 to 2008. It's fairly straightforward. (Nothing at all like the huge changes going from SQL 2000 to...

Very nice, but technically wouldn't remainder 1s be table A, remainder 2s be table B and remainder 0s be table C?

Sean Lange (2/14/2013)

---

ScottPletcher (2/14/2013)

---

Nope, you're not quite there yet, one other changed to make.

You should always specify the owner (schema name) on objects in a trigger. There are very...

That's a significant change!

In order, here's a quick list of the most important things to do first:

1) Make sure the DBA role will fit you. As a developer, you...