Viewing 15 posts - 31 through 45 (of 46 total)
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...
September 3, 2004 at 1:27 am
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...
July 9, 2004 at 10:41 am
There's a free e-book available at this URL...
It discusses data types and several other database architecture topics in the context of SQL Server.
June 4, 2004 at 10:19 pm
There's a free e-book available at this URL...
It discusses naming conventions and several other database architecture topics in the context of SQL Server.
June 4, 2004 at 10:14 pm
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...
September 26, 2003 at 8:51 am
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
September 17, 2003 at 7:34 pm
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)...
September 9, 2003 at 12:10 pm
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...
September 5, 2003 at 8:04 am
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...
August 7, 2003 at 11:02 am
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...
March 17, 2003 at 9:36 pm
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...
March 17, 2003 at 7:31 pm
More additional background...
This problem actually affects two different servers, seemingly simultaneously. That almost seems to indicate that something external to both servers could be causing the setting (the SQL...
March 14, 2003 at 8:58 am
Here's some additional background...
The application is browser based, so the only connection that runs the affected code is made from the web server. The affected code works most of...
March 12, 2003 at 11:49 pm
Rob,
Thank you very much for the KB article suggestion, but it does not seem to be relevant to the problem. The article is about mapping drives to shares, while...
March 12, 2003 at 4:29 pm
Viewing 15 posts - 31 through 45 (of 46 total)