Jeff-

Sorry for the delay in responding.

I have restructured the maintenance plans to create individual files for each back up and only keep a 24 hour "set" of the files on...

True, there is a window of time between the first full backup @ 4a and the first trans log backup @ 7:15a but there are not many users (if any)...

Jeff-

Same file for Transaction Log backup.

Init on the first run and append there after.

Robb

Suggestions on utilities or methods of copying .bak files to other locations?

This usually happens around the same time of day when it does happen.

The initial transaction log backup is at 7:15 am and they follow every hour, at the top of...

I removed the .Parent from the expression and it works now.

I am assuming that adding the [Measures].[Time Hours] gives the expression the "source" it needs for the given context, i.e....

I updated the KPI with the following expression-

([Task Data].[Task Category].&[Client Related Time], [Measures].[Time Hours]) / ([Task Data].[Task Category].Parent, [Measures].[Time Hours])

Now I am getting a 1.#INF which tells me it is...

Jason-

No change. Still getting the infinite recursion error.

Robb

ChrisM-

Bingo! That works.

Much cleaner.

Thanks.

Robb

ChrisM-

The same table as the view references contains the field that will determine the what the user can see.

Example:

SELECT t.*

FROM TABLE t

WHERE t.deletedate IS NULL

AND ((IS_MEMBER('role') = 0

...

ChrisM-

The original purpose of this view was to exclude records stamped as delete - deletedate IS NULL.

So these records need to be exlcuded no matter which role the user is...

Thanks for the replies.

I am not sure I gave enough info or was misleading in my example.

My solution at this point is this:

SELECT *

FROM table

WHERE deletedate IS NULL

AND IS_Member('role') =...

Greg-

The website is assigned to the DefaultAppPool which does run under Network Service. Ding!

I have never messed with this in the past or changed it.

So why does SQL Server...

Greg-

I think I am still missing something here.

Technically, nothing really broke as in dead in the water. The web application still functioned for the users. They just experienced...

Greg-

The site uses Integrated Windows Authentication and the database uses Windows Authentication.

Robb