Are you sharing and accessing folders that have SQL Server data files?

You can buy it on the Microsoft Store. Here is the link anyways.

http://store.microsoft.com/microsoft/SQL-Server-2008-Developer-Edition/product/C5EA00C9?WT.mc_id=productinfocenter/?WT.mc_id=sqlserversite_enterpriselink

Dont quite understand what you are asking.

Do you have two desktops with Visual Studio one one and SQL Server 2008 express on the other. Where is the share and how...

The login has to be a sysadmin otherwise, can execute only jobs created by that login.

In SQL Server 2000, Execute permissions default to the public role in the msdb database....

May be unrelated. I have come across this error a few times on discussion groups before specifically related with cube browsing. Here is one article. Are you suppressing empty cells?...

Can you provide more details on the error message?

Thanks

Hello GP,

Appreciate your responses. Where do I right click on this page? It is blank page with just the Report header that has 3 links to the right. The links...

I did follow the steps in the document. But on the ReportManager Home page, I dont have a link for Properties. So not sure, how I can set the necessary...

My 2 cents. Can you not use SSIS to import the 47 spreadsheets? SSIS may be a cleaner and more efficient way to import this data in SQL Server.

If modifying the schema is not an option, can you create a cope of this table or may be even replicate the table. If that is possible, then you can...

If there is only one excel file with 3 tabs in it. Then yes you will only need one connection to Excel.

You are correct on the 2nd. You will need...

Hi there,

Are the 3 excel files have the similar data? If not then you will need 3 separate connections. If they have similar data and same set of columns, then...

Check this article. See if this helps.

http://www.sqlservercentral.com/scripts/T-SQL/66830/

What version of SQL Server are running?

You are welcome. I am glad I could help out.