great article. For free source control try Subversion, you can get it at

http://subversion.tigris.org/

log is purged at transaction log backup

Ed, my guess is we wont find out...

Florian Reischl (3/22/2009)

---

To Gail, Perry (and some other people)

Thanks for your corrections in this thread and others. I'm not from England/America and sometimes I'm tryin' to read faster than my...

yeah i know slightly supsect and worrying.

the OS reqs are at the following link

http://msdn.microsoft.com/en-us/library/ms143506(SQL.90).aspx

you can install either Standard, workgroup, express or developer only on XP Pro SP2

and developer or express on XP Home

is your OS XP...

ok, try from another angle! Did you accept all the defaults during installation or did you change any sections of the installer (such as the part where it indicates create...

did you create a default or named instance?

change your windows file association for .SQL scripts to something other than SSMS

cloud (3/20/2009)

---

The database is used for BI purposes and updated once a day therefore is set to simple recovery mode.

The machine doesn't have a lot of space...

😉

is that just the data file or does that include log as well?

is it absolutely critical to release the space, why not just leave it there. it will most likely...

no quirk, you just dont need the []

how big is the database currently and how much space is free?

PS. for sql2000 issues you may want to post in the sql2000 section

check the NFTS permissions on the database files, the user you are logged on as likely doesn't have permissions to the files