December 20, 2011 at 1:41 am
Dev (12/20/2011)
Henrico Bekker (12/20/2011)
some help here....what am i missing from his side?http://www.sqlservercentral.com/Forums/Topic1224192-1292-1.aspx
Change compatibility level of your database to make your code bulletproof.
OP should have posted in a SQL Server 2005 forum instead of a SQL Server 2008 forum. Like most of us, we usually make an assumption what the user is using based on the forum, especially if nothing is said.
December 20, 2011 at 1:45 am
Lynn Pettis (12/20/2011)
Dev (12/20/2011)
Henrico Bekker (12/20/2011)
some help here....what am i missing from his side?http://www.sqlservercentral.com/Forums/Topic1224192-1292-1.aspx
Change compatibility level of your database to make your code bulletproof.
OP should have posted in a SQL Server 2005 forum instead of a SQL Server 2008 forum. Like most of us, we usually make an assumption what the user is using based on the forum, especially if nothing is said.
I noticed it but he already posted in SS2K8 forum and there is NO undo for it.
Then it left on us to make adjustments. 🙂
December 20, 2011 at 1:50 am
Dev (12/20/2011)
Henrico Bekker (12/20/2011)
some help here....what am i missing from his side?http://www.sqlservercentral.com/Forums/Topic1224192-1292-1.aspx
Change compatibility level of your database to make your code bulletproof.
ALTER DATABASE Testing SET COMPATIBILITY_LEVEL = 90
GO
USE Testing
GO
SELECT CAST(GETDATE() AS DATE)
GO
Succeeds without error. Compat mode 90 on a 2008 or 2008 R2 box does not prevent the usage of any of the newer data types.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 20, 2011 at 1:50 am
Dev (12/20/2011)
Lynn Pettis (12/20/2011)
Dev (12/20/2011)
Henrico Bekker (12/20/2011)
some help here....what am i missing from his side?http://www.sqlservercentral.com/Forums/Topic1224192-1292-1.aspx
Change compatibility level of your database to make your code bulletproof.
OP should have posted in a SQL Server 2005 forum instead of a SQL Server 2008 forum. Like most of us, we usually make an assumption what the user is using based on the forum, especially if nothing is said.
I noticed it but he already posted in SS2K8 forum and there is NO undo for it.
Then it left on us to make adjustments. 🙂
Yup. Had to adjust the code provided to just make it run in my environment at home.
Could ask Steve to move it to the appropriate forum for SQL Server 2005. He does do that sometimes.
December 20, 2011 at 1:55 am
GilaMonster (12/20/2011)
Dev (12/20/2011)
Henrico Bekker (12/20/2011)
some help here....what am i missing from his side?http://www.sqlservercentral.com/Forums/Topic1224192-1292-1.aspx
Change compatibility level of your database to make your code bulletproof.
ALTER DATABASE Testing SET COMPATIBILITY_LEVEL = 90GO
USE Testing
GO
SELECT CAST(GETDATE() AS DATE)
GO
Succeeds without error. Compat mode 90 on a 2008 or 2008 R2 box does not prevent the usage of any of the newer data types.
I'm going on leave in a few hours, brain stuffy, mindset = KZN coast, sunshine.... so, wouldnt be surprised if i missed something obvious here 😀
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
December 20, 2011 at 2:02 am
Henrico Bekker (12/20/2011)
GilaMonster (12/20/2011)
Dev (12/20/2011)
Henrico Bekker (12/20/2011)
some help here....what am i missing from his side?http://www.sqlservercentral.com/Forums/Topic1224192-1292-1.aspx
Change compatibility level of your database to make your code bulletproof.
ALTER DATABASE Testing SET COMPATIBILITY_LEVEL = 90GO
USE Testing
GO
SELECT CAST(GETDATE() AS DATE)
GO
Succeeds without error. Compat mode 90 on a 2008 or 2008 R2 box does not prevent the usage of any of the newer data types.
I'm going on leave in a few hours, brain stuffy, mindset = KZN coast, sunshine.... so, wouldnt be surprised if i missed something obvious here 😀
Gail is right. It was my guess. 😉
BOL explains it.
'Compatibility level provides only partial backward compatibility with earlier versions of SQL Server.'
December 20, 2011 at 3:43 am
Koen Verbeeck (12/19/2011)
Roy Ernest (12/19/2011)
You all are older than me. I am a young pup compared to some of you. 🙂Ahem. You all are older than me.
I'm a child of the 80's, but luckily I don't remember much of it 🙂
I used computers only for gaming and the Internet when I was young, and I learned how to program (Java, C, C++) when I studied for engineering at the university (never used a slide rule though. Don't even know what it is). I don't recall much of those programming languages as I almost immediately - after about 1,5 years of career - got into SQL Server. That was 2 years ago, so I have an astounding long career of 4,5 years behind me.
Jup, I'm quite the rookie 😉
Pipped at the post. Late-late 70's
December 20, 2011 at 5:52 am
Koen Verbeeck (12/19/2011)
Roy Ernest (12/19/2011)
You all are older than me. I am a young pup compared to some of you. 🙂Ahem. You all are older than me.
I'm a child of the 80's, but luckily I don't remember much of it 🙂
I used computers only for gaming and the Internet when I was young, and I learned how to program (Java, C, C++) when I studied for engineering at the university (never used a slide rule though. Don't even know what it is). I don't recall much of those programming languages as I almost immediately - after about 1,5 years of career - got into SQL Server. That was 2 years ago, so I have an astounding long career of 4,5 years behind me.
Jup, I'm quite the rookie 😉
I'm an 80's child as well, and I remember none of it! 😛
That could just be due to my terrible memory though. My career in IT has so far lasted an astounding 3 years (well, in January it'll be 3 years :-)).
December 20, 2011 at 6:04 am
WayneS (12/19/2011)
bitbucket-25253 (12/19/2011)
Another quirk - those old machines when shut down were restarted by reading a series of commands from a roll of punched paper tape. Doubt if many or even anyone remembers that medium.5-hole or 8-hole?
http://en.wikipedia.org/wiki/Punched_tape
You might be interested in this history of data storage media: http://www.pcworld.com/article/188661/from_paper_tape_to_data_sticks_the_evolution_of_removable_storage.html (In my old college programming classes, I used punched card and cassette tapes. In my first job, they used "disk packs"; a later job used mag tape reels. I've also used tape cartridges, ROM cartridges (games), floppys, opticals, MO, Zip (remember the "click-of-death"?), flopticals, SparQ, various flash formats, and now USB.)
... now that I've suitably aged myself...
8 hole is all I remember.
Golf on a Honeywell mainframe.
What were the fast modems back then - 300 baud?
December 20, 2011 at 7:15 am
Greg Edwards-268690 (12/20/2011)
WayneS (12/19/2011)
bitbucket-25253 (12/19/2011)
Another quirk - those old machines when shut down were restarted by reading a series of commands from a roll of punched paper tape. Doubt if many or even anyone remembers that medium.5-hole or 8-hole?
http://en.wikipedia.org/wiki/Punched_tape
You might be interested in this history of data storage media: http://www.pcworld.com/article/188661/from_paper_tape_to_data_sticks_the_evolution_of_removable_storage.html (In my old college programming classes, I used punched card and cassette tapes. In my first job, they used "disk packs"; a later job used mag tape reels. I've also used tape cartridges, ROM cartridges (games), floppys, opticals, MO, Zip (remember the "click-of-death"?), flopticals, SparQ, various flash formats, and now USB.)
... now that I've suitably aged myself...
8 hole is all I remember.
Golf on a Honeywell mainframe.
What were the fast modems back then - 300 baud?
You mean those acoustic couplers you'd attach to the phone? I think they were about that speed. That was early to mid eighties, about the time when my career in IT started.
And yes, I do remember punchcards (but not paper tapes)! Biggest fun was when my female colleague at varsity came down the stairs with two drawers full of them and then slipped. Thousands of cards all over the show. That's when we first learned about the usefulness of backup media (second set of copied cards) 😀
December 20, 2011 at 7:27 am
Jan Van der Eecken
And yes, I do remember punchcards (but not paper tapes)! Biggest fun was when my female colleague at varsity came down the stairs with two drawers full of them and then slipped. Thousands of cards all over the show. That's when we first learned about the usefulness of backup media (second set of copied cards)
Ah the trick for recovery with those 80 column punched cards. First 72 columns would / could be read by the card reader hardware. We used column 73 to 80 to punch in a sequence number. Drop a box of cards, take the pile to a card sorter, and perform multiple sorts on columns 73 to 80.. eventually you'd have them back in the proper sorted order. And if there were enough cards that you spent more than 20 minutes performing the sorts.. you learned to secure the lids of those card boxes with stout rubber bands or tied them close using some strong strings.
December 20, 2011 at 8:33 am
Greg Edwards-268690 (12/20/2011)
What were the fast modems back then - 300 baud?
Screaming Eagle fast. I remember having to put my phone's handset in the modem cradle to get connected to a BBS.
Chat rooms? Multi-user connected forums? What are those?
1 connection at a time, please. Make your post and get offline so the next person can catch up on the posts.
December 20, 2011 at 8:38 am
Jan Van der Eecken (12/20/2011)
Greg Edwards-268690 (12/20/2011)
WayneS (12/19/2011)
bitbucket-25253 (12/19/2011)
Another quirk - those old machines when shut down were restarted by reading a series of commands from a roll of punched paper tape. Doubt if many or even anyone remembers that medium.5-hole or 8-hole?
http://en.wikipedia.org/wiki/Punched_tape
You might be interested in this history of data storage media: http://www.pcworld.com/article/188661/from_paper_tape_to_data_sticks_the_evolution_of_removable_storage.html (In my old college programming classes, I used punched card and cassette tapes. In my first job, they used "disk packs"; a later job used mag tape reels. I've also used tape cartridges, ROM cartridges (games), floppys, opticals, MO, Zip (remember the "click-of-death"?), flopticals, SparQ, various flash formats, and now USB.)
... now that I've suitably aged myself...
8 hole is all I remember.
Golf on a Honeywell mainframe.
What were the fast modems back then - 300 baud?
You mean those acoustic couplers you'd attach to the phone? I think they were about that speed. That was early to mid eighties, about the time when my career in IT started.
And yes, I do remember punchcards (but not paper tapes)! Biggest fun was when my female colleague at varsity came down the stairs with two drawers full of them and then slipped. Thousands of cards all over the show. That's when we first learned about the usefulness of backup media (second set of copied cards) 😀
Try about 1971..... seem to remember having to dial the phone back then. No numbers to just punch.
December 20, 2011 at 8:48 am
bitbucket-25253 (12/20/2011)
Jan Van der Eecken
And yes, I do remember punchcards (but not paper tapes)! Biggest fun was when my female colleague at varsity came down the stairs with two drawers full of them and then slipped. Thousands of cards all over the show. That's when we first learned about the usefulness of backup media (second set of copied cards)
Ah the trick for recovery with those 80 column punched cards. First 72 columns would / could be read by the card reader hardware. We used column 73 to 80 to punch in a sequence number. Drop a box of cards, take the pile to a card sorter, and perform multiple sorts on columns 73 to 80.. eventually you'd have them back in the proper sorted order. And if there were enough cards that you spent more than 20 minutes performing the sorts.. you learned to secure the lids of those card boxes with stout rubber bands or tied them close using some strong strings.
I worked for a company in 2002 that was still using punch cards for their payroll system. My job was to help them transition from punch cards to magnetic tape, the next oldest system they could find. They liked it because it was "cheapest". I used VB.Net and SQL Server 2000 to upgrade their system and offered to create an in-house system for them, but they didn't want it. I tried to explain how it'd be cheaper, faster and more reliable for them in the long run, but they were happy with the system they had and were only upgrading because the outside company was getting rid of their punch card system.
I wouldn't be in the least bit surprised if there are still companies out there using punch card systems or some of the ones you've all been describing, just waiting until the system fails and can't be fixed before trying to upgrade.
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
December 20, 2011 at 9:08 am
Sorry for hiccup. I Google-d something today (after a long long time, using Bing now days) and didn’t find a single sponsored links there. No promotions from Google.
Any idea?
Viewing 15 posts - 32,776 through 32,790 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply