ChrisM@Work (10/17/2016)

---

There are at least two issues here which will unnecessarily prolong an INSERT transaction using this process.

Firstly, as Jeff pointed out, the SELECT. Use the OUTPUT clause instead,...

Yes

Raghavender (10/14/2016)

---

Hi All,

Could you please help me in setting up SQL Server cluster in cross domain.

What are the prerequisites, what are the precaution we need to take.

Is there any guide...

Jeff Moden (10/16/2016)

---

Rechana Rajan (10/16/2016)

---

Found the below query causing blocking from different SPID.

declare @0 bigint,@1 bigint,@2 varchar(50),@3 bit,@4 varchar(50),@5 datetime2(7),@6 varchar(50),@7 datetime2(7)

INSERT [dbo].[Transaction]

([TransactionId], [ConId], [TransactionStatus], [Status], [CreatedUserId], [CreatedDate], [UpdatedUserId], [UpdatedDate])

VALUES...

Thanks Willem

Phil Parkin (9/28/2016)

---

Rechana Rajan (9/28/2016)

---

Phil Parkin (9/28/2016)

---

Rechana Rajan (9/28/2016)

---

The transaction is not getting commited or rollback when run in different db. The execution might throw error but its not commiting...

Phil Parkin (9/28/2016)

---

Rechana Rajan (9/28/2016)

---

The transaction is not getting commited or rollback when run in different db. The execution might throw error but its not commiting for below

BEGIN TRY

...

Eirikur Eiriksson (9/26/2016)

---

No, a session cannot deadlock itself and there are two different spids in there, spid="186" & spid="200".

😎

On the other hand, this looks like a multi threaded Entity...

GilaMonster (8/31/2016)

---

Run your rollback scripts.

If you don't have rollback scripts, then you're looking at restoring a copy of the database to a point before the deployment and then trying to...

Eddie Wuerch (5/30/2016)

---

Queries aren't routed, the entire connection is. The connection does not change based on the type of query executing on that connection. You will connect to the Listener...

Thanks HappyCat.

I understand that Listener is not an instance. My question is how can i determine where a query is routed, to primary or secondary? I believe that read-only queries...

tmmutsetse (4/13/2016)

---

Hie i am new on this forum,please advise i do my back ups via a sql server agent job which ecxecutes a stored procedure

EXECUTE dbo.DatabaseBackup

Check whether the backup is proper. Run restore verifyonly on that file.

No worries. Its my mistake

helper_10 (3/20/2016)

---

You have to allow all instances connect remotely. Go to all instance property and make sure all remote connection is checked then go to each server (Node) control panel...