I have removed everything but now I'm stuck with 2 instance of SQL Server Reporting Services.

When I click on SQL Server 2005 in Add Remove Programs I get an error...

The error occurs when SQL Server Database Services uninstall is in progress.

It appears to crash when setting intenal properties.

"The Local System account option is provided for backward compatibility only. The Local System account has permissions that SQL Server Agent does not require. Avoid running SQL Server Agent as...

I just uninstalled SQL Server 2008 and 2005 from a machine.

I used add/remove programs.

There is a form in which you check the options that you want to uninstall.

awu (10/4/2011)

---

Put service account as local admin group will save lots of permission issue , so. wondering besides security concern, what else is really the big problem...

Looks like you got your answer to the Data Type Issue.

You basically take you Access queries and convert to a SP. I don't know how good of a job id...

Here is a review as the first book that you recommended.

http://www.amazon.com/Professional-Microsoft-Reporting-Services-Programmer/dp/0470242019/ref=sr_1_1?ie=UTF8&qid=1316303580&sr=8-1

Check out the reviews on Amazon and then go to the book stores and take your time comparing them.

http://www.amazon.com/Microsoft-Server-2008-Reporting-Services/dp/0071548084/ref=cm_cr_pr_product_top

So what was the problem?

If you had provided information requested this would have been resolved a week ago. 😀

I can't think of any reason why you would need more that the second one.

Edit: I meant that I thought that the second index was the correct one and that...

If you deleted a lot of Data then you will have some free space.

How much data are you deleting relative to the size of the database?

You may be able to...

Sorry, double post.

All you need to do is load the Product Table before the Company Table since the Product Table is a Child to the Company Table (FK Relationship).

Rob Goodman (9/15/2011)

---

Mahadevan,

However, now when I run the code, I am getting the following error:

[Execute SQL Task] Error: Executing the query "Exec spDropAllIndexes Dates" failed with the following error: "An...

http://msdn.microsoft.com/en-us/library/ms189625.aspx

http://msdn.microsoft.com/en-us/library/ms143699.aspx

http://technet.microsoft.com/en-us/library/ms143699.aspx