Why dont you use GUID...

In the Import/Export Wizard make sure that you select the contstraints for data transfer.

Yes, its a brilliant idea. On the contraty, you can check for existing technologies like MOSS or DotNetNuke or other CMS on the features they provide.

Hello, While doing the TFS project permission settings, You have to add users in the Portal seperately in order to give them access to the Portal. Automatically the Portal permissions does not get set if you add users to the TFS Project. You can add users by opening the portal, log in as admin and go to Site Settings.

Correct, I agree with you. Sometimes we cannot afford a layered architecture. It is not practical also. Architecture should be based on Application demand. Thanks for pointing this out.

Refer the following link to get hold of some good online materials http://technet.microsoft.com/en-my/office/sharepointserver/default(en-us).aspx

Are you using WCF Services?

Check whether your are properly closing the database connections after every database transactions.... it might so happen that the connections are not closed and hence the database not allowing new connections..

What do you mean by access client from the SQL Server 2005.... Please put in some addl. details... usually, from client, the database server is connected...

I found your post very surprising, how could you know C# well without understanding the .Net Framework.

In your IIS, right click the Virtual Directory --> Properties --> Directory Security --> Click on Edit button in the section Authentication and Access Control --> Check the Enable Anonymous Access checkbox, Deselect Integrated Windows Authentication. This should solve the issue. Hope you have not set any Windows Authentication code in your web application. Else you need to look into that as well.

You can write a stored procedure that returns multiple recordset and get the resultset directly mapped with a dataset, it will create the same number of datatables in your dataset as the count of resultset in your procedure...

Your issue is not coming out very clear.

You can wrte triggers for the same. However it is not a good approach. Better check in your stored procedure with the condition...

Hey, I guess you repeated your question.

If you are migrating the database from SQL Server 2000 to 2005, there should ot be any issue as such as SQL Server 2005 is backward compatible and all the statements, functions and other database objects and syntax of SQL Server 2000 works fine in SQL Server 2005. In case of conflict, during migration it will show the alerts. However for double checking, you can run through the test cases that are meant for sections, that have database transactions.

There are few options here for you: Using Windows authentication to access the database. Using SQL authentication to access the database. For Windows Authentication, you need to use Active Directory User to map to your database. For SQL Authentication, you need to create a SQL User and map the appropriate Roles and map with your database. In your C# application, encrypt your connection string and use the same. Many a times in shared deployment environment, they allow on SQL Authentication only, in such a case you will have to use SQL Authentication.

Hey, these is a common thing when there are changes in the database schema. In such a case, your developer must have documented the changes that they have made. Create Alter scripts on the table with the changes on the schema and run the same on the Production environment to update the schema on the production. But ensure you backup the production database before executing the alter scripts.

The database design is fine, as the car and color has many-to-many relationship. Regarding the database binding, you can have queries in your stored procedure to return multi-recordsets and then you can store them in multi datatables in your dataset with relationship between the datatables... Then bind the cars and based on the car the colors to the dropdown list by iterating through the rows in the GridView...

You can get good details from the following URL http://msdn.microsoft.com/en-us/library/aa213778(SQL.80).aspx Let me know, if you have any difficulty