Apparently if you just use SSMS from the subscriber (SQL 2012) side, you won't get the error:

http://www.keepitsimpleandfast.com/2013/07/the-selected-subscriber-does-not.html

Thanks for that link, it's really interesting. The DBCC in question that was hung was master, and iirc it was on checktable.

I haven't tried with any others...

It sat for 13+ hours. I don't have trended info on how busy this particular server is yet.

It's possible for the reporting services service to be installed on another machine (webserver) and the databases to be hosted on your database server. If you patch your db...

I've done a lot of cut overs like this using both mirroring or log shipping. Both work just fine, it's really just a matter of what you're most comfortable...

Eric M Russell (5/2/2013)

There is a database option called AUTO_UPDATE_STATISTICS_ASYNC that may help in your situation.

http://weblogs.sqlteam.com/tarad/archive/2008/06/16/Asynchronous-Update-Statistics.aspx

Alternatively, consider turning off Auto Update of Statistics database option, and then schedule a...

Let me rephrase. I'd like to determine the cost benefit of each statistic on my table. If it's costing a lot to maintain the statistic and not frequently...

I've found attaching an XML file as an attachment via sp_send_dbmail very troublesome.

I did this with WhoIsActive which is probably a little more complicated than you need.

http://jonmorisissqlblog.blogspot.com/[/url]

Basically the way I...

There's another version of the 2012 installer that comes pre-loaded with SP1 (SQL_Svr_..._Edition_2012_w_SP1). It might be worth trying in case it's an installer issue that was fixed in SP1.

Could be this again:

http://kb.vmware.com/selfservice/microsites/search.do?language=en_US&cmd=displayKC&externalId=1012225

More info here:

http://jonmorisissqlblog.blogspot.com/2013/04/event-id-7000-sql-serverservice-failed.html

http://www.sqlservercentral.com/Forums/Topic1300021-2799-2.aspx

http://social.msdn.microsoft.com/Forums/en-US/sqlsetupandupgrade/thread/a576aa0e-5a08-4c9c-a583-af1815cd8b8e/

N/M

+1 for http://kb.vmware.com/selfservice/microsites/search.do?language=en_US&cmd=displayKC&externalId=1012225

Thank You!

I tried running "Extract Event Data..." from the trace and there's certainly additional information in the resulting xdl file.

I wonder if there's a bug in the UI?

Oh, well... I guess it was just too fast for me to believe 🙂

have you tried this?

It was my first Google result

http://social.msdn.microsoft.com/Forums/en-US/sqldocumentation/thread/8d6b5603-e030-4c6d-9872-afe4741a7d16/