SQL 2012 - General

• Topics

  Started by

  Posts

  Last post

• How to uninstall SSAS

  I've been tasked with uninstalling SSAS from our SQL Server 2012 instance and re-installing it with…

  gcresse

  5 replies

  7 years, 7 months ago

  By: Scott Stauffer

• The queue %d in database %d has activation enabled and contains unlocked messages but no RECEIVE has been executed for %u seconds

  I am getting below the message in error log every 1000 seconds on one of my instances where I have …

  Patrick Ge

  8 replies

  7 years, 7 months ago

  By: michael bourgon

• Grouping dates and IDs together

  I have what at first (and second and fifth) glance appears to be an impossible task. I have to take…

  Brandie Tarvin

  13 replies

  7 years, 7 months ago

  By: Brandie Tarvin

• how to find all stored procs using a table, but ignore comments?

  hi.we have 1 server with multiple databases.. The data tables are mostly inside database A.. and th…

  Jane777

  2 replies

  7 years, 7 months ago

  By: Luis Cazares

• AOAGs Join Only Option

  Quick one. When using the join only option whilst adding a Db to an AOAG. Is the db restored and le…

  Super Cat

  2 replies

  7 years, 7 months ago

  By: Alexander Zhang

• Iterate through list and fill column

  hi,i need some help with iterating through a list and checking its running total against a paramete…

  Talvin Singh

  3 replies

  7 years, 7 months ago

  By: george_at_sql

• Cannot create primary key Serial to table have existing data .

  Problem Cannot create primary key Serial to table have existing data . Table structure USE [Malahy]…

  ahmed_elbarbary.2010

  2 replies

  7 years, 7 months ago

  By: shwetakakran01

• Sum of data and index space used not equal to fileproperty() spaceused

  Hi -- I'm doing a SSMA migration from Sybase to SQL and i'm midway to finishing. I'm just curious w…

  Ivan R.

  2 replies

  7 years, 7 months ago

  By: Ivan R.

• SQL Agent Job Running 8 Days - Not Doing Anything

  I have a job in my environment that truncates a SQL Server table, queries an Oracle database and us…

  lmarkum

  5 replies

  7 years, 7 months ago

  By: Sue_H

• SQL Server 2012 (Not Express) - Cannot Edit Maintenance Plan

  Hi there, We're running SQL Server 2012 (SP 4) build 11.0.7001.0.  SSMS is running from t…

  RMason - eLIMBS, LLC

  2 replies

  7 years, 7 months ago

  By: RMason - eLIMBS, LLC

• SQL User to Delete from several databases on instance

  We have a number of T-SQL statements contained in a variable @sql nvarchar(MAX) which need to be e…

  zoggling

  4 replies

  7 years, 7 months ago

  By: zoggling

• Best replication solution for poor connectivity scenario

  Hi AllI am struggling to configure transnational replication between some retail stores and head qu…

  S_Kumar_S

  2 replies

  7 years, 7 months ago

  By: S_Kumar_S

• Help me with the SELECT statement please ?

  Good Folks... My question is already in the code...See the code ( the very last SQL statement )&nbs…

  mw_sql_developer

  6 replies

  7 years, 7 months ago

  By: mw_sql_developer

• TDE and Logshipping

  HiWe already have an established Log Shipping environment.The secondary has the databases in the 'N…

  PearlJammer1

  6 replies

  7 years, 7 months ago

  By: PearlJammer1

• Connect SQL2008R2 SSIS to SQL2012 LocalDB ?

  Can I connect a SQL2008R2 SSIS package to a SQL2012 localDB to update data on the localDB used by t…

  huw.davies

  1 replies

  7 years, 7 months ago

  By: ns_nataly