I'm not entirely sure if the remote server is a named instance. There are three servers on one IP address. One of them is using the default port (1433) and...

Another option is to remove the TRY/CATCH and ROLLBACK statements. This depends on what your calling environment expects.

SET XACT_ABORT ON

BEGIN TRANSACTION

EXEC proc1

EXEC proc2

COMMIT

In this case, rollback will be automatic if...

CREATE TABLE t1 (a INT)

INSERT t1 VALUES (1),(2),(3),(4),(5)

CREATE TABLE t2 (a INT)

INSERT t2 VALUES (1),(2)

MERGE t1

USING t2 ON t1.a = t2.a

WHEN MATCHED THEN DELETE;

SELECT...

It's been years since I've had to deal with ODBC, but I think I can point you in the right direction.

MS Access is holding an ODBC connection that it believes...

Daylight savings exists so that I can double the number of mornings that I drive east staring at the rising sun and the evenings that I drive west into the...

I'd quit my job and wouldn't work for an employer ever again. No commute, no parking garage, no ID badge, no "desk" (two-sided "cubicle" in a hallway, banquet table in...

Yep, compatibility level was the problem. All the databases in SS 2008 had been originally restored from SS 2005. My local sandbox was created new in SS 2008 R2.

Thanks!

I've discovered that the composable DML approach only works on SQL Server 2008 R2, not SQL Server 2008. My production target is 2008, but I have R2 available on my...

This is an object-oriented concept. The concept isn't a bad idea in itself, it just doesn't apply to a relational database.

If you're using an object-oriented framework such as .NET for...

Thanks! I thought it should be possible in one...

I decided to use a table variable. I sent the output into a table variable, then inserted into the history table where the key is not null. I could have...

I have used serializable isolation level. I think of it as locking a key range.

There is no MERGE in SS 2005, which I was constrained to until recently, so...

double post

I've used Service Broker in a single server setup in conjuntion with a .NET service application in two different scenarios.

In a manufacturing scenario, a machine-to-SQL interface ran a stored proc...

I haven't been able to find the slow parts of the procedure becuase it's never slow in SSMS, nor in any database except production. We can only reproduce the issue...