SQL 2012 - General

• Topics

  Started by

  Posts

  Last post

• FULLTEXT search

  Hi, I came across a FULLTEXT catalog that documents tables in a database. The catalog has 5 descrip…

  PiMané

  1 replies

  12 years ago

  By: PiMané

• ADODB Recordset Updating

  The following MSAccess VBA code worked well with SQL Server 2005, but produces an error with SQLSer…

  normturgeon

  1 replies

  12 years ago

  By: Sean Lange

• The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and common table expressions, unless TOP, OFFSET or FOR XML is also specified.

  Where can i place my ORDER BY statement to sort ALL the data from the table, not just the 'from' an…

  isuckatsql

  5 replies

  12 years ago

  By: isuckatsql

• "could not open error log file" on incorrect SQL cluster node

  Hi. We have 2-node SQL 2012 cluster running as VMs in Hyper-V. The cluster hosts 4 SQL instances, r…

  Rambler

  2 replies

  12 years ago

  By: Rambler

• Issue with AlwaysOn High Availability

  Friends, We are facing an issue with our DBs. We have configured AHA for couple of SQL Server Insta…

  MuraliKrishnan1980

  4 replies

  12 years ago

  By: michael.mcloughlin

• ssis vs jobs

  I just started as dba at new co. I'm looking over what the previous guy did. He has some ETL proces…

  Snargables

  6 replies

  12 years ago

  By: Koen Verbeeck

• Sql Server 2012 can't see 2nd drive

  I installed Sql Server 2012 Express. Everything went without a hitch until I attempted to create a…

  ml 66943

  24 replies

  12 years ago

  By: Fozzie

• Error in attaching Adventureworks 2012 database

  hi i have problem in attaching Adventure works 2012 database Attach database failed for Server '..…

  soni321

  12 replies

  12 years ago

  By: Koen Verbeeck

• how to solve this

  two tables table1 table2 StudentId studentid TestId …

  nikonlens50

  1 replies

  12 years ago

  By: Sean Lange

• Can I have SQL 2012 AND SQL Express 2008 R2 installed on the same machine?

  I'm looking at removing the SQL Server 2008 R2 Developer Edition that I have installed on my machin…

  Rod at work

  3 replies

  12 years ago

  By: Rod at work

• Output based on Mapping Table and Orders Table

  I have two tables, 1st Table is the Order Table which has order no,old items, price and their quant…

  vivekkam

  3 replies

  12 years ago

  By: vivekkam

• Failure Restoring Differential Backup

  I have an issue with my SQL 2012 database server and restoring a full backup (norecovery) then appl…

  cathy.baker

  7 replies

  12 years ago

  By: Erland Sommarskog

• Lazy Spool - What is causing it ?

  I removed the TOP, tried commenting out the WHERE, OR clauses, but cant seem to lose the Lazy Spool…

  isuckatsql

  3 replies

  12 years ago

  By: Gail Shaw

• SQL Server Enterprise Edition: Core-based Licensing (64-bit)

  Hi guys, I'm assuming the answer is NO, but I thought I would ask anyway... Some consultants came i…

  SQLBrady

  5 replies

  12 years ago

  By: SQLBrady

• AlwaysOn performance on Replica databases

  I am looking into AlwaysOn Availabilty Groups as both an HA and load spreading solution. But there …

  Thomas Mucha

  4 replies

  12 years ago

  By: Thomas Mucha