This topic brings to me an incident I saw at a state agency I used to work at, so please indulge me as a relate this war story. This is...

I don't know, Steve. I have trouble with the concept of Big Brother, be it government or large corporate entities, knowing a great deal about me. Yes, it's a reality;...

I just found out that because I'm using a bulk copy, which apparently requires ALTER TABLE permissions, I also had to include the db_ddladmin role. Who knew (I certainly didn't,...

OK, I've discovered that my problem , with the sp_AddRoleMember stored procedure, was using both [] and ''. What I've done is this:

EXEC sp_addrolemember N'db_datareader', N'DomainUsersAccess'

GO

EXEC sp_addrolemember N'db_datawriter', N'DomainUsersAccess'

GO

OK, without a doubt I have determined that the lines causing me problems are:

EXEC sp_addrolemember N'db_datareader', N'[DomainUsersAccess]'

EXEC sp_addrolemember N'db_datawriter', N'[DomainUsersAccess]'

Those 2 lines generate the error messages:

Msg 15410, Level 11, State...

Some more info. I ran the SQL script attached to SQL Express using my Windows account. My account has the SysAdmin role assigned to it, so I would think it...

Hi Lowell,

Well, as it turns out other priorities demanded my time, so I'm only now getting back to this. Here's the SQL Script that I came up with, based upon...

I work in a small shop (just 2 of us), and so having direct access to tables & views is SOP. Sorry.

I agree with you, JJ, that education people should have an exposure to programming, but not necessarily a high level of proficiency at it. It's somewhat analogous to elective courses...

I agree with this article. It seems obvious to me (I am a developer first, DBA second), but the linked to article pointed out things I didn't think of. For...

OK, I've added our Domain Users group to the logins for SQL 2008 R2 Express on my PC. It's server role is public. Domain User's default database is the database...

Hi Lowell,

Thank you for your reply. So are you suggesting I go with option 2, use a SQL user instead of integrated security?

I thought that performing a refresh would cause the dataset to update, so that's what I tried. It seemed to include the GenderDesc column, but it left the old Gender...

I've performed the left join to the Gender table in the stored procedure. It works fine. But for some reason the SSRS report refuses to see the change in the...

Yes, geoff5, I agree with you. Since we're currently at SQL 2005, I'm going to have to change the stored procedure.

Well, I've done that, but for some reason the RDLC...