I think you can probably set the compatibility mode to SQL server 2014 for all except forefront where it would be worth trying the software with SQL server 2014 and...

Hmmm, how hard did you try? these were the first links on google

https://technet.microsoft.com/en-GB/library/cc262485.aspx

https://technet.microsoft.com/en-gb/library/dn281933.aspx

http://discussions.citrix.com/topic/352967-supported-databases-for-citrix-products-sql-2014/

Forefront is the only one where I can't find whether it supports...

I would go the CU2 route first if I were you, I actually hadn't noticed the second page of comments when I wrote my reply.

You only need to rebuild the...

Probably the compression process

SQL Server profiler - I read that caveat as, you can profile the server from another machine that has either standard or enterprise. Not brilliant if you don't have any...

The main differences between Web and standard are:

Web has no BI / Analysis services

No support for clustering, replication, mirroring

Less options for Reporting services

No service broker

Backup compression

So unless you need these,...

Hello,

I had a similar issue when adding a database to a Always on availability group, it would cause an access violation and then crash dump.

Myself and my DBA manager were...

Thanks for the replies, there is no technical reason I want to do this, just for standardisation reasons really and me being a bit anal.

Good to know that they...

I hope this doesn't get viewed as a thread hijack..but TheSQLGuru.

If you are updating stats more than once week, at what point do you update stats with FULLSCAN? or do...

Thanks very much for your help 🙂

I had this a few times in the past where 3rd party applications have requested that the login be sysadmin, I told them where to go also.

Largely people request sysadmin...

Ok, does it matter that I have turned it on?

SanjayAttray (8/6/2009)

---

Schadenfreude-Mei (8/6/2009)

---

If anyone has the answer this would be useful. I have a 5gb msdb under sql2000. Not sure how it got that way but the thoughts are...

However I was using a smaller figure than 250mb for the dbcc shrink would this have affected it?

Not the log, the data

Hmmm ok well that worked...

Strange I had tried that a few times and it wasn't shrinking it, I wonder if the service re-start I did this...