Maybe I misunderstand what you are looking for, but is it as simple as changing "> 0" to "= 0"?

You drop a linked server with sp_droplinkedserver. Obviously, if you have queries that refer to the server, these queries will stop working.

To find instances of these servers in stored procedures,...

Any chance that you could write a small console-mode program that reads data from a tab-delimted file and then sends the data to SQL Server with SqlBulkCopy in your program?

Yes,...

Judging from the error message, you are not using SQL Server. Which product do you use?

The thread is confusing. Are you looking for disk space or RAM?

xp_fixeddrives indeed gives you the available amount of free disk space (not the total space).

If you want to know...

I played with this and I was able to reproduce the behaviour. And in my test, the answer is clearly: populating the non-clustered indexes.

I had this script:

CREATE TABLE "Orders" (

...

See here for tips on how writing OPENQUERY with dynamic SQL and still stay sane: http://www.sommarskog.se/dynamic_sql.html#OPENQUERY

All tables should have an index of the simple reason that all tables should have a primary key. (With one possible exception: tables that should only have a single row,...

So your query windows runs either an INSERT command or a DELETE command? Else my answer would be that it's running the DELETE command once the INSERT is done.

But if...

Do you want to add a nullable column or a non-nullable column with a default value? And where you do want to add it? As the last column?

What does "SELECT...

Didn't you say that you had also tried BCP? I'd rather work with BCP than writing a .Net program. So if you have the BCP command (and any format file...

It would be interesting to try to repro this. Can you share the table and index definition? I would have use for the data file as well, but I understand...

There is a Service Pack2 out for SQL 2008 R2 out. I don't know whether that will resolve the issue, but you should be on the latest service pack anyway.

Disabling...

I echo Gail. From my experience of answering questions in forums, my gut feeling is that there is something you are not telling us. With access to the environment we...

OK. I suspect that this not the best site to ask this question. After all, it does not matter whether you have SQL Server, Oracle or something else running on...