so what is the current state of the principal is it still connected?

Post the results of the following please against the principal instance

select * from sys.database_mirroring

It...

n00bDBA (10/26/2012)

---

Hi all,

Is it possible to list out all the tables/SP in a database and if a role has a GRANT on it what it allows...

I cant find...

I saw an advert for a contract here in the UK only last week and the agency stated

Now, remind me, what...

You're welcome. I guessed that's...

There is a recovery path that has occurred but not been synchronised by log shipping. What does the following return when run against the new mirror principal instance and the...

distas (10/25/2012)

---

Unfortunately, the rest of the comments made by other participants were just useless buzz, worse than they claimed my article to be. Nice, old, lame teenage-kind of attitude. Keep...

arkiboys (10/25/2012)

---

I can script the job in production.

In the script, I see the name for the production server.

On running this script in the mdr (mirrored server), do I change the...

bjcharles (10/25/2012)

---

Perry Whittle (10/25/2012)

---

Elizabeth.Block (10/24/2012)

---

I don't know much about transactional replication and we're going to implement this soon on a SQL Server 2008 Standard server. I'd heard that you can't...

Elizabeth.Block (10/24/2012)

---

I don't know much about transactional replication and we're going to implement this soon on a SQL Server 2008 Standard server. I'd heard that you can't create a snapshot...

arkiboys (10/25/2012)

---

How...

arkiboys (10/25/2012)

---

GilaMonster (10/25/2012)

---

If the mirroring is working, the data in the mirror DB will be correct. You could take a snapshot off the mirror and query that if you want.

SQL...

This is an improvement

selectOBJECT_NAME(i.object_id) AS TableName

, i.name AS IndexName

, FILEGROUP_NAME(i.data_space_id) AS FileGrpName

from sys.indexes i inner join sys.objects o

on i.object_id = o.object_id

where i.index_id = 1 and o.is_ms_shipped <> 1

and i.data_space_id...

You can only route your mail through google mail or windows live if you have a gmail or...

The listener has no concept of instance names, its a connection route into the AlwaysOn availability group. What details are you using to connect via the listener?