As stated above if you store the database on server 1 on c:\ and then restore on server 2 without the move option then it will restore to the c:\...

The error message in job history would be useful. What is it?

The answer is clearly incorrect. This is an extract from SQL BOL\Transact-SQL Reference\ALTER TABLE

DEFAULT

Is a keyword that specifies the default value for the column. DEFAULT definitions can be used...

Jeff is absolutely correct.

Test of 20000 inserts on a table using uniqueidentifier as the key.

Clustered index = 6min 20secs

Heap + unique index on uniqueidentifier (fill factor 80%) = 3min 38secs

Heap + unique...

Doesn't work on O2K (sigh) but upgrading to O2K3 and I can confirm it works fine.

But I still get the message sometimes when...

No office connect. Saw that link as well, thanks anyway.

The results are variable.

For both 2K and 2K3 for NEW queries they work fine but as soon as you refresh you...

If you're not worried about honouring any locks then use

SELECT * FROM [TBL] WITH(NOLOCK)

WHERE ID = @ID

I had similar problems on Excel 2K when refreshing a query which created a local cube. The initial query worked fine but if you refreshed the data then I got...