SQL Server 2016 - Administration

• Topics

  Started by

  Posts

  Last post

• How can Resolve mutating trigger error without change my Logic:

  The Oracle mutating trigger error occurs when a trigger references the tab…

  kailashIndia

  1 replies

  8 years, 12 months ago

  By: Phil Parkin

• Availability group listener permissions

  All, I'm trying to add the first listener to a new AG using SSMS. I'm using the name bi-sql2016-agl…

  as_1234

  5 replies

  8 years, 12 months ago

  By: as_1234

• SQL 2016 Standard Edition maxmemory utilization

  To save licensing costs, we're planning on migrating a SQL 2014 ENTERPRISE instance w/ 768 GB RAM -…

  Express12

  1 replies

  8 years, 12 months ago

  By: Gail Shaw

• SQL Server 2017

  Have SQL server 2017 officially released or not?From Microsoft site, I can see there is SQL server …

  sqlfriend

  11 replies

  8 years, 12 months ago

  By: Alan Burstein

• Import question

  I am importing data from a 3rd party system into a DB that I am going to use for reporting.  I…

  jeremy.schillinger

  5 replies

  9 years ago

  By: Thom A

• Can't Shrink TEMPDB

  Hi All, I am getting an odd error when trying to shrink tempdb a little bit DBCC SHRINKFILE: Page 7…

  alex.sqldba

  14 replies

  9 years ago

  By: alex.sqldba

• How to delete clear space on the drive that DB's and Cubes are being backuped up to?

  Hello, Is there something in SSMS that I can use to clean up the backup directories? Like the way I…

  quinn.jay

  1 replies

  9 years ago

  By: gerald72

• CPU,Memory,IO,disk usage according to Database montly or weekly or daily report in sql server 2016

  hi all,how to get the usage of CPU,Memory,IO,disk usage according to Database montly or weekly…

  Ivan Mohapatra

  2 replies

  9 years ago

  By: Chris Harshman

• SQL 2016 link server

  Our environment requires that I create a link server from SQL to Oracle. The current production sys…

  shusta

  7 replies

  9 years ago

  By: shusta

• Error moving log.ldf

  Hi all, Tried moving log.ldf to another drive but hit error. Script and error as below... ALTER DAT…

  Riic

  17 replies

  9 years ago

  By: gerald72

• Scripting out schema permissions

  Hi all Help please!   Why does it seem so complicated to script out schema permissions i…

  doodlingdba

  7 replies

  9 years ago

  By: Perry Whittle

• How to go about testing your network for an AlwaysOn implementation

  Hi allSo i'm taking my first steps into deploying an AlwaysOn solution at my company. I've set it u…

  doodlingdba

  5 replies

  9 years ago

  By: Perry Whittle

• Installing SQL Server 2016 Fail-over Cluster

  Hi, We have 2 node fail-over cluster of SQL Server 2012 in our production environment.   Now w…

  arifulhaq

  1 replies

  9 years ago

  By: Perry Whittle

• Upgrade to 2016 questions

  All, Unfortunately we are still running a SQL server 2000 server. I've got provisional approval to …

  as_1234

  18 replies

  9 years ago

  By: Eirikur Eiriksson

• SSMS 17.2 connecting to Sql 2016 Integration Services

  I am having a problem that looks like a bug in this version of SSMS, and so am trying to find a dow…

  ManicStar

  3 replies

  9 years ago

  By: Beatrix Kiddo