Thanks

Thanks

It works!

Can you give me a run-down of what is actually happening with this code?

Thanks

Thanks

I tried it but it still asks for a value for the FromPath parameter

Play around with this.

create trigger insert_trigger on trig

after insert as

if (select count (*) from inserted) > 1000000

begin

print 'some_message_here'

rollback

end

Not 100% sure about 2005 but I know that for 2008 you apply the update to the passive node, failover and then apply the update to the "new" passive node.

GilaMonster (2/3/2014)

---

No, the plan cache...

Locate SQL's ERRORLOG text file, you'll be able to get the location from the service.

Have a look through it, there should be a more descriptive message in the log.

I've had this happen but after a few seconds, it would connect or after a ipconfig/flushdns

Check the registry entries for you App for any reference to the server name instead...

I don't claim to be the expert on this topic so I will leave it at that. I do stand by what I am saying though, I could be wrong.

Hopefully...

Again.....

"When an FCI is joined to an availability group, the nodes within the FCI can fail over to each other automatically, but the availability replica on the FCI must manually...

No need to stop SQL at all

So, in the second query, all you're doing is using the schema_name.table_name?

What do the execution plans say?

Something like this:

SELECT QUOTENAME (OBJECT_NAME(i.id)), QUOTENAME (i.name),STATS_DATE(i.id, indid),rowmodctr,so.schema_id,SCHEMA_NAME (so.schema_id) Schemaname

FROM sys.sysindexes i

inner join sys.objects so on i.id = so.object_id

WHERE STATS_DATE(id, indid)<=DATEADD(DAY,-1,GETDATE())

AND rowmodctr>0

AND id IN (SELECT object_id FROM...

Did you log off from your remote desktop session?

Check the progress of the restore and whether or not it's moving with:

select command, percent_complete from sys.dm_exec_requests where command like '%RESTORE%'.

If...

Ford Fairlane (12/17/2013)

---

SQLSACT (12/17/2013)

---

Ford Fairlane (12/17/2013)

---

SQLSACT (12/16/2013)

---

Ford Fairlane (12/16/2013)

---

SQLSACT (12/12/2013)

---

Hi all

We are looking at implementing AlwaysOn AG combined with a Failover Clustered Instance of SQL Server. This is the setup:

>>...