Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Documentation for SQL Server 6.5 Expand / Collapse
Author
Message
Posted Monday, March 12, 2012 5:39 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Thursday, August 22, 2013 9:13 AM
Points: 496, Visits: 601
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??!

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
Posted Monday, March 12, 2012 8:13 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, May 15, 2014 5:11 PM
Points: 6,067, Visits: 5,283
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
Posted Monday, March 12, 2012 9:47 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 6:36 PM
Points: 5,572, Visits: 24,800
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
Posted Monday, March 12, 2012 11:58 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, May 15, 2014 5:11 PM
Points: 6,067, Visits: 5,283
I think I might have the actual disk at home.. Scary..

CEWII
Post #1265432
Posted Monday, March 12, 2012 12:05 PM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Thursday, August 22, 2013 9:13 AM
Points: 496, Visits: 601
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??!

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 #1265437
Posted Monday, March 12, 2012 12:48 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 6:36 PM
Points: 5,572, Visits: 24,800
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
Posted Tuesday, March 13, 2012 3:28 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Thursday, August 22, 2013 9:13 AM
Points: 496, Visits: 601
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??!

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 #1265770
Posted Wednesday, March 14, 2012 3:59 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, June 16, 2014 7:32 AM
Points: 1,327, Visits: 4,504
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
Posted Wednesday, March 14, 2012 5:20 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Thursday, August 22, 2013 9:13 AM
Points: 496, Visits: 601
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??!

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 #1266619
Posted Wednesday, March 14, 2012 4:20 PM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Thursday, August 22, 2013 9:13 AM
Points: 496, Visits: 601
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??!

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 #1267144
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse