Whichever port the remote instance is listening on, it's just an outgoing connection...

Views maintain their formatting when created/altered like any other object. Is this a problem with how they're being applied in your deployment process/stored in Source Control?

I don't believe you can use a local temp table to populate a results table for sp_send_dbmail as it runs in a different SPID asynchronously.

You need to either use a...

You could move them to a (3rd) centralised location I suppose, but I don't see why that's a better solution than what you've already done, which I'd say was the...

Could you post the full error message?

There's a connect item related to restoring a SQL 2008 database using SSMS 2012 GUI, which posts an erroneous error message about LSN chain...

Roughly speaking, like the following (untested):

SELECT MTG_QCA = CASE WHEN ttss_avgeqcapointscore < 1 THEN 0

...

But when I add the option WITH SCHEMABINDING I got a error. I think I can't create aa view with schemabinding option because I try to make a view between...

It's definitely do-able and AlwaysOn can be a HA solution as well as a DR.

Remember that switch-over is not completely seamless and users will get disconnected (same with clustering), so...

Has the service account got rights for Instant File Initialisation?

http://technet.microsoft.com/en-us/library/ms175935(v=sql.105).aspx

David Burrows (8/29/2013)

---

So you'd think, but Amazon has...

Pretty simple:

DECLARE @units int=177

SELECT LEFT(DATEADD(MINUTE,@units*6,CONVERT(TIME,'00:00')),5)

That PK = Clustered Index

Another option:

DECLARE @units int=177

SELECT DATEADD(MINUTE,@units*6,CONVERT(TIME,'00:00'))

Steve Jones - SSC Editor (8/22/2013)

---

True, but this is native in SQL 2012 (And R2, IIRC), so MS recognizes that technologies have advanced and this is not necessarily a problem....

Procmeister (8/21/2013)

---

I can hardly believe that the data and log files can be on a UNC Pathname, but not the Filestream.

I am incredulous!!! Is there some other trace flag that...