SQL 2012 - General

• Topics

  Started by

  Posts

  Last post

• Revlogin script for sa account.

  Hi, Is  there  any way where we can script out revlogin for sa account. The problem is we…

  prsnn_shetty

  1 replies

  7 years, 9 months ago

  By: John Mitchell-245523

• SSIS Data Flow Items tab missing in the SSDT 2010 for SSIS 2012

  Hi, I need to see inside a SSIS 2012 project a new SSIS installed component, but in the SSDT 2010 I…

  pmscorca

  8 replies

  7 years, 9 months ago

  By: sqlmysqldev

• How to search songs_words table for songs that contain a group of words?

  Hello,   I have an SQL database of of songs with a table that consists of 8 columns of in…

  Davismarsel

  7 replies

  7 years, 9 months ago

  By: Jeff Moden

• SSIS Foreach File Enumerator Date Order

  I'd like to ensure that my SSIS (2012) Foreach File Enumerator processes the files in order of crea…

  Jim

  3 replies

  7 years, 9 months ago

  By: mark 59108

• Find additional connection parameters with DMV

  Hi, is it possible to get additional connection parameters of connectionstrings like MultiSubnetFai…

  alexander.huberti

  2 replies

  7 years, 9 months ago

  By: Grant Fritchey

• Show only records where a NULL exists across columns...

  Hi Team, I'm struggling with the syntax of a WHERE statement to return only the records where a NUL…

  Matty_H

  2 replies

  7 years, 9 months ago

  By: Matty_H

• Endpoints Sql server

  Hello, guys.I thinking for something  but not really sure.Is it possible to make a endpoint in…

  iseedeadpeople

  1 replies

  7 years, 10 months ago

  By: Ant-Green

• The slab consolidation / trim operation cannot be performed because the volume alignment is invalid

  Has anyone seen this error? I received it when attempting to run defrag analysis (defrag S: -a -v) …

  Jon.Morisi

  10 replies

  7 years, 10 months ago

  By: Jon.Morisi

• I cannot access tables in SQL: Server Express 2012

  I am trying to access the tables and other objects in a database for a off the self application.I t…

  ak08820

  5 replies

  7 years, 10 months ago

  By: Sue_H

• SQL log shipping issues

  Hello, I cannot seem to get log shipping to work on my server setup. I'm sure I am missing somethin…

  unematt

  16 replies

  7 years, 10 months ago

  By: Sue_H

• How to code to find date and time

  I need to run daily script to create a report.How to code to find out data like belowselect * from …

  adonetok

  5 replies

  7 years, 10 months ago

  By: adonetok

• Combine rows by applying grouping and data validation

  Hello All, I have master data, based on that i am trying to prepare query in such way that rows can…

  KapilT

  7 replies

  7 years, 10 months ago

  By: drew.allen

• Migration of SQL Logins

  I am working on migration project from 2005 to 2012. We have many SQL logins in current server whic…

  dva2007

  6 replies

  7 years, 10 months ago

  By: Michael L John

• Migration from Teradata to SQL

  Hi, We are currently migrating our project database from teradata to SQL. In teradata all the input…

  prasanna0184

  3 replies

  7 years, 10 months ago

  By: Jeff Moden

• Replication - sp_msuplineageversion stuck

  We have a publication on SQL 2012 with about 135 subscribers, and about once per week one subscribe…

  kevin.kembel

  7 replies

  7 years, 10 months ago

  By: danywwjd