kpwimberger (4/6/2012)

---

Thanks SS:

That makes sense. But what can be done about the loop issue, then? It seems to me that the call to:

UPDATE #temp SET Processed = 1 WHERE Foo...

I am running the verify now...will post back when complete.

When was the last time...

The key behind your trouble is the misunderstanding of the concept of a batch separator A batch separator is not a T-SQL concept, it is a data client concept. In...

.

Create some test data:

IF OBJECT_ID(N'dbo.GroupConcatTestData') > 0

DROP TABLE dbo.GroupConcatTestData ;

GO

CREATE TABLE dbo.GroupConcatTestData

(

DocID INT NOT NULL...

shiv-356842 (4/6/2012)

---

Hi Team

any help and suggestions on this below . Thanks for your valueble suggestions

USING policy based management.

CONDITION :-

"Looks at the last successful checkdb run and fails if it isn't...

Perry Whittle (4/6/2012)

---

No, commonly you would just simply add different port assignments to the TCP\IP address to target database conections...

Sure, configuring additional endpoints is common when...

Jeff Moden (3/31/2012)

---

Back on subject and call it what you will... Can anyone think of a reason for having a "loop-back FK" that isn't there to support and constrain...

When you have the SSIS package open in BIDS, right click some empty space on the Control Flow design surface and choose Package Configurations. From there you can choose XML...

On Server 2008 R2:

Log into a different server on the same network as your frozen server, open the Remote Desktop Services Manager (under Administrative Tools), connect to the frozen server...

A change to the ALLOW_SNAPSHOT_ISOLATION database option will not appear in the default trace. A message will however appear in the error log reflecting that the database option was changed,...

SQLRNNR (4/5/2012)

---

opc.three (4/5/2012)

---

SQLRNNR (4/5/2012)

---

Minnesota - Viking (4/5/2012)

---

My question in other words is To configure the SQL Server Database Engine to listen on an additional TCP port, should one MUST...

Was this your more general post?

SQLRNNR (4/5/2012)

---

Minnesota - Viking (4/5/2012)

---

My question in other words is To configure the SQL Server Database Engine to listen on an additional TCP port, should one MUST go through...