164 posts tagged with "tech"

Problem​

You've transferred or run a bunch of stored procedure scripts, but you can't execute them. Reason - execute permission denied. You forgot to put a grant statement in your script.

Solution​

The trivial solution is, of course, GRANT EXECUTE ON {your proc name} TO PUBLIC. Slightly less trivial is to grant to a specific role, but most people needing this tip will only be using PUBLIC.

Wouldn't it be great to automate this for all stored procedures in the database? Well, here you go:

Problem​

On a Microsoft SQL Server 2005 installation with a linked server configured to "myserver" (which happens to be 2000), execution of a remote stored procedure (EXEC myserver.mydatabase.dbo.mysproc) fails with error:

Msg 7411, Level 16, State 1, Line 1
Server 'myserver' is not configured for RPC.

Problem​

Microsoft .Net Framework 1.1 and .Net Framework 2.0 don't play well together (as ASP.Net apps) on Windows 2003 Server 64 Bit Edition.

Solution​

either upgrade any ASP.Net 1.1 to 2.0 or switch to 32 bit compatibility mode. Of course switching to 32 bit mode will cause you to lose out on some performance benefits, but maybe you're okay with that (unless you're running under a very high load). Two easy steps:

Problem​

Need to convert an image from one format to another using .Net.

Solution​

Microsoft has really made this easy. The key is the System.Drawing.Image class, combined with the System.Drawing.Imaging.ImageFormat class.

Steps:

Problem​

In a .Net 2.0 Windows Forms application, user action causes a new

row to be added to a DataGridView control. When the viewport fills up, causing the vertical scrollbar to appear, the most recent entry is hidden "below the fold" — off the screen. Users want to see the latest entry at all times.

PBS's Robert X. Cringeley thinks Intel is poised to buy Apple (removed dead link; SF 2025), saying "Apple's Decision to Use Intel Processors Is Nothing Less Than an Attempt to Dethrone Microsoft. Really." What is a fan of upstart competitors to do when his favorite upstart (Apple) might merge with one of the upstarted (Intel as opposed to AMD)? Course its sheer speculation at this point, but Cringley makes fascinating observations. Since a friend mentioned two days ago not wanting to replace his broken Powerbook, as it would be obsolete in a year or two, I've wondered why Apple would make such a big announcement and risk major sales losses. Hm...

2¹⁴— that's the maximum number of files in a folder on the Windows operating system. If you fill this up, you don't get any more (unless you move a few files to another directory). In layman's terms, that 16,384 files. Just thought you should know.

Though historically I've not read many blogs, I've been poking around looking for good news sources to add to my news feeds in the new Mozilla Firefox pr1. My slumming has turned an interesting piece on the future of cold fusion over at Popular Science.

As a child I watched Elroy Jetson with a certain bemusement, flitting about in his jet pack, popping food pills, and relying on Rosy the Robot to keep his room clean. Likewise in Disney World's Tomorrowland I gazed in amazement at what was once envisione d for our future. Monorails and jet packs were just the optimistic incarnations of that Cold war futurism — but in science fiction particularly we find the more sinister predictions. Luminaries such as Bradbury, Roddenberry, and Gibson penned tales of continuing exploitation of all that humanity might invent. While their tales were scoffed at or ignored by the masses, especially when the Cold War ended with fall-out-free winters, the days of past present may be returning to the present future.

In the next day or two Microsoft will come out with its long-heralded, major updates to WindowsXP, known as Security Pack 2. The updates for SP2 take care of usability, default settings, and security bugs/holes. A new security pack from Microsoft is always a major step forward… but in my experience always comes with a few bugs itself.