SQL 2012 - General

• Topics

  Started by

  Posts

  Last post

• Defragging the TempDB Drive that uses Netapp Storage

  On our TempDB volume Windows is showing the drive as 80% fragmented, so my Sys Admin asked the Sto…

  Chord77

  1 replies

  11 years, 5 months ago

  By: TheSQLGuru

• sql permissions on a read only replicated database

  any help is appreciated! I have 2 sql2012 databases on different servers, production and one for r…

  ericb1

  4 replies

  11 years, 5 months ago

  By: ericb1

• How the Sql server will behave when multiple users are executing the xp_cmdshell simultaneously

  Hello, My user wants to use xp_cmdshell command in their application because it is easier to finish…

  ying.wang

  3 replies

  11 years, 5 months ago

  By: ying.wang

• Remove Character from specific Column

  Hi Firends How to remove Character From Column,Just Character. I want to work with number. Tnx For …

  ahfb

  4 replies

  11 years, 5 months ago

  By: Ed Wagner

• BCP with 2012 secondary replicas

  Hi, I've been trying to re-direct some BCP export processes to a secondary read-only SQL Server 201…

  rupert.hirst

  6 replies

  11 years, 5 months ago

  By: Perry Whittle

• Linked Server Issue

  Hi All, I have remote connections, TCP/IP, SQL 1433 enabled. But still when i run query I get the b…

  narayanamoorthy.a

  7 replies

  11 years, 5 months ago

  By: narayanamoorthy.a

• SSIS conversion between types is not supported

  Hi As part of an ETL conversion I have dataflow task created that copies data from one table to ano…

  Andre 425568

  2 replies

  11 years, 5 months ago

  By: Andre 425568

• Fetch only country name

  Hi Sir, I need your help to resolve this issue I dont know the exact position of '/',',','--' or an…

  kiran.rajenimbalkar

  7 replies

  11 years, 5 months ago

  By: kiran.rajenimbalkar

• Database Server and Web Server: Which should get the faster server?

  I have website with both the MS SQL SERVER database and the websites on the same server. I am looki…

  markpringle

  3 replies

  11 years, 5 months ago

  By: Gail Shaw

• Reading from an Excel file into SSIS

  Hi I have an excel file which i am reading through SSIS through MICROSOFT Office 12.0 Access Databa…

  duggal.priyanka06

  2 replies

  11 years, 5 months ago

  By: duggal.priyanka06

• Modifying Variable value

  Hi, We have a job running the SSIS Package. I am working with that SSIS Package. The SSIS package h…

  ramana3327

  2 replies

  11 years, 5 months ago

  By: ramana3327

• View with a wildcard * for fields

  I have a growing number of views which are all returning the same fields with a different where cri…

  paul.farnell

  3 replies

  11 years, 5 months ago

  By: Sean Lange

• SSIS and OneDrive

  Just wondering if it's possible to read an MS Access database in OneDrive from an SSIS package?

  shindle 17293

  1 replies

  11 years, 5 months ago

  By: Michael Valentine Jones

• SQL 2012 Cluster and Always ON

  Dear Gurus, Can we make SQL 2012 Always ON over the normal SQL Cluster 2012. Thanks Adeel Imtiaz

  adeel.imtiaz

  3 replies

  11 years, 5 months ago

  By: Perry Whittle

• Using SQL Server 2012 Agent to run a SSIS package created using VS 2013

  My company created a SSIS package using SQL Server Data tool for visual studio 2013. I deployed the…

  Loner

  1 replies

  11 years, 5 months ago

  By: prvmine