SQL 2012 - General

• Topics

  Started by

  Posts

  Last post

• DbaTools With Powershell - Omit The Id Column on CSV Export?

  I am learning DbaTools in Powershell, and my current project is exporting a CSV file. I've managed …

  cajun_sql

  4 replies

  4 hours, 15 minutes ago

  By: jasona.work

• Migrate MSSQL to MYSQL - Different Servers

  I am needing to migrate a MSSQL db to MySQL, on a different server in the same network. The MSSQL i…

  cajun_sql

  3 replies

  3 weeks, 5 days ago

  By: cajun_sql

• CDC Agent Job fills up the Agent Jobs History

  We have implemented CDC on one of our databases. We now find that the job history for the CDC captu…

  ianharris2

  6 replies

  3 weeks, 6 days ago

  By: Srinivas Merugu

• How Do You Change Data Type from uniqueidentifier

  In the ss below you can see that I have a table (dbo.clan.spouses) with a column (spousesID) that h…

  Ahr Aitch

  10 replies

  4 weeks, 1 day ago

  By: Jeff Moden

• updating statistics for big tables

  Hi All, Need some advise on how to deal with UPDATING STATISTICS huge tables. Below are some questi…

  vsamantha35

  12 replies

  4 weeks, 1 day ago

  By: Srinivas Merugu

• Moving Database Files

  I just learned that my database was created on my C:\ drive in the Program Files folder by default.…

  Ahr Aitch

  1 replies

  1 month ago

  By: Johan Bijnens

• sqlbackups through veeam not updating msdb tables

  We have veeam backups happening everyday on a server where all sql databases are also getting backe…

  mtz676

  3 replies

  3 months ago

  By: Ken McKelvey

• SSIS variable not changing value

  In a simple SSIS 2012 package I'm trying to change the value of a variable (name vValue). The defau…

  xanthos

  10 replies

  3 months, 2 weeks ago

  By: Kraken

• Intellisense on some databases, not others??

  I have an issue in SSMS that I can't figure out. In SSMS, connected to an SQL Server 2012 instance …

  bartedgerton

  17 replies

  4 months, 1 week ago

  By: skitchens

• How to determine if a DB is currently being used

  Hi - I'm looking for advice regarding the best & quickest way to establish whether or not a SQL…

  dax.latchford

  7 replies

  4 months, 2 weeks ago

  By: jonathan.ellison

• DNS entry for each database

  We've been tossing around the idea of using DNS CNAME entries for each database. For instance a cna…

  TangoVictor

  5 replies

  4 months, 4 weeks ago

  By: russ960

• Error while connecting Local DB 2012 in Windows 7 PC using SSMS

  I am trying to access LocalDB 2012 on my Windows 7 SP1 PC. I have successfully installed LocalDB an…

  IT researcher

  1 replies

  5 months, 1 week ago

  By: IT researcher

• MSDB stuck in recovery mode

  Hi, i was following this guide[/url] for moving msdb to a new location. When i restarted the SQL Se…

  memymasta

  16 replies

  5 months, 3 weeks ago

  By: Ant-Green

• Distribution database not getting cleaned up

  Hi  I am using transaction replication in our environment The distribution database I see is n…

  kaleparag

  5 replies

  6 months ago

  By: shashibhanmaurya

• Re-establish mirroring after DR test

  Hi all, Sorry for double posting this (I also posted on the msdn forum with no definite answer) I h…

  Calvin Duffy

  14 replies

  7 months, 1 week ago

  By: WorkinMan