Grant Scheme - Cultural Technology – 2010

30. July 2010

Very encouraging...

http://www.tcs.gov.ie/pdfs/cultural_technology_scheme_2010.pdf

 

 

 

Ideas

Open source asp.net social network apps

29. July 2010

Google Font API

29. July 2010

Complete Windows XP Drivers for Dell Inspiron 1545

29. July 2010

Following on from this post

b. Sigmatel Audio Driver (IDT 92HD71B) here
File Size: 11 Mbyte

Windows

Get list if users currently logged into SQL Server

28. July 2010

set nocount on
create table #sp_who (
  spid        smallint,
  ecid        smallint,
  status    nchar(30),
  loginame    nchar(128),
  hostname    nchar(128),
  blk        char(5),
  dbname    nchar(128),
  cmd        nchar(16),

  requestid integer)

)


insert into #sp_who execute sp_who
select distinct loginame from #sp_who
drop table #sp_who

SQL Server

Stanford iPhone Application Development

16. July 2010

SQL Server 2005 Unattended Install

12. July 2010

 

 

http://www.developmentalmadness.com/archive/2006/06/30/sql-server-2005-unattended-install.aspx

 

SQL Server

Jet SQL Data Types

8. July 2010

Use T-SQL to turn on XP_CMDSHELL

6. July 2010

ALTER PROCEDURE USP_TURN_ON_XP_CMDSHELL

AS

BEGIN

    -- To allow advanced options to be changed.
    EXEC sp_configure 'show advanced options', 1
   
    -- To update the currently configured value for advanced options.
    RECONFIGURE
   
    -- To enable the feature.
    EXEC sp_configure 'xp_cmdshell', 1
   
    -- To update the currently configured value for this feature.
    RECONFIGURE
   

END

SQL Server

Raising error to jump to CATCH block

6. July 2010

Unfortunately up to this point I was using select 1/0 to force an error and jump to The CATCH block.

 Thankfully I have started using this method instead 

IF @ERR IS NOT NULL RAISERROR (@ERR, 16,1 )

 Where 16 represents the SEVERITY. Using a value between 11 to 19 causes execution to jump to the CATCH block.

1 represents the STATE and is an arbitrary integer.

 Reference:

http://msdn.microsoft.com/en-us/library/ms178592%28SQL.90%29.aspx

 

SQL Server