SQL 2012 - General

• Topics

  Started by

  Posts

  Last post

• What role\permission is needed to grant db_owner?

  Hello all- Here’s the situation I am hoping someone can guide me with please: •User wants to be ab…

  DBANoobie

  4 replies

  11 years, 6 months ago

  By: patricklambin

• Incorporate several queries in 1

  Hi all, I am wondering if it is possible to make 1 query that gives several, different resultsets. …

  SpeedSkaterFan

  12 replies

  11 years, 6 months ago

  By: SpeedSkaterFan

• Can I use bulk insert for this text file?

  I have a text file and bulk insert code below: 35*20120527*WQ*1900.38~ 220*20131020*QQ*454~ B…

  adonetok

  2 replies

  11 years, 6 months ago

  By: Lowell

• List denied permissions and undo a DENY

  Hello experts, I'm having trouble with this issue. I'm sure there must be a post about it already, …

  webrunner

  3 replies

  11 years, 6 months ago

  By: webrunner

• Replication only for a customer

  Hi, If i want to replicate data only for a particular customer code using SQL 2012 replication - i…

  Anamika

  2 replies

  11 years, 6 months ago

  By: SQLAssAS

• Can Windows 7 built-in client connect to SQL 2012?

  Hi all Just a dummy question. Is the built-in Windows 7 sql client able to connect to SQL 2012 serv…

  runaldo

  1 replies

  11 years, 6 months ago

  By: Grant Fritchey

• column collation for Spanish and for French

  Hi All I have a developer that would like to store a column of data in Spanish and another column o…

  plamannkathy

  3 replies

  11 years, 6 months ago

  By: plamannkathy

• Issue with NUMA, Buffer Cache, and Connection pooling on 4S Westmere

  Running SQL Server 2012 SP1 CU4 (yep), have HADR across 3 nodes, no FCI. This issue seems to happen…

  chandleya

  1 replies

  11 years, 6 months ago

  By: TheSQLGuru

• Getting ready to upgrade...

  So we're ordering new servers to install new instances. We're planning on using Windows and SQL Clu…

  Brandie Tarvin

  1 replies

  11 years, 6 months ago

  By: chandleya

• Combinate indexes

  Hi, we have a table, with 10 indexes. This is the columns included [font="Courier New"] Name |Write…

  jvila

  6 replies

  11 years, 6 months ago

  By: Grant Fritchey

• MDS web configuration

  I am getting error when I launch web browser using localhost/MDS, Here is config error "There is a…

  kk_tech

  1 replies

  11 years, 6 months ago

  By: Brandie Tarvin

• Better to store 0 or null in a column

  Hello, We have a table with 10 columns each column is of datatype int and can accept nulls, when I …

  .Netter

  17 replies

  11 years, 6 months ago

  By: Eric M Russell

• SQL Serer 2012 gives error: "Must declare the scalar variable" even when variable is declared

  I have below script which runs properly on SQL Server 2005/2008 but gives problem on SQL Server 201…

  SAMDEV

  2 replies

  11 years, 6 months ago

  By: SAMDEV

• Is sysadm needed for the following?

  Hello and thanks in advance - I have been supporting a proof of concept for new vendor software at …

  random_name

  5 replies

  11 years, 6 months ago

  By: Silverfox

• Eliminate characters from a string based on another string

  I have a string 'ACDIPFJZ' In my table one of the column has data like PFAG ABCDEFHJMPUYZ KML JC RP…

  rajan.nithin

  2 replies

  11 years, 6 months ago

  By: rajan.nithin