SQL 2012 - General

• Topics

  Started by

  Posts

  Last post

• Excessive tempdb space required for DBCC CHECKDB?!

  Hi, We have stubborn 1TB database that is requiring a lot more tempdb space than the other database…

  ahenderson

  10 replies

  1 year, 3 months ago

  By: Priyanka Chouhan

• Master database in Single_User mode

  Everything I read and even a test tells me that you can't put master into Single_User mode. So can …

  Leo.Miller

  1 replies

  1 year, 4 months ago

  By: Mr. Brian Gale

• ID increment problem (Sql Server 2012)

  Good morning, I don't understand what's going on in my database all tables that have an auto-increm…

  Alaoui Mohamed Moctar

  3 replies

  1 year, 4 months ago

  By: Alaoui Mohamed Moctar

• The target princial name is incorrect. Cannot generate SSPI context.

  I've just created new certs, new SPNS and applied via SSCM. Within AD I've ticked trust this user f…

  jessymcjessface

  3 replies

  1 year, 4 months ago

  By: rothj

• The target princial name is incorrect. Cannot generate SSPI context.

  I've just created new certs, new SPNS and applied via SSCM. Within AD I've ticked trust this user f…

  jessymcjessface

  3 replies

  1 year, 4 months ago

  By: Emperor100

• Is it required to add firewall Exception for LocalDB seperately

  I have set up the required firewall exception rules for SQL Server Express to function properly. Do…

  IT researcher

  1 replies

  1 year, 4 months ago

  By: Grant Fritchey

• SQL Server Data Collector

  Hi, I wanted to ask: I have many servers in my company and those server is in different instances a…

  iamsleepy

  3 replies

  1 year, 5 months ago

  By: Grant Fritchey

• DQS (Data Quality Services) - Why Use DQS versus T-SQL Code to Cleanup data

  I've been reading about DQA (Data Quality Services) in SQl 2012 and even installe dit and played ar…

  YSLGuru

  1 replies

  1 year, 5 months ago

  By: Kev

• Can I install SQL failover on a single node WSFC cluster?

  For depressing reasons, I'm installing 2012. Don't ask.  For some other reasons I've had to create…

  jessymcjessface

  3 replies

  1 year, 5 months ago

  By: jessymcjessface

• How to capture sqlscript from a specific computer while using sqlserver profiler

  There is a web-based oa system, it has an IIS application server(OA was deployed on this IIS applic…

  892717952

  7 replies

  1 year, 7 months ago

  By: Jeff Moden

• SSL Certificate

  Hi.. SSL certificate has been installed in our standalone and cluster servers . and from Registry E…

  WhiteLotus

  1 replies

  1 year, 8 months ago

  By: WhiteLotus

• Getting Max Date with Join Statement

  I am trying to get the max PRM_StartDate from the query below but unsure how to format the query. …

  MP-iCONN

  10 replies

  1 year, 8 months ago

  By: MP-iCONN

• Fixing a mismatched collation on MSDB

  Hi, I've been tasked with finding out why we've been unable to patch the SQL server on our SCCM ser…

  NoDowt

  5 replies

  1 year, 9 months ago

  By: Jo Pattyn

• Bcp queryout issue

  Hi all, I am running the following query in SQL, trying to export some data to a csv file, with hea…

  kakovatos7

  5 replies

  1 year, 9 months ago

  By: kakovatos7

• Strange 'Bug'(?) with SQL Native Client 11.0 and MultiSubnetFailover

  Hi, I have a SQL Server Multi Subnet cluster across Data Centres. Yesterday I set up an availabilit…

  dbamohsin

  1 replies

  1 year, 10 months ago

  By: shawn