>Hi,
>
>Is there any document available for foxpro developers to get some guidance for creating database and tables in MS SQL server ?
>
>Like a unique row identifier even in every child row or PK data types etc.
>
>I recently see a link for such a document in a thread (mentioned by Naomi Nosonovsky but not sure). Can someone repeat/link that information here ?
>
>TIA

You probably saw this short blog post

http://blogs.lessthandot.com/index.php/datamgmt/dbprogramming/best-practice-every-table-should-have-a/

You can also search on that same site for other 'Best Practices'. The advises there are short and to the point, so you can read a couple of blogs. They are tidbits of information, though, not one concise document with all best practices.