20090806

Will we ever learn?

A while back I posted about a Microsoft bug in 2000 server installations. Caused a production error again, then this was followed by another (SELECT 1 FROM SYS.SYSINDEXES) the next day.

Turns out it is related to the OSQL/ISQLW/ISQL installed and not the server. You can run this same script from a machine with the 2005 tools installed and point to the 2000 server and there is no error. As we deploy using processes that run the file via an isql.exe -I command line, it is a big deal.

Point is then, when we are testing for compatibility of our scripts, we can't run it from the 2005 management studio. We will get a false positive. We have to run it through the local version of the tools!

ERROR 1
PRINT 'The error is in parsing the GO incorrectly'
/*
This is a comment
GO
*/

ERROR 2
--The error here is the prefix of the SYS. that will not parse correctly
SELECT * FROM SYS.SYSINDEXES

20090801

Summary of Summer

A friend of mine, a life-long resident of Los Angeles California, moved Minneapolis Minnesota and I was giving him some perspective on the seasons where I grew up. Discovered something myself in doing so.

"The thing I grew up with and remember the strongest about the seasons was that when it was the middle of Summer you could hardly wait for winter, and when it was the middle of Winter, you could hardly wait for Summer. Seasons all have their good and bad points, you just have to learn to take advantage of them when they are there. The biggest thing I miss is that change. I have been living in a 22 year long Summer now and its more than a bit annoying. I miss the beauty of the trees in the Fall, fresh fallen snow and the quiet it brings in the Winter, the smell of mud in the spring after the first good thaw. Hmmm, can't think of anything nice about Summer. Oh well."

License & copyright

Creative Commons License
StinkySQL weblog and any related pages, including the weblog's archives are licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 United States License.