Please provide a sample table and data. See the first link in my signature to help if you need it.

Short form: You'll be looking at creating a 'minutes' table,...

David O (9/20/2010)

---

Craig

I've updated on the post with the full sql statement for spid 94.

The detailed trace file has everything the spid 94 did from the full minute before...

An oddity for me, do you happen to still have eventsequence 7003193444, or was it completely unrelated to spids 91 and 94?

I'll save some researchers a bit of lookup for...

Steve Jones - Editor (9/20/2010)

---

I think moving to simple mode is the same thing, and cleaner. It's different, and it involves the change of code, but I think that the...

No, there isn't... they've wrapped implicit transactions with explicit ones but didn't including anything extra. THIS would be different, however:

CREATE PROCEDURE ProcName

AS

BEGIN

BEGIN TRAN

INSERT Statement

INSERT Statement

COMMIT TRAN

END

Edogg (9/20/2010)

---

NO_LOG and TRUNCATE_ONLY options have been removed in 2008. You can switch the recovery model from FULL to SIMPLE to achieve the same thing.

http://msdn.microsoft.com/en-us/library/ms186865(v=SQL.100).aspx

The BACKUP LOG WITH NO_LOG and...

Not that I don't believe you Gail,...

Besides the easy way?

SSIS package and manually ran job.

Stored procedure with drop/create on the target table and then a linked server to bring the data down.

Restore the production DB locally...

Heh, guess it's just me then. 🙂 ...

Is it just me, or are some of the misconceptions in this post regarding default values a little unnerving?

http://www.sqlservercentral.com/Forums/Topic989167-391-1.aspx

Log shipping, lock and latch use, proper syntax for setting a variable...

Phoenix, AZ, born and raised NY, and lived all over the country at one point or another.

And... mmmm... pizza and steaks. Dammit, it's not lunch yet, thanks guys.

The trigger is one way to handle it, but not the best choice. ...

IC, the answer to your question... is your question.

[Microsoft][ODBC SQL Server Driver][SQL Server]The log file for database 'Webdata2' is full. Back up the transaction log for the database to free...

Don't count, sum. Count bases on existance.

NP, Coffee, I rarely get a chance to play with pivot so I figured I'd leverage a little MS Excel training. 🙂

Coffee, the result set I get from that is...