Administration - SQL Server 2014

• Topics

  Started by

  Posts

  Last post

• Application Name from Profiler

  Hi Experts, Trace result is giving application name in hexdecimal values like below. How to find th…

  VastSQL

  7 replies

  8 years, 2 months ago

  By: Gail Shaw

• Database too big than .bak

  Good day,I have a DB which is 850 GB in size and when i take a full backup the backup size is 160 G…

  tmmutsetse

  12 replies

  8 years, 2 months ago

  By: andreas.kreuzberg

• SQL Server Login Failures

  Hi, I can see Login Failures as below in SQL Error Logs in our production servers, but the database…

  G Sunny

  3 replies

  8 years, 2 months ago

  By: G Sunny

• Backing up to UNC path

  I'd like to backup my databases to a UNC path.  IE - \\servername\share1\.I'm a bit confused a…

  jackimo

  7 replies

  8 years, 2 months ago

  By: Steve Jones - SSC Editor

• Cant stop sql server

  I couldn't add databases, so I attempted to give myself the privilege.  It wouldn't let me.&nb…

  wperciful

  3 replies

  8 years, 2 months ago

  By: Chris Harshman

• Add dcCreature rights

  IT at work installed SQL Express 2014 on my machine but I dont have the ability to add a new d…

  wperciful

  6 replies

  8 years, 2 months ago

  By: wperciful

• Delete old backup files

  I am wondering if someone can help me out here. We have backups in place but since we don't have re…

  NewBornDBA2017

  9 replies

  8 years, 2 months ago

  By: NewBornDBA2017

• Database Restore Failing

  I am hoping you can help me out here.  SpecificationsSQL Server 2014 SP2 CU8Windows Server 201…

  jayoub

  17 replies

  8 years, 2 months ago

  By: Michael L John

• SMART CARD Authentication

  I am running SQL Server 2014 SP2 CU8 on Windows Server 2012.  The network team enabled “Smart…

  jayoub

  2 replies

  8 years, 2 months ago

  By: jayoub

• Move queries from Access to MS SQL Server

  Hi Guys, i have query  in Access like here: Now i want to build something similar in MS SQL S…

  jaryszek

  2 replies

  8 years, 2 months ago

  By: Eirikur Eiriksson

• Linked Server to MS Access confirms connection succcess, but errors out on expanding catalog

  Title says it all really. I've included the basic script, attached is the extended properties and e…

  rtrim(ltrim(' '))

  7 replies

  8 years, 2 months ago

  By: Sue_H

• who is sysadmin

  I am trying  to find out which of the logged on users are sysadmin, what am I doing wrong, the…

  goher2000

  15 replies

  8 years, 2 months ago

  By: Jeff Moden

• Need Advice About Synchronizing Logins/Database User And Permissions

  I am investigating setting up log shipping for sql server 2014 for a primary and single secondary.&…

  ceciliarenebaker

  4 replies

  8 years, 2 months ago

  By: ceciliarenebaker

• H‌ow can SQL server be configured automatically to adapt network failover between servers on different domain ?

  Transaction replication delivering data to third party on different domain.  Network admi…

  LearnSQL!!!

  2 replies

  8 years, 3 months ago

  By: LearnSQL!!!

• What is faster? Creating calculated field within table or creating calculated fields within query?

  Hi,  what is faster? Best,Jacek

  jaryszek

  16 replies

  8 years, 3 months ago

  By: Jeff Moden