I've come over all nostalgic now :crying:

Lynn Pettis (6/29/2009)

---

Jeff Moden (6/29/2009)

---

Lynn Pettis (6/29/2009)

---

And that will work until the SQL Server 2000 system table "views", like sys.syscolumns, go away in a future version od SQL Server. ...

When I first read that, it sounded like you married...

Jeff Moden (6/30/2009)

---

Ack.... :hehe: wasn't trying to be funny on that one. Master.sys.sysColumns will normally contain over 10,000 rows of system related column info even on brand new installations....

Lynn Pettis (6/30/2009)

---

I want to thank you all for looking. I personally haven't run into this kind of issue on any of the servers I have managed in the...

GilaMonster (6/30/2009)

---

I have. Previous company we had one server that was used for...

You're...

hi_abhay78 (6/30/2009)

---

I think we use the stack space for keeping the context of the thread during context switching .Thats the reason i used it :-)..You can always correct me...

GilaMonster (6/30/2009)

---

I've butted heads with someone in that thread a couple of times. Most recently on a corruption question where he was giving completely incorrect advice (emergency mode to rebuild...

Disregard the 2005-specific stuff in that post. I was given a link to follow and assumed it would take me to the 2005 forums - reading later posts made...

Hey there,

I've had similar problems over the years - here's what worked for me, just in case it helps you.

Run the following:

CREATE VIEW vasummary AS

select

Size = VaDump.Size,

Reserved...

I can see why you'd suspect that of me; but...

Michael Valentine Jones (6/29/2009)

---

I'm not sure what you are getting at with that code, especially since it has 2 syntax errors (the comma after the "AS N" and there is...

-- 🙂

SELECT TOP (100) N FROM dbo.Tally ORDER BY N ASC;

More 'fun':

SELECTTOP (100)

ROW_NUMBER() OVER (ORDER BY C1.[object_id]) AS N,

FROMmaster.sys.columns C1

ORDERBY A, (1 / CASE WHEN COUNT(*) OVER () = 100...

Michael Valentine Jones (6/29/2009)

---

I didn't miss the point of the question. My response was just making a point about generating number tables from system tables, something that was already...