If you were getting...

And thanks to David also

What I've experienced with traces in 2005 is if you specify a stop time for the trace, the message in the log saying who started the trace is correct, but...

i'll second David. Post the insert statements, and check for triggers.

Profiler should help you capture insert statements sent from the front end.

p.s. Run a DBCC CheckTable onthat table, just the...

Not unless there's some trigger on those tables that audits changes.

You can run profiler against the server to see what commands and procedures are run by the app. DEpending whether...

p.s. I wouldn't bother getting into the habit of naming your transactions. Transaction naming is more for commenting than anything else and...

By bulk operation, I'm resfering to a specific T-SQL command - BULK INSERT. Normal inserts, updates, deletes are not bulk operations, and they log completely to the tran log, as...

For the option I suggested, you need a table (call it RequestedJobs). This is just a very rough example, and may need tweaking/enhancing for your environment.

CREATE TABLE RequestedJobs (

RequestTime DATETIME,

Request...

A few years back I was working as a developer in a custom software house. One week we came up with a prank to play on some of out more...

The 'default' length of varchar depends on where it is used.

In management studio, when creating a table the default length is 50.

If you declare a variable of type varchar...

The problem is in the lines

SELECT TOP 1 @Dobjectkey = object_key FROM DELETED

SELECT TOP 1 @Iobjectkey = object_key FROM INSERTED

There can be multiple lines in the inserted and deleted...

aspersage (10/30/2007)

---

So the question is, are SANs setup that way such that you can get a query response from the READ cache that does not reflect committed WRITE transactions not...

Two options.

1 - Have the trigger insert a row into a RequestedJobs table, and reset the status. Create a SQL Agent job that polls the table at enatever frequency is...

Truncate does write...

p.s. If you don't have space in the DB, you can also BCP the data that you want to keep out to a network drive/removeable drive, then BCP in once...