Documentation for SQL Server 6.5

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Older Versions of SQL (v6.5, v6.0, v4.2) » Older Versions of SQL (v6.5, v6.0, v4.2) » Documentation for SQL Server 6.5

Documentation for SQL Server 6.5

Rate Topic

Display Mode

Topic Options

Author

Message

derek.colley

Posted Monday, March 12, 2012 5:39 AM

SSC-Addicted

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 3:40 AM
Points: 496, Visits: 583

Does anyone know where I can find the documentation(online) for v6.5? Specifically I'd cherish a list of valid system views in 6.5, i.e. which ones are today's equivalent of sys.dm_exec_connections, sys.databases, etc. etc. I know 6.5 allowed access to the syslogs view (to see inside the t/logs - hurrah) but aside from this nugget, I'm not sure what views were available in this product.

Reason being I have to troubleshoot a 6.5 box later today, considering this was released when I was 12 years old I am anticipating some trouble.

Wish me luck / send me links! Thank you.

---

Note to developers:
CAST(SUBSTRING(CAST(FLOOR(NULLIF(ISNULL(COALESCE(1,NULL),NULL),NULL)) AS CHAR(1)),1,1) AS INT) == 1
So why complicate your code AND MAKE MY JOB HARDER??! Crazy

Want to get the best help? Click here http://www.sqlservercentral.com/articles/Best+Practices/61537/ (Jeff Moden)
My blog: http://uksqldba.blogspot.com
Visit http://www.DerekColley.co.uk to find out more about me.

Post #1265084

Elliott Whitlow

Posted Monday, March 12, 2012 8:13 AM

SSCertifiable

Group: General Forum Members
Last Login: Wednesday, April 24, 2013 12:02 PM
Points: 5,854, Visits: 4,873

Not sure where you would find such a beast.. But 6.5 did have BOL but it was not near as good as today's BOL.

I am thankful to say I haven't had to work on 6.5 since about 2003.. Now if I could just rid myself fully of SQL 2000 that would be great..

CEWII

Post #1265218

bitbucket-25253

Posted Monday, March 12, 2012 9:47 AM

SSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 8:55 AM
Points: 5,099, Visits: 20,190

Do not know if BOL is included, but here is where you could download SQL Server 6.5, and see if BOL is included.

http://download.cnet.com/Microsoft-SQL-Server-6-5/3000-10254_4-19517.html

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read
Before posting a performance problem please read

Post #1265315

Elliott Whitlow

Posted Monday, March 12, 2012 11:58 AM

SSCertifiable

Group: General Forum Members
Last Login: Wednesday, April 24, 2013 12:02 PM
Points: 5,854, Visits: 4,873

I think I might have the actual disk at home.. Scary..

CEWII

Post #1265432

derek.colley

Posted Monday, March 12, 2012 12:05 PM

SSC-Addicted

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 3:40 AM
Points: 496, Visits: 583

Thanks everyone, I'll see if BOL is included in the download.

---

Note to developers:
CAST(SUBSTRING(CAST(FLOOR(NULLIF(ISNULL(COALESCE(1,NULL),NULL),NULL)) AS CHAR(1)),1,1) AS INT) == 1
So why complicate your code AND MAKE MY JOB HARDER??! Crazy

Post #1265437

bitbucket-25253

Posted Monday, March 12, 2012 12:48 PM

SSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 8:55 AM
Points: 5,099, Visits: 20,190

derek.colley (3/12/2012)

Thanks everyone, I'll see if BOL is included in the download.

If it is or is not come on back and post, it might be valuable for others to know

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read
Before posting a performance problem please read

Post #1265467

derek.colley

Posted Tuesday, March 13, 2012 3:28 AM

SSC-Addicted

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 3:40 AM
Points: 496, Visits: 583

No, the download is duff. But vetusware.com (the abandonware site) purports to have SQL Server 6.5 in 20 .rar parts. I've downloaded it but sadly part 3 is missing so it's useless.

I'll keep looking and if I find it I'll post a link.

---

Note to developers:
CAST(SUBSTRING(CAST(FLOOR(NULLIF(ISNULL(COALESCE(1,NULL),NULL),NULL)) AS CHAR(1)),1,1) AS INT) == 1
So why complicate your code AND MAKE MY JOB HARDER??! Crazy

Post #1265770

Ian Scarlett

Posted Wednesday, March 14, 2012 3:59 AM

Ten Centuries

Group: General Forum Members
Last Login: Yesterday @ 8:44 AM
Points: 1,322, Visits: 4,399

Derek

I have 3 SQL Server 6.5 books gathering dust in my garage...

The SQL Server 6.5 Performance Tuning and Optimization guide by Ken England
Planning and Building a high performance database by Robert D Schneider
SAMS SQL Server 6.5 Programming Unleashed

I don't know if these are any good to you. I'm not looking for any money for them (other than to cover postage). Of course, postage may be too expensive, depending on where you're based. I'm based in the UK.

PM me if you are interested.

Post #1266576

derek.colley

Posted Wednesday, March 14, 2012 5:20 AM

SSC-Addicted

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 3:40 AM
Points: 496, Visits: 583

Ian

Very kind - but I've managed to resolve the issues for now. It was the tempdb database filling up (pegged at 2*MB*! Not a typo!) I extended logsegment using sp_extendsegment onto a newly-created database device (which is a logical mapping of a .dat file to a database object), made a couple of other configuration changes and the problems are solved.

I've still got a copy of Que's Computer Glossary (board-bound) on my shelf, explaining such modern concepts as 'parallel ports' and 'World Wide Web'!

---

Note to developers:
CAST(SUBSTRING(CAST(FLOOR(NULLIF(ISNULL(COALESCE(1,NULL),NULL),NULL)) AS CHAR(1)),1,1) AS INT) == 1
So why complicate your code AND MAKE MY JOB HARDER??! Crazy

Post #1266619

derek.colley

Posted Wednesday, March 14, 2012 4:20 PM

SSC-Addicted

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 3:40 AM
Points: 496, Visits: 583

I've located and hosted SQL Server 6.5 with documentation, see main thread post here -> http://www.sqlservercentral.com/Forums/Forum1437-1.aspx?Update=1

As usual, thanks to everyone who went out of their way to help me with the original query!

---

Note to developers:
CAST(SUBSTRING(CAST(FLOOR(NULLIF(ISNULL(COALESCE(1,NULL),NULL),NULL)) AS CHAR(1)),1,1) AS INT) == 1
So why complicate your code AND MAKE MY JOB HARDER??! Crazy

Post #1267144

« Prev Topic | Next Topic »

Permissions