SQL 2012 - General

• Topics

  Started by

  Posts

  Last post

• Get databasename for a particular user

  Hi all, I have a username I need to script and replicate to UAT, but no indication of which DB - an…

  JackCarrington

  4 replies

  7 years ago

  By: Jeff Moden

• How to compare 3 columns in 2 different databases?

  I have a Large (7 million) record database that I want to compare to a 50,000 record database and s…

  ccameron 64337

  3 replies

  7 years ago

  By: andycadley

• SQL Server Accidental DBA Skills

  Hi all. I'm not sure the best place to post this, so let me know if there is a more appropriate for…

  zech 55624

  5 replies

  7 years ago

  By: zech 55624

• Warm Standy DB Breaks When a Snapshot of it is Created

  I have a db that is log shipped form Server A to Server B.I then take a snapshot of the DB on serve…

  Super Cat

  9 replies

  7 years ago

  By: Super Cat

• Creating user on a mirrored read-only secondary

  Hi all, I want to grant a user read only access a read-only DB on a in a mirrored pair , I created…

  JackCarrington

  2 replies

  7 years ago

  By: JackCarrington

• Identifiers: Reuse or Remap?

  Hi SSC, I'm architecting some stuff which crosses service boundaries, and second guessing myself ab…

  Xedni

  1 replies

  7 years ago

  By: heb1014

• DB stuck in Restoring state

  Hi all, We scheduled a refresh from Prod to UAT over the weekend and now get the following, error,…

  JackCarrington

  5 replies

  7 years ago

  By: Sue_H

• SQL Server 2012 - Server Name Change Question

  Due to a failed product upgrade (Vendor made us the guinea pig for their latest update) we are look…

  YSLGuru

  2 replies

  7 years ago

  By: Abhishek

• Dynamic Cross tab query using dates

  Hi,I have written a stored proc query creating a number of tmp table to use in a sql string to crea…

  Tallboy

  9 replies

  7 years ago

  By: Jonathan AC Roberts

• Huge number of tables

  Hi all, I've inherited a situation where we have a business critical system with gigantic number of…

  JackCarrington

  29 replies

  7 years ago

  By: Jeff Moden

• Splitting Domain from Domain\Username - With Multilanguage support ( Japanese, Dutch ... etc)

  Hi, I need to Split Domain from (Domain\Username), and inset domain value in a new column. But char…

  Rajesh.NairNarayanan

  1 replies

  7 years ago

  By: Sergiy

• Unicode Support and Conversion

  I have SQL Server 2012 and all my inputs got changed to Unicode. I have a week to change my SPs and…

  tinausa

  11 replies

  7 years ago

  By: tinausa

• Procedure Result taking more time

  Below stored procedure taking more time(1 minute 56 seconds) for completing the execution.First tab…

  jkramprakash

  8 replies

  7 years ago

  By: drew.allen

• Copy all objects (tables, views, functions, stored procedures) from one DB to another DB

  I need to copy some selected objects (tables, views, functions, stored procedures) from one DB (Ord…

  adonetok

  8 replies

  7 years ago

  By: Jeff Moden

• Select a value based on sequence number

  There is a table in which there are two columns, sequesenum and color. The data like belowSeq-…

  adonetok

  7 replies

  7 years ago

  By: dave.chintan.m