did you want this alert to fire on the principal?

what was the reason the failover occured?

how long did the failover take?

and the alert seems a bit off... you are querying...

sounds like the stored procedure might be using linked servers. you might want to check what security the linked servers are using.

i suppose you could on your VM server, edit the host file to trick the UNC path with DNS.

when your testing is done, remove the host file entry.

assuming the batter (the utility man) is right handed, you signal to swing at the inside pitches only.

that will drive the ball down the 3rd base line for a single.

Once...

http://blogs.iis.net/rakkimk/archive/2008/04/16/how-to-configure-iis-7-0-for-odbc-logging.aspx

no

with standard edition, you would have to "failover" manually.

the connection strings that the app uses would either need to be changed then or you can make use of the feature...

when you failover because of a hurricane, the recovery database comes online.

the app they use to connect to the database would have to be given the new instance name to...

you say the other server in another state is for DR.

why would you use replication? database mirroring could provide DR for you across the WAN.

do users in the DR state...

With IIS 7.0' , it's super easy because you can choose a data sources to do this. It's a setting you have to install, but it's very straight forward.

With IIS...

Jeff Moden (5/15/2012)

---

Absolutely no problem there, Geoff. I actually feel dwarfed by your knowledge of SQL Server in many areas especially on the system side.

Yeah, I remember all the...

E:\SQL_DATA is not a share.

make sure your SQL_DATA share is accesable to the service account that is running SQL.

you could try this;

DBCC TraceOn(1807);

GO

that will enable using UNC paths in SQL.

then create a folder on your E: drive called SQL_DATA

share the folder

then try to create your database with UNC...

you need to create an ODBC connection to your local sql instance.

Start --> Run

in the Run box, type odbccp32.cpl

click Add

Choose SQL Server

Name it Shared Memory

leave description blank

in the Server box,...

if you are using SSMS, you can just choose "Results to" --> Results to File. you right click on the TSQL window to see that.

or, you use sqlcmd

sqlcmd -Q "SELECT...