Thanks for your comments. Any solution besides installing Excel on my SQL server would be great.

In this specific situation, the daily subscriptions that I bring in from multiple...

Thanks Sam!

It is great to have all the options!

This will probably work for some of my data only Excel creations.

And, I can get somewhat the same resusts in MS Reporting...

Any ideas about installing Office Object Libraries with out installing Office 2003?

I had a dream that the Office Interop would just add the Excel .DLL onto my Windows 2003 server...

Excellent Article

For some projects Reporting Services are great.

But, there are some situations where Excel Automation is just a fantastic solution.

And I may have one coming up where I want to...

DECLARE @dbname VARCHAR(20)

SET @dbname = 'MyDBName'

--These indexes should be rebuilt, not reorganized

-- Alter Index ... Rebuild

select *

from sys.dm_db_index_physical_stats (db_id(@dbname),null,null,null,'DETAILED')

where (avg_page_space_used_in_percent < 60

...

Your right!

I was touring around the site and found this out a few minutes ago.

followed the thread: http://www.sqlservercentral.com/Forums/Topic458746-146-1.aspx

I should have realized that.

I do have a few tables...

😀

I have a question about the DBReINDEX.

We have a really nice MS Access DB that uses linked tables to SQL Server 2005. Having just started, I ran a dbcc showcontig...

SQL Server 2005

Trying to add a default value of A to a field with no existing constraint, that allows nulls (the current default).

(this first command does not work...

Back to the QUESTION - would you recommend it to your kids?

Mothers don't let your young boys grow up to be IT!