168 reputation
5
bio website rikgarner.co.uk/wordpress
location Manchester, United Kingdom
age 45
visits member for 2 years, 2 months
seen Feb 26 at 22:32

I'm the technical lead at a consultancy company based in the UK where we advise on, design and build knowledge and document management systems.

I like whisky.


Feb
4
comment SQL Server Service Broker messages in one database fails unless SA owns the database? What's going on here?
Are you connected to an LAN via AD? I found that when my domain a/c owned the database and I tried to work on stuff at home (not connected to corporate network) that SSSB wasn't happy that it couldn't authenticate my account, but it wasn't fussed when owner was SA.
Dec
15
comment SQL Server Problems
Is it possible you only installed the management tools i.e. not the database engine?
Aug
16
answered Setting up SQL Server service broker from one database to multiple databases
Aug
16
comment Setting up SQL Server service broker from one database to multiple databases
How does it fail? Does one service work or neither?
Aug
16
answered Setting up SQL Server service broker from one database to multiple databases
May
10
comment SSRS 2008 R2 setup issue
Try opening IE as Administrator and then navigate to the URL.
Apr
18
awarded  Tag Editor
Apr
18
revised service-broker wiki excerpt
added 97 characters in body
Apr
18
awarded  Supporter
Apr
18
wiki created service-broker excerpt
Apr
18
suggested suggested edit on service-broker tag wiki excerpt
Sep
18
comment Auditing - parameter values not being written to log
I've tried both parameterization settings - but I'm on R2 where the behaviour seems to be the same, but there's no explicit fix for R2 (that I can see) so I'm confused. Was it not changed in R2?
Sep
14
awarded  Student
Sep
14
asked Auditing - parameter values not being written to log
Sep
5
awarded  Teacher
Sep
5
answered Converting Database from GUID to Integer Keys
Jan
24
awarded  Autobiographer