SQL Server 2016 - Administration

• Topics

  Started by

  Posts

  Last post

• SSRS Browser Role can edit Security

  Hello, In my 2016 SSRS instance, anyone is able to edit security on items. I had a user modify a da…

  Jim

  1 replies

  6 years ago

  By: Jim

• Database diagrams not showing in-memory table

  With SSMS 18.3.1, I try to build a database diagram.  The tables it finds do *not* include any in-m…

  g.britton

  2 replies

  6 years ago

  By: g.britton

• The mystery of SQL Memory

  Hi All, In server 2012 and 2016 , SQl error logs show this error message : "AppDomain is marked for…

  WhiteLotus

  6 replies

  6 years ago

  By: WhiteLotus

• Is all transactions in one cursor treated as one transaction?

  The client need to update a big table. the UPDATE will be done in the application and the applicati…

  Siqing LU

  6 replies

  6 years ago

  By: Jeff Moden

• Data drive

  Data drive is full not the log space. If it is ldf then yes, full recovery model with more frequent…

  Admingod

  4 replies

  6 years ago

  By: Jeff Moden

• I can't Uninstall SQL Server 2016

  Hi, I have SQL Server 2016 installed in my machine but I can't uninstall it, it doesn't appear on m…

  sirkinghorse

  3 replies

  6 years ago

  By: VoldemarG

• Read only node consistency

  I realize this is a reach, users stating that some of their data is missing from RO ag node, not th…

  tcroninlifepoint

  2 replies

  6 years ago

  By: SQL_Hacker

• How to find executed query

  Hi, I have a requirement where I have to find what was the last recent executed query on certain us…

  sizal0234

  9 replies

  6 years ago

  By: sizal0234

• SQL Server Pivot Table on two columns renaming one column

  I've the following source table: --------------------------------------------------------------- | …

  Dinosaur

  4 replies

  6 years ago

  By: Dinosaur

• can I use Stretch database to migrate the database to azure.

  HI Guys,   can I use Stretch database to migrate the database to azure.? how ?

  goher2000

  2 replies

  6 years ago

  By: prettsons

• Need Help formatting query to pull date-related data from Table

  I need help correctly formatting the following query to pull some date-related records: This is for…

  bkufleitner

  5 replies

  6 years ago

  By: bkufleitner

• tempdb full

  My tempdb id getting full frequerntly , i need to find the spid which is causing  tempdb full?

  ramyours2003

  2 replies

  6 years ago

  By: muthukkumaran Kaliyamoorthy

• Failed to initialize sqlcmd library with error num -2147467259. [SQLSTATE 420000

  Hi Guys, I am getting below error when i am trying to  send the CSV report thru database mail. The …

  prem.m38

  1 replies

  6 years ago

  By: prem.m38

• Disabling RC4 and DES in win 2012

  Hi, The customer have SQL production servers n windows 2012. They came with the question will there…

  pols

  2 replies

  6 years ago

  By: Steve Jones - SSC Editor

• SSRS 2016 Subscription File Share Option Doesn't Exist in Dropdown

  Hi all, Having trouble finding anything specifically on this issue. Previously I have always had th…

  dlsql

  1 replies

  6 years ago

  By: dlsql