Tuesday, April 26, 2005

Service Pack 2 is out

Service Pack 2 is out. Be sure to do the obscure 'backup your encryption keys' procedure, or else!

http://www.microsoft.com/downloads/details.aspx?FamilyId=502C0D89-1308-4662-8F58-CEC55EF1235B&displaylang=en

Tuesday, April 19, 2005

cool stuff - stored proc resultset queries

This command allows you to link to the local SQL Server & select individual columns from a stored procedure

sp_addlinkedserver @server = 'LOCALSERVER', @srvproduct = '', @provider = 'SQLOLEDB', @datasrc = @@servername
GO

select * from openquery(localserver,'exec mystoredproc')
GO

Great for comparing the results of 2 stored procedures, or doing union queries against multiple stored procedures without temp tables.

http://www.sommarskog.se/share_data.html

Thursday, April 14, 2005

RDL Generator

This is a $49 managed code component to interact with RDL files.

http://www.rdlcomponents.com/