As a side point, isn't compression limited to Enterprise Edition..

CEWII

Why do you need to do this? The database would not have grown to this size unless SQL needed it to..

CEWII

Without either audit triggers or traces in real time, modifications are going to be hard to audit. That data is not kept by the system without some setup. If...

There is a definition used by the Department of Defense (DoD), that are defined in Security Technical Implementation Guides (STIG).

http://iase.disa.mil/stigs/app_security/database/sql.html

http://iase.disa.mil/stigs/faqs.html#10

They are looked at as categories:

Category 1 - These MUST be...

If you had 10 other jobs that run often they could generate up to 100 history records each they can easily displace the history records for jobs that run less...

I agree that is EXTREMELY open-ended. I would start with finding out which logins/AD groups have high privileges at the server and database levels. I would also review...

I'd guess that the history settings are default, which is 1000 TOTAL rows of history and up to 100 rows per job. With those settings its REALLY easy to...

Unless you are planning on using some of the more advanced features or an obscene amount of processors and memory I don't think I would recommend Enterprise Edition. For me...

You are very welcome Phil, once you start dealing with the really custom sources or destinations it can get tricky really fast.

CEWII

Phil,

I don't think you can prevent it once its been started. I think you have to do all the work to make sure that the values will be good...

Well I had typed a response and it got lost...

So a quick retype..

The query you are doing seems to be in the spirit of:

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

I think the error message:

The OLE DB...

I looked at the output and immediately latched onto the first 2 characters, PK, are you sure this is an XLS file and not a ZIP file maybe containing an...

erikd (7/10/2013)

---

Elliott Whitlow (7/10/2013)

---

erikd (7/10/2013)

---

I've given the clients\SQLService user explicit rights to the folder. from Full Control on down. Nothing is denied. I immediately ran the query, and got the...

erikd (7/10/2013)

---

I've given the clients\SQLService user explicit rights to the folder. from Full Control on down. Nothing is denied. I immediately ran the query, and got the same error as...

erikd (7/10/2013)

---

Elliott Whitlow (7/10/2013)

---

I don't really consider those special myself.. Are there other files there that CAN be read by SQL? I'm trying to get a view on...