hmmm Methinks you are talking from experience.

Hmmm correction I have never worked as a Network Admin and don't intend to.

So who is crazy now? LOL

Hey,

What do you mean? I am all three at least on paper when I finished my MCDBA I had only one exam left to be MCSE so I took it. ...

Primary Key is a constraint and a clustered index is usually the main index of a table although you are not required to create one.  So both are not required...

There is one problem with that I experienced it so I know we had a 500 pages use case document the developers and the business team have read and write access to...

If you have Visual Studio it is actually very easy because if you create a DataSet of your table and call the ReadXml method it generates XML of your data...

This could help in SQL Server or .NET.  Hope this helps.

http://sqlserver2000.databases.aspfaq.com/can-i-make-sql-server-format-dates-and-times-for-me.html

http://authors.aspalliance.com/aspxtreme/sys/globalization/demos/DateTimeFormatInfoGetAllDateTimePatterns.aspx

Export to Excel or Word save as HTML.  Hope this helps.

Export to PDF and disable print and copy of the file properties and there is more you can add including password protecting.  Hope this helps.

Here is a free study guide for the exam and other programming exams but you still need practice exams because the material is not the exam.  Hope this helps.

http://www.codeclinic.com/70-229skills.htm

Then I have two choices for you Excel 2003 XML tool box and Stylus studio which cost under $60, it will generate the SQL Server XML if you ask for...

EDIT

Sorry I forgot the easiest for a database developer Dataset.ReadXML method in ADO.NET it converts your table to XML, fast easy and painless JeFF.

ActiveX as was pointed out is obsolete but...

When a column data is fixed there may be a check constraint on the column which means you have to ALTER Table drop all constraints then ALTER table again and...

Hi mkeast,

You mean these people don't know the meaning of BCNF? I would find that very funny.  Relational algebra expert Chris Date said those who practice without theory are...

Data Access is just part of the Enterprise Application block it comes with everything you need to create a .NET application and SA is not required but DBO is needed...