Good Blackberry ebook reader

I have recently got myself a Blackberry 8800 phone.
While it is not the latest and greatest model it is still a very good smart phone.

One of the first things I wanted to do was find a ebook reader for it. After some trial and error and I found the KOBO reader an excellent choice.

You can get it from Blackberry App World or from Kobobooks

Kobobooks has a fairly good selection of books to choose from and most are a good price.

Creating a link between two SQL servers

To create a link between two SQL Servers you need to use the sp_addlinkedserver and sp_addlinkedsrvlogin stored procedures.

First,

sp_addlinkedserver @server='DBLINK01',@srvproduct='',@provider='SQLOLEDB',@datasrc='SQL-HOU-01';

Where,
@server is the name of the link
@srvproduct is the type of product, by default SQL Server
@datasrc is the server you link to

Then, you need to set the username and password to use on the link.

sp_addlinkedsrvlogin 'DBLINK01','false',null,'sa','Pa$$w0rd';

The first parameter is the name of the link to use,
The fourth is the account of the remote server to use,
The fifth is the password for the account.

Manually adding a mail account to SQL2005/2008

I was having trouble adding configuring Database Mail on a SQL2005 server today.
I followed the wizard just like I had done on the previous 6 servers, but this one just didn’t want to add it. It was giving me an error about not being able to insert a NULL into the server name field, although I was giving it a server name.

I tried manually adding the data into the table, but of course that didn’t work. You have to use a stored procedure.
You need to use msdb.dbo.sysmail_add_account_sp with options like below,

msdb.dbo.sysmail_add_account_sp @account_name='company.com mail server',@email_address='john.doe@company.com',@display_name='John Doe',@replyto_address='john.doe@company.com',@mailserver_name='mail.company.com',@port=25;