Happy snap from my desk

Just wanted to see how blogging from my phone looked.

Just in case you thought I might be moving

I'm not ... I'm staying right here where I don't have to put up with my server at home randomly rebooting every 2-3 days.

Moving Blog site

I'm moving my blog to,
http://cartershome.dyndns.org/philcart/default.aspx

Look for the content to show up there eventually.

Programmatically printing reports ... SP2 = Ahhh!

As I mentioned in a previous post Phills Philosophies: Programmatically printing reports ... SP2 = Ouch! printing reports directly to a printer had some undesirable effects when using SP2.

Well thanks to some assistance from Daniel Reib on the MSDN forums we discovered that not only did I need to set the printing points as per a comment by Keith Walton, I also needed to explicitly set the PageHeight and PageWidth.

I was able to retireve these easily enough via the web service and then based on the page sizing set the Landscape property in the DefaultPageSetting for the document.

My next trick is to intergrate what is now two command line apps (one for printing and one for report mailing) so we have a single application that provides all means of distributing the rendered reports.

More SQL Server 2005 Updates

A new update to Books Online is available from here,
http://www.microsoft.com/downloads/details.aspx?FamilyID=be6a2c5d-00df-4220-b133-29c1e0b6585f&DisplayLang=en

Also, a cumulative hotfix package has been released. Hotfix details and download links for each component are available from here,

http://support.microsoft.com/kb/918222

Categories: SQL