The function uses the DBCC command, if I'm not mistaken.

You'd need to build a CLR assembly for that.

There's an undocumented DBCC command that can read the log file. The data it provides may or may not do what you need.

It's "DBCC Log()". The parameters that...

jcrawf02 (2/26/2010)

---

I'll make up for Paul's inadvertant technical stuff 😉

Steve, saw you were re-learning Pythagorean theorem, can't help but poison your mind with a joke:

An Indian chief had three wives...

I'm not entirely clear on what you mean.

Do you mean you want to restrict the location of the files (mdf and ldf and ndf)? Or the server(s) they can...

Is it possible the process you killed is still rolling back? That's what it sounds like to me.

I just performed this test:

SET NOCOUNT ON;

CREATE TABLE #T (

ID INT IDENTITY PRIMARY KEY,

Section INT NOT NULL,

DT DATE);

INSERT INTO #T (Section, DT)

SELECT N1.Number, DATEADD(day, CHECKSUM(NEWID())%36525, '1/1/2000')

FROM Common.dbo.Numbers N1

CROSS JOIN Common.dbo.Numbers...

There are a number of ways to achieve that, but the simplest is to join the two tables together in your query. Are you familiar with how to do...

This kind of design can be done efficiently if you have the front end generate a GUID, instead of using a database-generated integer ID. The GUID can then be...

It's not a question of which...

In that case, with file formats changing every few years, I'd be inclined towards setting up XML definition files and using OpenRowset Bulk to import the data.

I've used that method...

That'll make a difference! 🙂

The table(s) you aren't updating have more rows than the table you are updating. That's what causes that.

Try this, you'll see what I'm talking about:

CREATE TABLE #T1 (

ID INT...

On another note, you shouldn't be subtracting 3 milliseconds from a date to define the end of a datetime range. The right way to do it is to use:

date>=@StartDate...

The reason the version you were using before worked is because SQL was doing a string-to-datetime conversion implicitly behind the scenes. It can't do that if the string can't...