Trycatchfinally - trycatchfinally.net - TryCatchFinally.net
General Information:
Latest News:
Error creating emailed report subscriptions in Sharepoint-integrated SSRS 1 Jun 2013 | 04:16 am
Anybody who has the rights to run a report in SSRS can set up a subscription, delivering the report to their own email address. However, if you try to deliver the report as an email to somebody else, ...
Write permission error when inserting over linked server 24 Apr 2013 | 01:28 am
I spent some time troubleshoot permissions over a linked server recently before finding out the the cause of my error wasn’t permissions-related at all. I was attempting to perform an insert on a remo...
Identifying row in SQL view (or table) with a calculation error 9 Apr 2013 | 10:23 pm
Computed columns can be a great tool if you want to add a value to a table that’s dependent on other columns in the table, and you don’t want to maintain it on its own every time the source columns ch...
Identifying SQL Server 2005 Enterprise Edition features in use 6 Apr 2013 | 09:33 am
I recently stumbled across a great system view, sys.dm_db_persisted_sku_features, which identifies any enterprise features in use in the current database, which would prevent you from moving this data...
Unexpected results from ISNULL in SQL Compact 3.5 19 Mar 2013 | 08:40 am
In SQL Server, the ISNULL function takes two arguments – the first is a potentially NULL value, and the second is another potentially NULL value. If the first value is NULL, the function returns the s...
“Initializing Reconciler has failed” when setting up SQL Compact replication 11 Mar 2013 | 08:29 am
When initializing replication to a .NET Compact Framework client on a mobile device, I was receiving an error message when I attempted to start the synchronize: Initializing the SQL Server Reconciler ...
Refreshing changed .NET SQL CLR assemblies after patching/updates 2 Mar 2013 | 04:35 pm
After applying some Windows updates to one of my servers, I started getting the following error when I ran a customer .NET SQL-CLR stored proc: Server: Msg 6522, Level 16, State 2, Line 1 A .NET Frame...
Matching up SQL CE DLL version numbers 14 Feb 2013 | 01:12 am
The Abstract: While developing a Windows Mobile device application on two different computers, I thought I’d installed SQL Server Compact Edition 3.5 SP2 on both of them, but ran into some version dif...
Calculating working hours between two dates 11 Jan 2013 | 02:54 am
As a follow-up to an earlier post (Return a list of all dates between a start and end date), I need to find the number of working hours between two timestamps – in this case, it was to see how long a ...
“Invalid server” error while altering SQL Agent Job step 11 Dec 2012 | 03:25 am
When updating a SQL Agent job step to run an SSIS package instead of executing an SSAS script, I received the following error when trying to save the Agent Job: The specified ‘@server’ is invalid (val...
