use profiler to find out what's going on !

- sometimes the apps get a timeout because the allocation of the new space takes longer than the espected time.The allocation however is executed (unless the disk is full).

- is...

What version of SQL7.0 are you running ?

MDAC-upgrades should _always_ be tested on seperate servers that are at the level of your production server.

Any chance this is related to Q310822 ?

Check out smtp-mail at http://www.sqldev.net

I only have the alert responding when launched from within a certain database.

the first time, you'll have to stop/start SQLAgent.

Pitfall: When you disable the job which should be launched, you...

I've build a workaround to achieve this by having the users raising an alert. SqlAgent then reacts to that alert by launching a job (one per alert) that runs the...

before you fail back check its portno.

with this script. Don't know where i've downloaded it from(author is mentioned), but it does the job.

then fail back and run it again. It...

I didn't encounter it in sql2k because I create a clustering index by default, and until now I didn't get any complaints from the app-resp. (Or they can live with...

How up to date must your data be. Do you have control on that ?

If yes, you could have a simple normalized table structure and a "relation" table. after...

I've had the same issue with a heap as Andy Warren. This was on a SQL7 sp2. Now I only REMOVE a clustered index if it's been proven it hurts...

maybe this link helps ..

http://dbforums.com/t746009.html

did you check that the account that runs the cluster has access to your sqlserver. (login should do)

"declare @sql nvarchar(2000)

SET @sql=N'Select *

From vHaulageJobsUnfinished U

WHERE EXISTS (

SELECT *

FROM HaulageItems I

JOIN Jobs J ON I.JobPrefix=J.Prefix AND I.JobID=J.ID

WHERE J.JobRef LIKE ''' + @ShippingJobRef + ''' AND U.Prefix=I.HJPrefix AND U.ID=I.HJID

)'...

"... but replace all the 'IS NOT NULL' statements with '!=NULL' and ..."

You'll have simular differences when you use the JET-syntax for outer joins on sqlserver.

'*=' does not work...

You'll always (never say never ) have to interpret business "demands" to "needs".

You can do the same thing in # ways. Some are already constructed for...