Not worked with migrating 7 to 2005. But this blog article did help me lot from 2000 to 2005. I think the issue would be more or less...

As Matt said check sp_rename in BOl..

sp_rename [ @objname = ] 'object_name' ,

[ @newname = ] 'new_name'

[ , [ @objtype...

Check this link.

http://support.microsoft.com/default.aspx?scid=kb;EN-US;296711

Also try changing the name of the sheet1$ or just put one sheet instead of 3 and check when you are executing the excel file is closed.

Try this. Its working good for me. Create this proc in you current database.

CREATE PROCEDURE sp_get_script @name sysname

AS

BEGIN

exec master.dbo.xp_get_script @name

END

Shared memory - TSQL LocalMachine

Named Pipes - ...

It would have been a good humor when all the answers had got 5 points.;)

Great job Steve. Overall look is good and new format is more flexible than before but must say that searching scripts was more good in previous version. It...

I am not able to download csv file. Give me invalid page error. Am I only getting this error or everyone.

What account did you select to run your services for new instance? Is this instance installed on a domain machine? If you have selected local system account while installing...

Good informative article. thanks. But one question, how do you send files to ftp server. Can we create a batch file (or may be different approach) to send backup...

Hi,

select objectid, indexid, sum(*) as scans

from IndexCapture

group by objectid, indexid

what is sum(*) here? it should be sum of some column name, right?