Also from that MSKB article:

"Non-clustered indexes cannot be created on table variables, other than the system indexes that are created for a PRIMARY or UNIQUE constraint. That can influence the...

I think the query will return all the rows if the destination is empty and no rows if the destination has one or more rows.

I believe that

Select * from...

Hello

Was the db detached (or properly split mirrored) when the backup was taken?  This is probably the only way to get a usable backup of the actual log "device" file.

Are...

So, you want to stop/start SQL from a remote machine.  Have a look at the following:

http://www.sysinternals.com/Utilities/PsExec.html

The utility will allow you to run programs on remote computers without installing any remote software. ...

The log file will always grow exponentially if the growth is set to be by percentage.  To avoid exponential log growth, you would need to change the file growth to...

Jyrki,

I've had that problem before when modifying packages with text output data connections.  Suddenly, the entire EM in which my DTS designer window was running just vanished.  *poof*

I think you might need...

Crap. We forgot to answer the question.

I'm not sure I can point you to anything definite.  You might look at systems that store X12 EDI documents in databases.  The X12...

To expand on RGR'us' thoughts, XML is even worse than the 1950's model, because the extra padding makes it take forever to punch out to paper tape.

/rimshot

for %I in (te*.txt) do type %I >> newfile.txt

wha-bam.

jg

If the SP doesn't use all of the results of the table, it may very well take longer to create the entire table.  The view itself does not give sufficient...

The query you have will need to scan the Clutered Index because of the scalar conversion in the second join term.  It has to consider every possible row for each...

I'm not sure if this will work, but you might be able to edit the data in a backup file and restore it.  You could modify a table to contain...

Is there anything that leads you to believe that these are errors? 

I think that they are evidence that snapshots are being started and completed.

I didn't RTFP correctly.  Excel won't work in your case because you have too many rows.

You might be able to use the data in QA.  Do a select all in the results pane (grid) and then copy, paste the data into either excel or notepad. ...