Source code is available on codeplex, so you can see for yourself what it does. I don't care I had to do some things manually, I am still very thankful...

Thanks for your responses. I managed to downgrade the packages. I need to thank a colleague -with great Google skills- for this, who sent me this link that references a...

In the 3 db scenario you simply send out 2 messages addressed to 2 services, all in a single transaction. SSB will either accept the both messages and you commit...

This one is simply answered: don't use either of NOLOCK or READPAST in data entry applications. If your client values the correctness of the data she puts in/gets out of...

I might have missed it, but I didn't see a definition for the cdm_data table yet. I've used this for my test:

create table dbo.cdm_data (

ApplicationOrg varchar(3) not null,

ApplicationType varchar(3) not...

Please do read Erland Somerskog's excellent articles on error handling in SQL server. Part 1 & Part 2. The articles were originally written for SQL 2000, then updated somewhat for...

Good article, thank you!

One addition though: if your procedure is called from within a trigger or from a service broker handler, most likely the catch block won't be called upon...

@ismel: Yes, you are right. Typed xml will return you a correct null value because the parser then 'knows' about the element being nillable. In fact it then uses the...

sknox (10/26/2010)

Except...

Have a look at what Books online has to say about @@servername and serverproperty(). My recommendation is to use consistently only select convert(nvarchar(128), serverproperty('servername')); Mixing the various alternatives for getting...

bruce lee-206043 (8/25/2009)

Update SQL Server Data by Using XML Updategrams

An updategram is a data structure that you can use to express a change in the data....

It was a very minimal test. The table didn't have any indexes, not even a primary key. After I've added an index on the LockEndDate column, the results are more...

No, I hadn't....

CREATE TABLE #tmp

( LockEndDate DATETIME)

INSERT INTO #tmp VALUES ( '2/28/2011')

INSERT INTO #tmp VALUES ( '2/24/2011')

INSERT INTO #tmp VALUES ( '1/31/2011')

INSERT INTO #tmp...

The best way to do this is using common table expressions (cte for short). cte's can be made recursive, so they are ideal for your purpose.

use tempdb

go

create table dbo.folders (

FolderID...