Administration - SQL Server 2014

• Topics

  Started by

  Posts

  Last post

• Arithmetic overflow error converting IDENTITY to data type int - int to bigint questions

  Hi, I recieved this error: Arithmetic overflow error converting IDENTITY to data type int I believe…

  krypto69

  1 replies

  8 years, 4 months ago

  By: Ant-Green

• Server Side SSL SQL Network Encryption - selfsign cert - why is it working ?

  Hi all, In BO, it is emphasize that using self-sign cert promotes MITM attacks and we should use CA…

  szejiekoh

  4 replies

  8 years, 4 months ago

  By: Ed Wagner

• High Memory consuming by Database

  Hello Everyone, I have a database which size is 250 GB and it contains the information about 70 Lak…

  amitsingh308

  12 replies

  8 years, 4 months ago

  By: Gail Shaw

• Error in Trigger

  I'm trying to devise a way to run a PowerShell script from a job when changes are made to  pro…

  lmarkum

  5 replies

  8 years, 4 months ago

  By: lmarkum

• Authentication KERBEROS and NTLM

  I have 2 SQL Server 2014 databases on 2 servers DB1 = auth_scheme KERBEROSDB2 = auth_scheme NTLM I …

  prestowd-sql

  7 replies

  8 years, 4 months ago

  By: Mr. Brian Gale

• Log Shipping Instance TempDB Allocation

  We have log shipping instance setup, should the log shipping instance have the same number of tempd…

  LOOKUP_BI-756009

  4 replies

  8 years, 4 months ago

  By: Arsh

• Best practice for user created database log file autogrowth settings

  hi, Please let me know, what is the best practice for user created database log file autogrowth set…

  annamsiva.dba

  3 replies

  8 years, 4 months ago

  By: Arsh

• Unable to restore the DB.

  I am creating a new database from the backup I have. It has been running for half an hour now but s…

  NewBornDBA2017

  5 replies

  8 years, 4 months ago

  By: Arsh

• anybody know what this view is? sys.spt_sproc_columns_odbc_view

  HI, I am looking into a CX packet wait issue - so I ran sp_blitz. The results showed that this vie…

  krypto69

  2 replies

  8 years, 4 months ago

  By: Arsh

• Create empty AlwaysOn Availability Group

  Hello SSC, My ideal process for a new Availability Group install would be to:1) Create the Availabi…

  icester

  2 replies

  8 years, 4 months ago

  By: icester

• How to set memory if have multiple sql instances on same box?

  Hi All, Question on SQL Server Memory Configuration. Not looking for in-depth capacity planning but…

  vsamantha35

  4 replies

  8 years, 4 months ago

  By: vsamantha35

• Rebuilt SQL Server 14 system databases, not functioning, pointing at non-existent files

  I rebuilt system databases for a SQL Server 2014 installation. The server will still not restart, i…

  MikeGale

  8 replies

  8 years, 4 months ago

  By: MikeGale

• disable Guest accounts

  Hi, can someone share scripts to disable Guest account in all the databases at same time.  hav…

  Aatish Patel

  4 replies

  8 years, 4 months ago

  By: Sue_H

• SQL Merge Replication Error

  Can anyone please help me out to solve this error in SQL Server merge replication? The merge proces…

  ahsanmumtaz

  2 replies

  8 years, 4 months ago

  By: ahsanmumtaz

• Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON' - Linked Server

  I'm setting up a linked server connection from SQL Server 2014 instance "301" to SQL Server 2014 in…

  TheGreenShepherd

  4 replies

  8 years, 4 months ago

  By: Joie Andrew