Month: February 2008

360Agileweb

Installing VSTS 2008

I had a chance to set up the VSTS 2008.

All I can share is that you need to follow the steps as outlined in this link

1. Ensure you meet all the pre-requisites
2. Ensure you follow the step-by-step guide to the letter
3. Enjoy the power of VSTS.

I love the Team Foundation Build, it makes automation of buids so basic. You have to try this!

Julius

360Agileweb

Upgrading a Database SQL 2000 to SQL 2005

Hey,

The main thing to remember is that in SQL 2000, users used to own the objects. A user and a schema were one and the same thing.

In SQL 2005, the schema owns the objects, and the user owns the schema.
Therefore, when upgrading from SQL 2000 to 2005, the user who owned the objects is automatically converted into a schema. You ahve to go an extra mile and create a new user in 2005 and link the user to the schema.

For more details please read on the links below…

http://www.sqlservercentral.com/articles/Administration/2987/

And tracking deprecated stuff in SQL 2005:

http://www.mssqltips.com/tip.asp?tip=1370

Enjoy!