SQL 2012 - General

• Topics

  Started by

  Posts

  Last post

• Restore Master Database for a new dba

  Sometime during the night last night some user account permissions were "lost". Am I right to thin…

  JeepHound

  8 replies

  11 years, 9 months ago

  By: Perry Whittle

• How useful are saved configuration .ini files for automating installs?

  I nabbed a couple from some recent installs I did, and, assuming I can get my SAN guy to always giv…

  sqldriver

  3 replies

  11 years, 9 months ago

  By: EdVassie

• Replication

  I've a database that comprises of about 50 tables. Some have PKs and some don't. Source is 2005 and…

  SQL_Surfer

  1 replies

  11 years, 9 months ago

  By: Mike Good

• Re-establish one database in an Availability group

  I've got an availability group with multiple databases, replicating to multiple secondary servers. …

  Leo.Miller

  2 replies

  11 years, 9 months ago

  By: Mike Good

• RAISE ERROR to THROW conversion

  Hi, I have an old proc like below which I want to update to use THROW. Looks like THROW can save yo…

  mario17

  2 replies

  11 years, 9 months ago

  By: Henrik Staun Poulsen

• Selecting a Clustered Index

  HI Guy The question is a bit allover - What are your thoughts on adding clustered index on datetim…

  jude.pieries

  2 replies

  11 years, 9 months ago

  By: jude.pieries

• SQL Server 2012 Transactional replication

  Hi experts, I have two standalone sql instances on same domain with named instances and they are li…

  Bipsy

  2 replies

  11 years, 9 months ago

  By: SQL Guy 1

• Backup / Restore Availability Group following fail-over

  I have 2 servers in a SQL Server Fail-Over Cluster. IOW I use always-on availability groups. I r…

  yo.mawtin

  1 replies

  11 years, 9 months ago

  By: Mike Good

• SSIS package config issue

  Hello, I recently upgraded several SSIS packages from SQL 2005 - 2012 using the package upgrade wiz…

  Lord Slaagh

  3 replies

  11 years, 9 months ago

  By: Lord Slaagh

• Upgrade Path from SQL Server 2008

  Hi, Can I upgrade from SQL Server 2008 (NOT 2008R2) to SQL Server 2012 is there an upgrade path for…

  bugg

  2 replies

  11 years, 9 months ago

  By: bugg

• Msg 241, Level 16, State 1, Line 1 Conversion failed when converting date and/or time from character string.

  Hi, Getting the following error - Msg 241, Level 16, State 1, Line 1 Conversion failed when conv…

  TSQL Tryer

  2 replies

  11 years, 9 months ago

  By: TSQL Tryer

• DQS- Upgradedlls

  Hi, I tried to move log to another drive but I moved it back. Now Data Cleansing Component is not w…

  ayemya

  1 replies

  11 years, 9 months ago

  By: ayemya

• Fastest Way to consume large XML files

  Hi everyone I want to pick your brain on something. I need to create script that will import large …

  Jako de Wet

  11 replies

  11 years, 9 months ago

  By: Eirikur Eiriksson

• MDF File size is growing fastly...

  Hi Experts.... I have a Problem like the Following .. On 24th my Mdf size was 10GB,when i checked n…

  Chowdary's

  2 replies

  11 years, 9 months ago

  By: Perry Whittle

• Working out what transaction isolation level a transaction is running under from extended events

  Hi Ive got a standard extended event running capturing rpc_completed and sql_batch_completed I want…

  DominantDBA

  2 replies

  11 years, 9 months ago

  By: DominantDBA