7hertz

iis admin won't enumerate web sites

· · (2) · ·

on opening the MMC containing the IIS snap-in, a dialog box appears with the following error message / you are unable to enumerate web sites because the following error occurred :

Object already exists

here was my fix/workaround...

maximum page size in sql server

· · (0) · ·

What is the Maximum Page Size in SQL Server 2000?

tree hierarchies in sql server

· · (0) · ·

different ways to handle a tree hierarchies in sql server...

ms access left outer join

· · (0) · ·

i'm not a big fan, but sometimes ms access makes for a decent tool. however, syntax for various sql operations are different. access can still perform a left outer join, here's how...

case insensitive searches

· · (1) · ·

A default SQL Server installation is case insensitive, which means that SQL Server will not differentiate between upper and lower case characters/letters.

Here are some ways to perform case sensitive searches using different methods.

computed columns and indexes

· · (0) · ·

computed columns have some benefits, along with some restrictions (like being deterministic). what's interesting is that SQL doesn't necessarily store the computed column data...

datetime cast

· · (0) · ·

more ways to get/deal with datetime values...

set v. select

· · (2) · ·

What is the difference between SET and SELECT when assigning values to variables, in T-SQL?

sub queries and result sets

· · (0) · ·

while writing a query that seemed straight forward to me, i got the error : "Cannot perform an aggregate function on an expression containing an aggregate or a subquery."

the issue perhaps wasn't the logic of what i was trying to accomplish, but just the order and placement of operations.

the solution? you can always collect your data into a temp table and then work with that. but you don't have to...

read more...
 

stored procedure parameters

· · (0) · ·

i actualy forgot you can do this (got used to stuffing paramters in order!)...

you can explicitly name your parameters inline (in the TSQL exec string).

date strings

· · (0) · ·

i've explored a few more date to string format conversions. nothing really new here, but here are some observations.

access is denied on .NET assembly

· · (0) · ·

SYMPTOMS

Server Error in '/MyWebApp' Application

Configuration Error
Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.

Parser Error Message: Access is denied: 'mydll'.

Source Error:

Line 169: <add assembly=<System.Drawing, Version=1.0.3300.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a>/>
Line 170: <add assembly=<System.EnterpriseServices, Version=1.0.3300.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a>/>
Line 171: <add assembly=<*>/>
Line 172: </assemblies>
Line 173:

Source File: c:\winnt\microsoft.net\framework\v1.0.3705\Config\machine.config Line: 171
Version Information: Microsoft .NET Framework Version:1.0.3705.0; ASP.NET Version:1.0.3705.0