It might be able to 'see it' as a configuration option but I don't think it can actually allocate it.

I  use Enterprise on a 4GB box with the /3GB switch...

Hi, Troubleshooting performance problems are always difficult - even when you are in front of the server. Can you give us some more background? In particular:

Has this only just started?...

I would go down the route of updating all columns. I don't think the overhead will be that great (unless it's a very wide table with only a few columns...

Hi all - thanks for the help.

I eventually bit the bullet and went down the DTS route.

Vasc - Thank for the info on changes to the driver - it looks...

An alternative method is to maintain a logically deleted flag on the record and use an INSTEAD OF trigger to flag the record as deleted. You can then use this...

Im not sure exactly what you are wanting to do - for sending mail I usually use xp_sendmail or the E-mail task in DTS.

In DTS you can set up mutiple source and destination pairs.

You coluld just do a count(*) and return that or eat the output of the select into a #temptable (or table variable) then drop it. Not sure why yuo would...

You could put a RETURN before your ErrorHandler: Alternately always assign @@ERROR to a local variable - for Example @ReturnValue.

Then in ErrorHandler you can test @ReturnValue

.

I came up with this ... but I'm sure there is a better way. It's not recursive so only 'nests' to one level.

Might get some more interest!

CREATE...

Try APP_NAME() it should return the application name _if_ the application has set it.

Can you select from the table - if a select times out it is likely there is a lock or openn transaction on there table.

Something like this

DECLARE @i INT

SET @i = 1

WHILE @i < 20

BEGIN

 SELECT @i,

  CASE @i % 2

   WHEN 0 THEN 'Even'

   ELSE 'Odd'

  END AS OddOrEven

 SET @i = @i+1

END

Q1 only. I'm guessing it's because [ is part of the patern definition in the LIKE predicate so

select * from #unprintable where CharOld not like '[[]'

does not find...

The one from Sergiy does not work (sorry) but I understand why. I'ts actually where I started. The one from rsharma does work - now I just need to understand...