Creating a Full-Text index can take a long time (minutes, hours, days, I've even seen weeks),

Which might explain the "Unusable state" messages (because it isn't done yet).

And it can...

Correction: 4.5 decimal places accuracy.

OK, well I just tested it with a good Lat/Lng calculator and it is accurate in Miles for about 3.5 decimal places.

I have no idea how it accomplishes this magic.

Good catch. But that leaves me wondering how it converts the results from Great Circle Radians to Miles?

Anyone know of a Lat/Lng distance calculator that I can use to...

The LDF is what insures that you can recover after a failure, assuming you are not in SIMPLE mode. The information stored in the LDF is the data that...

Glad I could help...

It is not clear what you are asking here, because you are mixing your tenses.

Are saying...

Both. First, immediately, in the LDF. Then, later, in the MDF (here "later" is a short time: microseconds to seconds). The LDF storage is only "temporary" however...

Well if you mean "populate the table variable" from T-SQL, then the table variable is already non-transactional.

However, if you mean "populate the table variable" from client code, then it becomes...

They're session-local aren't they? Who else could be accessing them?

Please explain in more detail what this means and how you can tell it.

That...

Try using SSMS 2005?

Hmm, I thought that table variables and parameters were not transactional?

In what tool...

A stored procedure is bound to whatever tables/views/etc. that it was originally written for. you cannot apply a view to a stored procedure to get a modified result.

With Views...