SQL 2012 - General

• Topics

  Started by

  Posts

  Last post

• Permission to create/alter proc but not the dbowner

  Without giving dbowner how can we grant permission to user to alter/create procs?

  SQL_Surfer

  3 replies

  11 years, 7 months ago

  By: Grant Fritchey

• Migrating VLDB to Availability Group

  I have been using AlwaysON AG for a long time now and currently have about 10TB of data across 120 …

  gwellbrock

  4 replies

  11 years, 7 months ago

  By: Perry Whittle

• JOBs cycle

  Hello, i found on server jobs which has executing time about 7minutes, but he has schedule every 2m…

  tony28

  1 replies

  11 years, 7 months ago

  By: Gail Shaw

• SQL error 833

  is it possible that this error during backup caused Sort Warning??? I sent to support of our Sto…

  tony28

  3 replies

  11 years, 7 months ago

  By: tony28

• SQL Server Restart

  Hi , we use SQL Server 2012. When we try to look into the failure messages of SSIS packages in SSMS…

  Anamika

  1 replies

  11 years, 7 months ago

  By: Maddave

• Export text column to excel

  Hi, Until SSMS 2012 I copy and paste grid view with header directly to Excel. Problem starts when I…

  chart3r

  3 replies

  11 years, 7 months ago

  By: chart3r

• doubt on include column

  Hi There , All non-clustered-index (NCI) will also store the key column of clustered-index(CI) Whil…

  vignesh.ms

  3 replies

  11 years, 7 months ago

  By: Gail Shaw

• Won't convert to decimal

  Hi, I'm trying to insert into a table from an XML file. The mapping works OK however there is a pro…

  ma701ss

  14 replies

  11 years, 7 months ago

  By: Eirikur Eiriksson

• Sleeping queries blocking rebuild index and update statistics job in Always on

  Hi friends At one of your client sides we have configured Always on with synchronous mode.Also we h…

  anoop.mig29

  4 replies

  11 years, 7 months ago

  By: anoop.mig29

• Passing a variable to an AS400 server using an OLE DB connection in SSIS

  I am attempting to pull some data via an SSIS package from an AS400 database. The time on the AS40…

  srobinson 596

  2 replies

  11 years, 7 months ago

  By: smrobin

• SQL Server ENT Licensing

  We have a 16 core SQL Server 2012 Enterprise License for a server. Question 1: When installed, doe…

  Max S

  3 replies

  11 years, 7 months ago

  By: Max S

• SQL server 2000 Procedure executing very slower in SQL 2012

  Hi, I've migrated my database from SQL 2000 to SQL 2012 using SQL2008 as intermediate. After migra…

  NSB

  3 replies

  11 years, 7 months ago

  By: Grant Fritchey

• [SSRS Subscriptions] : Credentials Stored Securely in the report server won't work

  Hello everyone , I designed a report on BIDS where i have creating an shared datasource connecte…

  hanimichi

  5 replies

  11 years, 7 months ago

  By: saul.c.robles

• restore TDE backup onto new server

  Hello Guys, I'm confronted with this problem: I have TDE backup one serverA but There is no backu…

  Hadrian

  24 replies

  11 years, 7 months ago

  By: Perry Whittle

• Estimate the size of a Table

  Hi Experts, I have a table like below, CREATE TABLE Student ( Id BIGINT not null ,Name NCHAR(20) no…

  Jampandu

  1 replies

  11 years, 7 months ago

  By: Jampandu