Are you sure that's for this thread? I don't understand how what you posted relates to my issue. ?

Solved with a tip from forms on sql-server-performance.com

It's a subtle thing:

I have one table to which this insert was adding rows; this table is nothing special -- no indexed views...

Thanks for that suggestion -- I also found that posting and tried that, but to no avail.

I saw another suggestion indicating that it could be a connection settings issue (two...

That's the strange part -- this doesn't happen anywhere else, only in this one specific proc and only inserting into this one specific table. We have other inserts in other...

http://www.databasejournal.com/features/mssql/article.php/3483931 might help you.

But, as you point out, encrypting the data inside the DB is probably a bad idea. Better to keep bad people out, but leave the...

Some good news on this issue - file it under "proof in the puddin'?" 🙂

We have built a test server and installed 2005 standard ed. The test server has...

mannadba - you are correct, we have a 32 bit system, and I am concerned about the 4gb ceiling, which the 64 bit OS does not have. Thanks for replying,...

Also, look at OPENROWSET, which can directly access an Excel worksheet with SQL statements, as if it were a table. No need for the step exporting to XML, no need...

Worthy of note: you need to keep Excel from messing with numbers and dates and such:

For example, a number with a leading 0, like the US postal code 01033, will...

Bob - don't think a cursor is needed; I would look at using Update ... From to accomplish this.

Not a good idea, if you have the drive space, to constantly grow and shrink the database, as it leads to pretty evil os-level file fragmentation. Best practice is to...

rgr'us concerns are also valid -- take a look at your overall design, too, and be sure that this idea will really work. What are the odds, for example, that...

Well, right direction I think. kinda 🙂

First things first. You probably really want to

select address

from persons

where last_nm = @last_nm

and first_nm = @first_nm

And then you want to actually return...

jp - you'll have to do the inserts one at a time, using the technique given above. If you need a single stored proc to insert multiple entries, then you...

And how much money you have in the bank 🙂

Check out

http://www.microsoft.com/technet/prodtechnol/sql/2000/reskit/part2/c0361.mspx