In an attempt to avoid being flamed, please allow me to clarify one point. The application developers out there are just as "professional" as the database developers or the production...

Check this thread...

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=110&messageid=14962

Henk,

I'm glad that you would like to have a professional and reasonable discussion.  I don't think your first post came across that way.

When writing a quotation the phrasing is not...

I don't know where Henk is coming from, but some of the statements seem rather strange.

The material I referenced does not contain any statement about the primary purpose of any...

If it's still an option at this point, consider avoiding a self-referencing table altogether.

There's an alternative presented in the September issue of SQL Server Professional and in the free e-book...

I think it's difficult to compare SQL code to VB (or any other language) code.  There are both real and perceived differences.

SQL code is generally on the back-end.  VB (or...

There's a free e-book available at this URL...

http://www.wingenious.com

It discusses data types and several other database architecture topics in the context of SQL Server.

There's a free e-book available at this URL...

http://www.wingenious.com

It discusses naming conventions and several other database architecture topics in the context of SQL Server.

I have noticed the very same behavior that is described by Ferguson. I would also echo many of Ferguson's comments. I would really like to understand what's going...

There is a generic cross-tab routine, with the ability to specify column headings in a particular order (much like Microsoft Access), included in the FREE package at this URL... http://www.dbaction.com

At the company where I work we use VSS for SQL source code. All the SQL routines from the development database are extracted to a file (in dependency order)...

Check this possibility...

If you created the routines in the development database, they were created with ANSI_NULLS off. If you used EM to script out the routines and promote them...

For further discussion follow this link...

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=28429

For those who may be interested...

With the help of Microsoft technical support, I think we have this problem resolved. I'm not an expert on Windows 2000 security so I...

Thank you very much for your comments!

I will do the auditing that you suggest. It may very well yield some helpful information.

There are several things that make me think...