This article caused the KB article to be revised...

http://www.sqlmag.com/articles/index.cfm?articleid=44138&puuid=ACE4B7F7-1279-9119-120E9223A3A9D05A

This article is about the same topic...

http://www.sqlmag.com/Article/ArticleID/43553/sql_server_43553.html

The most commonly used alternative is probably a temporary table containing a column with the...

The suggested method is not guaranteed to work, as discussed in this KB article...

http://support.microsoft.com/default.aspx?scid=kb;en-us;273586

Another possible option...

http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1099668,00.html?track=NL-464&ad=520012

This was a duplicate post.  I guess it actually saved the message before it timed out and crashed.

This was a duplicate post.  I guess it actually saved the message before it timed out and crashed.

This might work for you...

http://searchsqlserver.techtarget.com/tip/1,289483,sid87_gci1131829,00.html?track=NL-464&ad=525294USCA

It's a crosstab tool for SQL Server that was designed with Access functionality in mind.

Thank YOU for proving my points.  You do it very well.

All tests were performed on the same server, in the same database, using the same table of sample data.

I would be happy to repeat the tests using any index(es) you...

"If your willing to post a solution you must be willing to take critism."

I assume your statement applies to everybody.

I finally took the time to test your solution and the...

It was suggested that spinning through all scripts doing ALTER PROCEDURE would fix the dependencies, but that may not work.  It looks like ALTER PROCEDURE does not preserve the dependencies...

It appears that some people tend to single out one small aspect of a T-SQL solution, an aspect they personally dislike, and use that to justify dismissal of the entire...

I have a question about option #3.

I can understand having shared tables in a shared object database, it's fine to reference them there in code.  However, suppose you have generic...

Try right-clicking in the code view/edit window and selecting Font.  The setting has remained in effect for me.