SQL006 (1/31/2016)

---

Thanks chris, Luis for the solution.

This is just the scenario i created, In production there is no temporary table #Test only physical table which consists of 2 million data....

hitesh jain (2/1/2016)

---

Yes we do have weekly maintenance jobs but in this particular case, its completely a different scenario. The server in question is a "dedicated warehouse" build server used...

The original post appears to be back, but the reply I had already posted is still missing. And so are the two replies posted later (that I did get email...

First, my apologies for not coming back to you sooner. I can make all kinds of excuses, but you were waiting for me and I should not have kept you...

Hmmm, that's strange. I got email notifications about new posts to a topic that I previously contributed to, but when I click the link I get an error message. And...

Thanks for posting CREATE TABLE and INSERT statements and expected output along with the description. That saves a lot of time!

The code below returns the expected results for your test...

Jeff Moden (1/31/2016)

---

Hugo Kornelis (1/31/2016)

---

Jeff Moden (1/31/2016)

---

Hugo Kornelis (1/31/2016)

---

I am once more going to be contrary. But let me start...

Jeff Moden (1/31/2016)

---

Hugo Kornelis (1/31/2016)

---

I am once more going to be contrary. But let me start with the positive: a...

I am once more going to be contrary. But let me start with the positive: a lot of the articles...

When the SQL Server service (re)starts, it will always drop and recreate the tempdb database. Based on the error messages, you did something that made this impossible.

The error messages indicate...

GilaMonster (1/30/2016)

---

Hugo Kornelis (1/30/2016)

---

True on...

SQL!$@w$0ME (1/30/2016)

---

Appreciate your help on this Hugo & Gail!

Updated the script:

USE [Test]

GO

/****** Object: Trigger [dbo].[TR_Aud_Update_Datetime_Update_User] Script Date: 1/30/2016 10:58:39 AM ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER TRIGGER...

True on SQL Server 2005...

Ed Wagner (1/30/2016)

---

Hugo Kornelis (1/30/2016)

---

I think that this, even more than the consumerist...

I am far from an SSIS expert, but with the little I know I think that you'll have to use an Execute Script task for this. Which means you'll need...