Search results for query: *

We are currently testing using the IS_MEMBER function in conjunction with some active directory domain local security groups to help filter data that users can see. The issue is with the IS_MEMBER function. It doesn't seem to refresh who is and is not in a group in any deterministic time...

I have a table with multiple comments that I want to merge into one comment per owner WITHOUT using a CURSOR. Here is my sample table: create table #test (Owner char(1), Seq int, comment varchar(25)) insert #test values ('A',1,'This is') insert #test values ('A',2,'a') insert #test values...

Does anyone know how to tell if a trigger has been disabled? I found that "STATUS" within sysobjects does change value, but no real pattern that I can tell. I checked all the stored procedures, but found nothing. I looked in BOL and on Microsoft Web site, but found nothing. I have...

Can't we all just get along? LOL. As an IT specialist (DBA, programmer, developer, analyst, project manager, etc), I can appreciate the problems we all encounter. The people who answer your questions within these forums do it because they enjoy knowing that they have helped fellow IT...

I posted this on the IIS FORUM, but got no answer. Any help would be greatly appreciated: I have a web application that currently uses standard security for all users. We would like to transition the security to "sorta" trusted security. What I mean by sorta is that all I want to...

I have a web application that currently uses standard security for all users. We would like to transition the security to "sorta" trusted security. What I mean by sorta is that all I want to have happen is that the user is validated to be in an Active Directory Group. The internal...

I have simplified this statement to use dynamic sql. I know in this case I do not have to use dynamic sql, but I need to find a way to implement security with dynamic sql within a stored procedure. Here it is: create table test (idno integer identity(1,1), tdata varchar(25)) CREATE proc...