Limited places left for SQLBits V

 



We are nearing the max numbers we can afford for the Saturday of SQLBits V. So if you are thinking of coming then make sure you register soon.


More importantly, if you have said you are coming to the Saturday (most of you) and you can no longer make it, please update your registration accordingly. We have to cater for all the number registered and so if you don't come we will still be paying the venue for you. So please keep your registration updated.


 



 


Ordering Integration Services Packages in Management Studio

Call me picky but it bugs me when things aren't in order. The SQL team seem to be really bad at this particular annoyance. They seem unable to put things in a nice order.


If you are loking at packages in Management Studio then you will find the packages in totally random order, why is that you. Well they haven't put an ORDER BY on the query that lists the packages, and we all know that without and ORDER BY there is not guarantee of the order of the results.


To fix this you can hack one of the system stored procs. sp_dts_listpackages


This package is found in msdb it is classed as a system procedure and so is in the system procedures folder (if looking in object explorer).


If you change it to


ALTER PROCEDURE [dbo].[sp_dts_listpackages]


  @folderid uniqueidentifier


AS


  SELECT


      name,


      id,


      description,


      createdate,


      folderid,


      datalength(packagedata),


      vermajor,


      verminor,


      verbuild,


      vercomments,


      verid


  FROM


      sysdtspackages90


  WHERE


      [folderid] = @folderid


ORDER BY name


You will get your packages ordered nicely by name.




-