Does the account used for the MSSQLSERVER service have "Lock Pages In Memory" privileges. Even if the account is an administrator it won't have these by default.

SQL...

If you are going to do searches within an ASP page then my approach would be to :

• create a VIEW for the SELECT and FROM part of your query
• Build up...

Well try changing the WHERE clause to

WHERE Name LIKE 'View[0-9]%'

The firewall admins asked me what I would recommend.

The CEO in my last place was also the owner of the company and he observed that there is a difference in attitude between the US and the UK.

Failure is...

Can we assume that the web server can use THEFORCE?

Have your tried replacing Data Source=THEFORCE with Server=THEFORCE?

SELECT * from dbo.tblInventory

WHERE intInvItemTypeID = ISNULL(NULLIF( @strTypeScopeX,0),fk_intInvItemTypeID )

IF @strTypeScopeX is zero the the NULLIF function returns NULL

The ISNULL statement therefore returns the value of fk_intInvItemTypeID

In effect you...

SELECT @viewname= 'View'+CAST(MAX(dt.value)+1 AS VARCHAR(50))

FROM (

SELECT CAST(SUBSTRING(Name,5,len(Name)) AS Integer) as value

FROM Views

WHERE Name LIKE 'View%'

) as dt

Steve,

If you had stepped up into the CTO chair you would have just burnt out faster. May be you would have made a difference, probably you wouldn't have.

For ages...

I have found that NVARCHAR, NCHAR, and NTEXT are rarely useful even in multi-lingual applications.

The Welsh use CHRW(333) but will tollerate the standard ASCII equivalent.

The Indic languages Urdu, Bengali, Punjabi,...

So if I have a temp table with id IDENTITY, field1....field n

and I write

INSERT mytemptable(field1...fieldn)

SELECT field1....fieldn

FROM dbo.mysourcetable

ORDER BY field2, field4

The IDENTITY values won't be in order of field2 and 4?

Strangely enough you can achieve quite a bit with just SQL Query Analyser and the template functions.

Right-clicking on an option and choosing "Script to new window as..." allows the rapid...

Well the APEX stuff isn't free but it is very good. If you start with a shrink wrapped ApexSQL Doc and a cup of coffee it will pay for...

Do I have to go through the all the CreateObject("ADODB.Command") stuff to execute a query to get the count back or is there a quicker way of doing this?

In the UK estate agents have their own dialect of English.

Agent: A property with a sea view.

English: Its on a crumbling cliff top that recedes at 6ft per...