Administration - SQL Server 2014

• Topics

  Started by

  Posts

  Last post

• How to provide full alter permissions on a db

  How to provide full dml/ddl permissions on a db (all schemas,all objects including [dbo]) with out …

  SQL!$@w$0ME

  19 replies

  9 years, 10 months ago

  By: SQL!$@w$0ME

• Grant permissions to truncate one table in a db with out proving DDL_Admin rights

  How do I provide permissions to truncate one table in a db without giving DDL_Admin rights?

  SQL!$@w$0ME

  4 replies

  9 years, 10 months ago

  By: SQL!$@w$0ME

• "Antiquated" SQL Server Backups

  I'd like to get some opinions from my fellow SQL Server professionals on backup software. I'm getti…

  KJP

  34 replies

  9 years, 10 months ago

  By: anorhoads

• Trace SQL Alert

  Hi, How do I trace alerts coming from unknown AD account from SQL Server ? Thanks, PSB

  PSB

  6 replies

  9 years, 10 months ago

  By: SQLSlammer

• query take to much time to run

  Hi All, I have total 460 million row in the table. I am running query for year 2016 and month = 7 a…

  patla4u

  4 replies

  9 years, 10 months ago

  By: TheSQLGuru

• Always On and applying Service Packs and CUs.

  Question for the group. We just setup a new SQL 2014 SP1 system with two servers and have all of th…

  Summer90

  14 replies

  9 years, 10 months ago

  By: Summer90

• AlwaysOn and DB Mirroring

  All, We have 2 node cluster in data center A where we configured AlwaysOn. In data center B we have…

  pawana.paul

  4 replies

  9 years, 10 months ago

  By: Thomas Rushton

• SQL DB and App server on seperate domains

  Hello Guys, Is there any issue if SQL db and app servers are on separate domains? Any best practice…

  SQL!$@w$0ME

  6 replies

  9 years, 10 months ago

  By: SQL!$@w$0ME

• Read Only Routing Problem

  Evening All, Here is my ongoing AlwaysOn/Availability/Read Only Routing problem: Please note I have…

  alex.sqldba

  5 replies

  9 years, 10 months ago

  By: Perry Whittle

• create table on partitioned database takes a long time

  Hi all! A developer came to me today with a problem they want me to solve... they have a server whe…

  jCoke

  7 replies

  9 years, 10 months ago

  By: Grant Fritchey

• Get error when attempting to Configure Distribution on a SQL Server 2014 Machine

  I Get the following error when attempting to Configure Distribution on a SQL Server 2014 Machine …

  Welsh Corgi

  4 replies

  9 years, 10 months ago

  By: Welsh Corgi

• Estimated Query Plans

  Hi, First post. When viewing an estimated query plan for a stored procedure with multiple query sta…

  SilentOne

  1 replies

  9 years, 10 months ago

  By: SilentOne

• SQL Server 2014 setup.exe does nothing

  SQL Server 2014 setup.exe does nothing and unable to move towards to install SQL installation

  k2000.rajesh

  5 replies

  9 years, 10 months ago

  By: mister.magoo

• How can i get data from informix in schaduled

  Hi we have an informix server and I want to get data from it in every 5 seconds. what is the best s…

  MotivateMan1394

  1 replies

  9 years, 10 months ago

  By: MotivateMan1394

• Issues etting up Central Management Server Target

  Im getting the following error when trying to setup some machines as target for CMS. It works for o…

  coreyjbaum

  1 replies

  9 years, 10 months ago

  By: coreyjbaum