Tag Info

New answers tagged


If you are using a system which having credentials managed by an active directory server, the issue seems to be your sql server credentials are not synchronized with active directory credentials go to services ....> open all sql related services there should be five total. change the credentials shown there to your active directory credential. apply and ...


I'm a little late to the party, but here's a version that uses DMVs rather than the deprecated system tables and allows for arbitrary schema names. It enables or disables row or page compression on all heaps, clustered indexes and nonclustered indexes (including all partitioned tables) in the current database: -- Enables or disables compression on all ...

Top 50 recent answers are included