I've lost count of the number of times I've sat through a recording of a TV show, adverts and all and then had either one of two thoughts

a) Hang on...

Guys, in the UK it has been illegal to tape records (remember those) and CDs for as long as I can remember. It is an entirely toothless law because...

Off the top of my head (I don't have SQL at home) I'm not sure if TEXT and NTEXT are allowed as output parameters but the general format is

CREATE PROC...

Assuming that ISQL on Sybase is the equivalent of OSQL in SQL Server then the easiest way of using a batch file to create tables is to create a text...

Or even

SELECT name FROM syscolumns WHERE id=object_id('dbo.TBL1')

Wrap up your code in a Try, Catch block

I need a lot more information to give anything other than general advice.

Is your data access via stored procedures?

Are there indexes where they should be on the fields?

What is the...

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