Here's a quick example of what I did.

I already had each job as their own SQL agent job. Some were SSIS packages and some were T-SQL execution.

So what I...

I think i'll try a manual start tonight after it finishes tonight. I already know it won't actuallrun...

I'll try that tonight. I did however set a feew stps to log to a file and here's one of the results....

Microsoft (R) SQL Server Execute Package Utility

Version 9.00.4035.00 for...

Make sure whatever account you set the services for SQL and SQL Agent are in the "Administrators" group of the local server. You might be using a domain account that...

From the machine you are connecting from, flush your DNS cache: ipconfig /flushdns

I highly believe its a name resolution issue. In the TCP/IP properties of your NIC, make sure the...

Either way it's executed, SQL will use the credentials passed through from SSMS.

I have tried what the link here: http://blogs.msdn.com/spike/archive/2008/07/23/ole-db-provider-microsoft-jet-oledb-4-0-for-linked-server-null-returned-message-unspecified-error.aspx

suggests but still workd for sysadmins but not regular...

A last ditch effort would be to export all yout spreadsheets to a comma seperated file, or whatever yout choice, as individual text file then import those.

Unless there's a...

In SQL 2005 SP3, if you installed it, it unchecks the "Enable OPENROWSET and OPENDATASOURCE support".

You will need to put a check in the box. Open the "SQL Server Surface...

Jeffrey & GilaMonster, thanks for the info!!!

fizzlme, sorry for hijacking your post bro.:-)

This is an issue on you knowing the DB you maintain. It is sugested that you check the fragmentation of an index at the end of the day and if...

I posed this question to our Microsoft TAM and I am still waitng for a reply.

My days of reverse engineering an install to hack only the parts I want...

Richard, thanks for the vlidation. I know this has always been cunfusing, that's why I raised the question of it.

lol, why the hell does MS leave in there then?......lol...

First, AWE is not an option on x64 hardware because it is not needed. You don't have to check the box to enable it - it is not recognized...

Carve out in SQL to start at 12GB and max out at 14GB. Then set your locked pages policy to the account SQL is running under. Make sure to put...

Solution found.

We cycled the "SQL Server Agent".

Apparently Report Server uses the SQL Agent to trigger your subscriptions.

I personally looked for the in the SQL gaent Job folder and...