Viewing 15 posts - 15,001 through 15,015 (of 18,923 total)
Right click on the server
2nd option : Registration properties of a server (rough translation)
Before the last check box : display system tables.
July 14, 2005 at 8:26 am
HTH... don't feel stupid, this one is not easy to get at first
.
July 14, 2005 at 8:18 am
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...
July 14, 2005 at 8:11 am
ok... but you'll still have to split that thing at intervals of 50 tables or so... 8000 chars is just not be enough.
July 14, 2005 at 8:07 am
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."
July 14, 2005 at 8:05 am
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...
July 14, 2005 at 8:00 am
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...
July 14, 2005 at 7:56 am
You don't need dynamic sql to do that. What's the problem you're trying to solve in that proc?
July 14, 2005 at 7:34 am
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).
July 14, 2005 at 7:31 am
That's why I worked to create mine... but if he needs top n that's gonna be an entirely different solution.
July 14, 2005 at 7:26 am
Please do not cross-post, we monitor all boards.
Finish the thread here : http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=23&messageid=201010
July 14, 2005 at 7:06 am
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...
July 14, 2005 at 7:00 am
That'll work... looks like noeld posted the message at the same time and he didn't see your reply.
July 14, 2005 at 6:55 am
Viewing 15 posts - 15,001 through 15,015 (of 18,923 total)