Administration - SQL Server 2014

• Topics

  Started by

  Posts

  Last post

• recursive sp_spaceused query

  I have a few servers and approx. 40 DB's per server... I'm trying to determine the size of all DBs …

  Tava

  5 replies

  9 years, 12 months ago

  By: Tava

• only select, view definition on schema, but otherwise grant alter on database

  For a given role 'dev_role', I'm trying to be restrictive to SELECT and VIEW DEFINITION for a parti…

  jjturner

  6 replies

  10 years ago

  By: jjturner

• Can Always On AG substitute a SQL Server Failover Cluster

  Hi , We currently have a SQL Server Failover Cluster and they want implement Always On availability…

  APA0876

  12 replies

  10 years ago

  By: Grant Fritchey

• SSRS Expressions background color

  Good day experts, i have a task to set back ground color to my table.the conditions are if Column L…

  tmmutsetse

  2 replies

  10 years ago

  By: tmmutsetse

• Can I just move 1 table to RAM disk?

  Hello, Unfortunately, we only use SQL Server 2014 Standard Edition, we can't use the memory optimiz…

  onlo

  10 replies

  10 years ago

  By: TheSQLGuru

• OLE DB provider "SQLNCLI11" for linked server "linkedserverIP" returned message "No transaction is active.".

  Hi experts while debug code getting error Distributed Transaction like the one below across the l…

  jamessdba

  1 replies

  10 years ago

  By: johnwalker10

• Uninstall SQL Server 2014 SP1 CU6 asking for SSMS CD-ROM

  During the uninstallation of CU6 in a test environment, I received a prompt to insert the 'SQL Serv…

  chris.young

  1 replies

  10 years ago

  By: rvsc48

• Client connectivity - forced to the Secondary-Redeable replica.

  Hi guys!... I'm implementing SQL Server 2015 Enterprise on my actual client, using Always On Avail…

  juanc.aguirre

  2 replies

  10 years ago

  By: juanc.aguirre

• SSRS Expressions background color

  Hi Experts I have a column 'LastFullBackup' that i want to set background color if Last full back…

  tmmutsetse

  2 replies

  10 years ago

  By: tmmutsetse

• sp_helptext returns There is no text for object on a Stored Procedure

  When I execute sp_helptext on a Stored Procedure it returns that there is no text for object on a S…

  Welsh Corgi

  11 replies

  10 years ago

  By: Sean Lange

• Home SQL Server - Do I need a Graphics card if I opt for 64GB RAM?

  Hi, I am finalising my home Desktop PC, mainly for SQL Server DB, BI and Visual Studio, Azure cloud…

  etl2016

  10 replies

  10 years ago

  By: etl2016

• Client Tools Connection Issues

  Good Day All I have recently started tests with SQL 2014 and Security to only allow the TLS1.2 Conn…

  Snakeyes

  2 replies

  10 years ago

  By: Snakeyes

• It could be attained with even more cost effective supplements.?

  Perfect Biotics [/url]consist of 15 sorts of finest bacteria crucial for a good gut wellness. It in…

  bessykendi9

  1 replies

  10 years ago

  By: Sean Lange

• It is not meant to identify, alleviate, treat, or avoid any type of disease.?

  Nucific Bio X4[/url] is called a 4 in 1 Weight Management Probiotic. It consists of 4 combined comp…

  bessykendi9

  1 replies

  10 years ago

  By: Sean Lange

• Error converting data type nvarchar to numeric.

  Hi Experts, I have a stored proc below that i am trying to execute via sql server agent job.The job…

  tmmutsetse

  3 replies

  10 years ago

  By: tmmutsetse