yep - both nodes are active

take a look at Robert Davis' blog post: http://www.sqlsoldier.com/wp/sqlserver/troubleshooting-atabasemirroringerror1418

for some reason it didn't like me starting it in single user mode via DOS. Starting it in single user mode via SSCM worked. Once connected via DAC...

Hi,

Yes - I've tried dropping the trigger.

Querying sys.dm_tran_locks brings back quite a few X and Sch-S locks for my trigger. I've tried killing the SPIDs, though twice as many...

CREATE PROC myproc

@param INT

as

begin

select @param, MAX(ID) from tab1 WHERE ID < @param

union

select ID, oldid from tab1 where ID < @param

end

IF EXISTS(

SELECT 'mydomain\' + sAMAccountName

FROM OPENQUERY

(ENTMASTER1,'SELECT cn, displayName, sAMAccountName

FROM ''LDAP://mydomaincontroller''

...

Koen Verbeeck (6/13/2012)

---

ako58 (6/13/2012)

---

The DAC port is assigned dynamically by SQL Server during startup. When connecting to the default instance, the DAC avoids using a SQL Server Resolution Protocol (SSRP)...

Gail - have you got a second SSC account called "Lowell"? 😉

Hi Guys,

I've used some of the valuable information posted for a new project I'm working on.

Just thought I'd share some lessons learned:

1) I've coerced management into SQL Server 2008 because...

Schadenfreude-Mei (5/21/2012)

---

Schadenfreude-Mei (5/21/2012)

---

Yes infact 820-Gigaquads is the p/s access speed of the main computer core in 1701-D. LCARS (Library Computer Access/Retrieval System) is...

personally, I disklike them, but synonyms... http://msdn.microsoft.com/en-us/library/ms177544.aspx

k.subramanyam1017 (5/21/2012)

---

Hi friends,

could u please any one tell me the these questions

1) what is your company file architecture and how much data u r handle.

2) how...

Hi,

Thanks for the reply

I have 2 servers; "ServerA" and "ServerB".

There is a linked server called "Link1" from ServerA to ServerB.

There is a linked server called "Link2"...

do you get any errors?

You're better off pre-allocating the space required for the data and log files. Growing data files/log files is a resource expensive operation, so you want...

Hi,

Thanks for the response.

I found your solution works, howerver, it's not quite how I'm trying to use it. In my procedure, if the stored procedure I run remotely fails,...