Administration - SQL Server 2014

• Topics

  Started by

  Posts

  Last post

• Confuse about transaction log, truncation and UNDO management

  Dear gurus and all, Coming from an oracle background, please correct me if i am wrong as I just can…

  szejiekoh

  12 replies

  9 years, 10 months ago

  By: szejiekoh

• Send a notification when a backup is succesful or failed

  hi i am sing a stored procedure in order to backup my DBs. then i shedule it in a job . in order to…

  gxdatareal

  2 replies

  9 years, 10 months ago

  By: Neil Burton

• Is there a better way to run SSIS packages on-demand?

  Currently, we have several applications which use SSIS packages that need to be called on-demand. …

  jasona.work

  3 replies

  9 years, 10 months ago

  By: jasona.work

• Disabling SA better than Changing Password?

  Auditors have been wanting us to change the password on the SA sql id on a scheduled basis. Someon…

  David Bird

  1 replies

  9 years, 10 months ago

  By: Steve Jones - SSC Editor

• Default constraints OR INSERT trigger for Audit columns (create date time/user)

  Which is the best practice to implement in audit columns for create datetime and create user, INSER…

  SQL!$@w$0ME

  28 replies

  9 years, 10 months ago

  By: Eirikur Eiriksson

• Connect SQL Server 2014 named instance

  I would appreaciate some help for this connection issue: I cannot connect to a server with "SQL Ser…

  yan-160997

  8 replies

  9 years, 10 months ago

  By: yan-160997

• User shouldn't be able to run but can in production

  HI, I have a user that an A/D account that has no access to a production DB. But I caught that user…

  krypto69

  18 replies

  9 years, 10 months ago

  By: crmitchell

• same old question - login and user , default database and privileges

  Hi all, I understand the difference between a login (at instance level) and a user at database leve…

  szejiekoh

  3 replies

  9 years, 10 months ago

  By: Bill Talada

• ad-hoc backup of some DBs on disk G of mssql_db using A job

  Hi every day we are taking ad-hoc backup on disk G of mssql_db for the following DBs •A_MSCRM •…

  gxdatareal

  3 replies

  9 years, 10 months ago

  By: Jeff Moden

• AlwaysOn listener problems

  I've set up a listener to my AlwaysOn group on port 5023. We'll call it 'DB_Lstnr'. The port is un…

  cmoy

  3 replies

  9 years, 10 months ago

  By: cmoy

• Update Trigger - Keep Old value unchanged for a column

  using UPDATED and DELETED temp tables, how can I override the new value and keep the old value for …

  SQL!$@w$0ME

  16 replies

  9 years, 10 months ago

  By: Jack Corbett

• How to Move MS SQL Cluster to Standalone

  Hi We need to move MS SQL Cluster to Standalone SQL Server, what are the steps we need to follow &#…

  Harshana-455711

  9 replies

  9 years, 10 months ago

  By: EdVassie

• Patching SQL Server - General

  Hi all, I have never been a software developer and to be honest, branching and subversioning are no…

  szejiekoh

  2 replies

  9 years, 10 months ago

  By: SeniorITGuy

• roughly :Server groups or single server and database groups

  Hey folks, I know this topic might sound rough , but I though this could open up a great discussion…

  afshari.benyamin

  3 replies

  9 years, 10 months ago

  By: Steve Jones - SSC Editor

• SQL Service Account (Local or network or domain) ?

  Hi, I have installed SQL Server 2012 on standalone server. Please let me know which under which acc…

  nikhil.desai1

  2 replies

  9 years, 10 months ago

  By: Jon.Morisi