fairyuseless (10/8/2010)

---

Hi you guys, i got a db containing two log file: log1 and log2, log1 is 50G with 20G free and log2 is 10G with 5G free, now i...

Greg,

Thanks so much for the reply. I agree whole heartedly that SSAS is quite different from my relational world. I am definitely outside of my comfort zone here.

As...

Understood, but I know who has access, I need to know how to ensure my trace captures it when it happens.

I traced Analysis Services for the removal of the an SSAS database. Apparently though I was not filtering properly as it happenned and I missed it.

Fair question.

I have a column filter on TextData for %delete%

When I traced myself deleting the SSAS database, I got

<Delete xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">

...

getoffmyfoot - can you explain/elaborate on your statement....

"SQL Server does not strictly abide to that maximum memory setting and can actually consume more than that"

Thanks!

I did come across http://social.msdn.microsoft.com/forums/en-US/sqlsecurity/thread/b9c76930-8f6d-4950-a6bc-22b638e4e16f/ but as Rob mentions, the solution is less than elegant. This is a test/dev box so it would not be a HUGE...

Anyone have any thoughts?

Well then maybe there is a question within a question here.

There are 4 developer accounts contained in the aforementioned group. All 4 need to be able to...

Right, but I am assuming for an SSIS package to run, the Integration Services service needs to be running. How can the job complete if that service is not...

Well, I work under the assumption that any IIS box, or box in general, in the DMZ is compromised. Based on that logic, there is an easily accessible path...

I am all for having missed somethign obvious....... but i do not know what it is.

I am logging perfmon data to a table.

When do

select cast(CounterDateTime AS DATETIME) from dbo.counterdata where...

I am pretty sure that the later article and any discussion of x86 versus x64 ODBC/DSN is onlyrelevant if you are trying to setup a DSN ON the server. ...

Just to clarify.

1. The vendor has simply stated that their DB is not "64-bit compliant".

2. The client machines are 32bit so the only option is the x86 odbc....

Maybe I am just getting confused. But yes, an x64 OS installs both the x86 and x64 drivers so clients can connect via either. My point is, there...