Or if your data set is small and you are using ADO you could sort in the recordset itself using the SORT method which might be a bit easier to...

Do a search for Coral Castle in Florida. The information is amazing and apparently the site is more so. Haven't been yet but hope to soon.

And assembly language is enough to make you feel that way. But I recall those when I was in High School studying languages...

I didn't get that far into testing. I did notices this however when I ran your example.

I got

#a__________________________________________________________________________________________________________________00000000002B

#a__________________________________________________________________________________________________________________00010000002B

The second set of values changed on the hex section (remember HEX is...

It is based on connection not the specific SPID as attached or the user id. I am sure there is a mechanism somewhere in memory handling mapping to a SPID...

How are you confirming that it changed from 197 to 143 as far as character. Many times it is just choice of font that gives the impression. Look at in...

If you observe daylight savings time then that is basically the same action the system takes on behalf of itself. I have not seen any issues specifically like this unless...

From BOL

Trigger Execution

All bulk copy operations (the BULK INSERT statement, bcp utility, and the bulk copy API) support a bulk copy hint, FIRE_TRIGGERS. If FIRE_TRIGGERS is...

bcp [TESTDB].[DBO].{mbt_image_1MB} {in} [c:\new_auth.dat] [-fc:\authors.fmt] [-Spund2k215[\sql2ka]] [-Usa] [-Ppund2k215]

Are you trying to do this in Query Anaylzer or Command Prompt, should be done using a command prompt window. And should read...

From the file you cannot restore without the transaction log or expecting the same size as when backed up. What you may need to do is restore to another server...

But keep in mind Rowcount may not return the same records as top does. So it depends on a few factors but make sure you test that you get the...

Understandable. However if it is already there, is small and the application is on par why waste time andmoney researching further? As said, if it isn't broker then don't fix...

Right off the things that stand out to me in their propaganda flyer are the prices at the bottom.

Apparently they used the old pricing models and they never state which...

Even better than Profiler itself look at sp_trace_create and related subjects in BOL to create the same files a sprofiler like you want.

Any looping condition where a row is looked at is row-based. A while loop, cursor or any other method where you step thru the rows for processing.