Because it was equal in sql 6.5 (apparently).

Right click on the server

2nd option : Registration properties of a server (rough translation)

Before the last check box : display system tables.

HTH... don't feel stupid, this one is not easy to get at first .

Tx.

Can you post the table design?? hard to tell.. Sometimes a 5 columns table is too large and a 200 columns is not large enough. what's the max...

ok... but you'll still have to split that thing at intervals of 50 tables or so... 8000 chars is just not be enough.

Lets hear about those : "Sometimes that sinks in. Sometimes not. In over twenty years of this profession, I've experienced some Dilbert moments you wouldn't believe."

Can you use 2 textbox (one per field.. so they can have their own fonts). Then align the text in the left field to the right and the right...

Use this to split the list :

--I use this table for many other string operations as well

CREATE TABLE [Numbers] (

[PkNumber] [int] IDENTITY (1, 1) NOT NULL ,

CONSTRAINT [Pk_Number] PRIMARY...

You don't need dynamic sql to do that. What's the problem you're trying to solve in that proc?

Ya I remember, different task but that one definitly always faster with select cross join (even if you have to drop a column at the end).

That's why I worked to create mine... but if he needs top n that's gonna be an entirely different solution.

Please do not cross-post, we monitor all boards.

Finish the thread here : http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=23&messageid=201010

Yup even Steve knows this one, he told me about it a few weeks back. Looks like it's an old question that got through the cracks. Both table are DEFINITLY...

That'll work... looks like noeld posted the message at the same time and he didn't see your reply.