SQL 2012 - General

• Topics

  Started by

  Posts

  Last post

• Adding ADSI LDAP server connection inside CMS collection?

  Morning, all. Is there a way to query the LDAP from inside the CMS? I know I can add a linked serve…

  Erin Ramsay

  4 replies

  11 years, 10 months ago

  By: Robert Davis

• always on migration

  Currently inherited the following SQL Server 2008r2 active passive cluster running on windows 2008 …

  tcronin 95651

  7 replies

  11 years, 10 months ago

  By: tcronin 95651

• Moving SRS to a new server and changing data sources

  I have a project where I am creating a test environment. My objective is to give the client staff …

  pdherde 75051

  5 replies

  11 years, 10 months ago

  By: tripleAxe

• backup and restore

  I am newer to sql server.so can u help me how to backup and restore SQL Server databases using ssms…

  raghumachineni

  2 replies

  11 years, 10 months ago

  By: Grant Fritchey

• Sybase to Sql Server Migration - Date column format

  Hi All, I am currently working for the Sybase to Sql Server migration project and have been able to…

  Suresh Arumugam

  1 replies

  11 years, 10 months ago

  By: Koen Verbeeck

• SQL .NET Framework 4.0 upgraded to 4.5 on SQL 2012 Ent server

  HI - SQL: SQL 2012 Ent. We have a Severity A case open with Microsoft regarding SQL assemblies and …

  cheshirefox

  1 replies

  11 years, 10 months ago

  By: paul.knibbs

• BACKUP LOG failed with "Cannot insert duplicate key in object 'dbo.backupmediaset'" message

  One of my database transaction log backup jobs failed this morning, although the log backup was sti…

  tripleAxe

  6 replies

  11 years, 10 months ago

  By: tripleAxe

• Need to get object type for synonym base object (2012)

  Hi all, I need to get the object type (view, table ...etc) for a synonym base object inside a …

  jmartincano

  6 replies

  11 years, 10 months ago

  By: jmartincano

• TempDB Log file usage constantly rising and file keeps growing.

  Having a strange problem this morning. The TEMPDB transaction log file keeps growing. The database …

  Maddave

  10 replies

  11 years, 10 months ago

  By: Maddave

• Current resource hogs

  Hi all, I am looking for scripts to find "currently running" resource hogs. I have scripts for ov…

  shahgols

  1 replies

  11 years, 10 months ago

  By: Gail Shaw

• Migrating sql 2005 to 2012 SSIS, SSAS, SSRS

  Hello, I know this is a broad question, but my company is upgrading sql 2005 environment to sql 201…

  Lord Slaagh

  4 replies

  11 years, 10 months ago

  By: Lord Slaagh

• Really hope SSC can remove these annoying posts for the World Cup!

  Hopefully you guys are working on removing this world cup crap from our beloved SSC site. The are n…

  Lord Slaagh

  2 replies

  11 years, 10 months ago

  By: Lord Slaagh

• select the record with the most recent order date

  Hello I am working on a query that needs to return the record order number with the most recent req…

  itortu

  15 replies

  11 years, 10 months ago

  By: ChrisM@Work

• Split csv records to seperate columns

  Hi, I've a table as below custid,companyname,phone,address 2,AAAAA,(222) 222-2222,address 2 3,cust …

  ykonline

  15 replies

  11 years, 10 months ago

  By: Koen Verbeeck

• Tricky SUM(C1) OVER.. with extra selection? is it possible.

  Hi, I have this task to carry Sum* fields into RDL and I need to make calculation as in below query…

  mario17

  6 replies

  11 years, 10 months ago

  By: mario17