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...

Somebody must have a thought or suggestion on this issue!

Perhaps I have done a poor job explaining the problem and nobody knows what I'm talking about. If so, please...