Search results for query: *

In a custom application we have, it impersonates a user to access network shares. For some reason on one server, this impersonated user no longer appears to have Full access anymore. Is there a tool that can compare either entire server setups or just local policies? Thanks.

The first statement evaluates toIf RegionID = NULL THEN display all records ELSE filter by Regionthe second statement evaluates toIf RegionID = NULL OR a value THEN filter by NULL or value

VS 2005 SP1 I want to haveWHERE (@RegionID IS NULL OR Region = @RegionID)but instead the wizard always changes it toWHERE (@RegionID IS NULL) OR (Region = @RegionID) which is not the same thing. Does anyone have any ideas how to stop the wizard from being too smart?

I guess not.

Won't SUBSTRING('',1,4) return an error being it's length is zero??

You're right. I tried nowSELECT ProjectNumber, ClientName, ProjectDesc, SubjobDesc, Region, CASE WHEN LEN(ProjectManager) >0 THEN CASE ISNUMERIC(SUBSTRING(ProjectManager, 1, 4)) =1 THEN SUBSTRING(ProjectManager, 8, LEN(ProjectManager) - 7) ELSE ProjectManager END ELSE...

You answered for me that it is possible to nest case statements. I couldn't find a definite answer. You code led me to this which worked:SELECT ProjectNumber, ClientName, ProjectDesc, SubjobDesc, Region, CASE LEN(ProjectManager) WHEN 0 THEN CASE ISNUMERIC(SUBSTRING(ProjectManager, 1...

SQL Server 2000 I'm not sure if it's possible to have a nested case statement or if I should use a subquery instead. I have inconsistent data to deal with. Here's my logic statement:If LEN(ProjNumber) > 0 THEN IF ISNUMBER(SUBSTRING(ProjNumber,1,4) -1 THEN SUBSTRING(ProjNumber,8...

SQL Server 2000 and .Net 2.0 Is there a difference betweenWHERE (@RegionID IS NULL OR Region = @RegionID)andWHERE (@RegionID IS NULL) OR (Region = @RegionID) The first gives me the results I want. The Query Builder in VB 2005 tries to be too smart and changes the first one to the second one...

Sorry for the confusion. The Query Builder shows a different version of the SQL statement than in the TableAdapter Query Configuration. Yes your code works. The Wizard was working against me. Thanks for all your help!!!

I get what you are saying but I want the opposite of NULL, therefore all records. So: If the parameter is not passed, all records are displayed. I guess I should have said that in the first place. Sorry

I'm thinking I need to better explain. This is what I'm trying to achieve logically.SELECT CREATION_DATE, ClientName, Manager, PrjNumber, ProjectName, Region, SubJobName FROM vPE_NewJNRPrjs IF @RegionID IS not NULL THEN WHERE Region = @RegionID

SQL Server 2000 It's probably easier to explain my logic as I could be far off base in my coding attempt. I want to have a query statement that when is a parameter is not null then the Where statement comes into effect. IF Paramater is not null THEN Parameter = @Fieldname ELSE do use...

Oops. I was using the CellContentClick method instead of CellClick.

It appears to be with this particular project. I created a new form it does the same thing. However in a test project it works properly.

VB 2005 & .Net 2 The icons in my treeview object display when that particular form is set as the project startup form. But this form is actually called from the main form. When I do this, there is a space displayed where the icons should be displayed but are not. I Refresh the treeview after...

VB 2005 and .Net 2 Instead of adding a COM reference through the Add Reference menu option in the VB IDE, can it be done in code?

It seems changing AND to + did the trickruleF = New FileSystemAccessRule(Account, Rights, InheritanceFlags.ObjectInherit + InheritanceFlags.ContainerInherit, PropagationFlags.None, AccessControlType.Allow)

VB 2005 & .Net 2 I'm trying to add a user group with Full Control applied to "This folder, subfolders, and file" but it seems to keep getting varied results. The Full Control permission consistently works but it's always applied to "This folder only". Any ideas? Private Sub...

That would be nice, except the search function is currently out of order.