Maybe there is an uncommited transaction in the log. IF this is stored near the end of the log file, then shirinking the file will only chop off the bit...

See Knowledge Base Article 329329 - PRB: Windows Server 2003 Support for SQL Server 2000

Apparently SQL2K SP2 and before are not supported on WS2003, and on trying to install SQL2K...

********

-- Capture the output in the table

INSERT #CMDResults

EXECUTE master.dbo.xp_cmdshell 'ECHO %sql_backup_drive%'

*********

This just returned a row in the temp table with the contents '%sql_backup_drive%'

replacing ECHO %sql_backup_drive% with SET sql_backup_drive should...

quote:

---

Nope.

USE PUBS

go

alter table authors add mvgtest as substring(au_lname,1,10)

go

create index mvgIndex on Authors (mvgtest)

go

Server: Msg 1911, Level 16, State 2, Line 1

Column name...

You could try adding a computed column consisting of the first 10 characters of the index field and indexing on the computed column.

According to BOL, this is allowed as long...

quote:

---

I can remember having that with 1 customer but seem to remember also that i just switched the view off of TaskPad...