Scott, I submitted this question, so I'll try to make it clear.

You can ONLY use double quotes (SELECT TOP 1 * FROM "sysobjects"), when QUOTED_IDENTIFIER is set to ON.

The second...

Too easy!

The more specific answer would cause the question to be less tricky.

Cool question!

A little bit tricky!

Thanks a lot. I know how to code such a script.

> You need to remove the existing data,

> using the Excel automation model

How to do that?

> copying a blank spreadsheet onto the target spreadsheet

This is what I do, but I...

You are on SQL Server 2000 and a large portion of your Employee table stores black and white small images of your employees. You'd like to use the Text in...

I agree with you guys!!!

This is what SQL Server Books Online say:

Enabling and Disabling the text in row Option

You can enable the text in row option for a table by...

Oh, OK, I did not fully understand you.

I'm not sure if this will help you, but take a look at:

http://www.perfectxml.com/downloads/Ch1_SQLSP.pdf

Yes, MS SQL Server does recompile a SP when statistics change. Profiler can tell you if this is the reason of a particular recompilation.

   EventSubClass  Reason for recompilation

   -----------------------------------------------------------------------

  ...

Run Profiler, add EventSubClass column and you should be able to find the reason of recompilation.

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q308737