No, you may have only 1 default instance. The rest would be named

you will need to throroughly test this, set the timeout via T-SQL

as Anthony said above really.

You could also use the stored...

Let's clear the confusion first, you mean mirror session not cluster

liteswitch (8/15/2012)

---

if the cluster is failing...

Manie Verster (8/15/2012)

---

I have log shipping set up on my database running on SQL Server 2012. It is scheduled to run Monday to Friday, 07:00 am to 17:00 pm. It...

Initially I would have said the login owns the database, double check and confirm this is not the case.

Has this database come from sql2000 at some point?

can you post a screenshot of what you see?

you need to instantiate the Urn[] collection before attempting to use it.

Revise the following

StringCollection sc = scripter.Script(new Urn[] {db.Urn });

SQLCrazyCertified (8/13/2012)

---

All,

I need help from all of you to put together a checklist for troubleshooting disk space issues. In our environment, we get a lot of tickets regarding space...

you're opening the SQL Server configuration manager program, correct?

the DTC is used by many applications including sql server. In SQL Server a dtc is used for remote transactions such as lnked servers and openrowset queries.

A clustered DTC is...

The installer configures all...

Your main issue was the syntax error in the calling script.

It won't hurt too much to use page count 8 in your script as your using the results to view...

that's as maybe, but the idea is to specify port or instance name. Both just serves to cause some people confusion

OK, now i'm worried 🙂

if you intend to...