Ha! Ha!

The consultant they hired came in and after all day told them what I was telling them. The problem is in the hardware, or configuration of the hardware,...

Craig, the Picard pic is perfect for this one.

Actually, I have refused to go for the director job. We have a new one about every 2 years, that seems...

Heh, there in lies my own defeat. I have been here 12 years, and love it on a normal day to day basis. All of my bosses upto the...

No offense at all. My desktop here is more powerful. I have spent years attempting to break through to those here who choose hardware, that the machine is very under...

Hmm, I was concerned that would be the sort of answer. Where I am noticing it is a data warehouse/report server, so clearly lots of aggregation and reports on...

While I agree with the premise, and the benefits of standardization, I find one bit not considered. Given a template, and ridgid structure, people begin to look at the...

Why, thank you! Always can use some more reading material.

Great article Stefan. A few months ago I was given a project to find all the symbols in our entire system's data. Specifically to find SQL symbols (%,@ etc)....

I needed to ask. This afternoon we finally managed to get everything settled. However, we did notice between the time the SQL people working on this issue left last night,...

So how would SQL respond if a new windows group was created, which included all the windows IDs which were used for permissions in SQL. Then that ID for...

I may have finally found the common thread/problem.

I am using windows auth. I do set up each of our 70 users by user ID. However, years ago the windows...

Would it be plausible that the security/permissions sys data has become corrupted or somehow flawed? On the same server, with the same user IDs in different DBs, everything works....

I have removed and recreated a user ID. I have removed and recreated the ODBC connection on the user device. These both still return the same permission issue.

We have...

I will be attempting Brian's suggestion in a little while. To add to the oddness, another user in the same user group is able to open the same report...

george sibbald (7/20/2010)

---

The error is not 'Select permission denied on object DB..Table'? (two dots) Is the owner of the table specified correctly, i.e is it dbo?

to confirm it is a...