By any chance is there a "working" SQL statement before the @@ERROR is checked -

@@ERROR resets with every SQL statement...

so if there was an error in an SQL statement...

Hi,

I think you will have to specify in ADO that NULL be inserted when an empty/blank value is passed...if a blank value is sent across then SQL Server inserts a...

I think you can achieve the same functionality using @@ERROR and GOTO...

assuming your trigger consists of an UPDATE statment and you want to GOTO in case of an error :

<UPDATE...

your select statement re-written as follows should work :

select 'val = ' + categoryname + ' desc = ' + Convert(Varchar(100),description) from categories where categoryid=1

Since description is of type ntext...

>>I've done it via QA without problems!

??????....is there any option in QA to turn off warning messages...I always get that warning whenever any table created goes above 8060 bytes...

and regarding...

Hi Frank,

The table will be created without any problem...

if created using QA then a message saying "The total row size (14061) for table 'KeyResultAreas' exceeds the maximum number of bytes...

We faced a similar issue where we designed a table that exceeded 8060 bytes...

our design was something like this :

CREATE TABLE [KeyResultAreas] (

[UserID] [int] NOT NULL ,

[AppraisalID] [varchar] (15) NOT...

w.r.to the text data types in stored procedures - when you use a varchar(8000) local variable and if the length of the text data type exceeds this limit then the...

I think that kfenstad is looking to list out in a single record the 'large' and 'small' file names associated with a single product_id....

Does the following query resemble what is...

I think you can query sysobjects on the name of the index to get the creation date...something like :

select [name],crdate from sysobjects where name = 'IndexName'

The link below lists out...

If sp_who returns too much data then you could store the results into a temp table and query that temp table to see if anyone is accessing/locking model....there was a...

Hi,

This KB article refers to the same error(w.r.to Exchange 2000)

http://support.microsoft.com/default.aspx?scid=KB;en-us;293422&amp;

another KB article that might be useful is

http://support.microsoft.com/default.aspx?scid=KB;en-us;263556&amp;

about the "xp_sendmail : Procedure expects paramater @User" -...

Hi,

We had a similar performance problem and ended up adding an identity column to the table so that we could get the "N" number of rows directly from the base...

For text,ntext or image columns you will have to use UPDATETEXT...

the following article explains how to use UPDATETEXT

http://www.sqlservercentral.com/columnists/rmarda/handlingthetextdatatype.asp

very true... I missed the obvious out here...