SQL 2012 - General

• Topics

  Started by

  Posts

  Last post

• Cannot connect to localhost

  Has anyone any experience this SQL SERVER error: "Cannot connect to localhost"? If so could you hel…

  Chrenton

  5 replies

  9 years, 3 months ago

  By: Chrenton

• SQL Audit files not being deleted

  Hi All, I have created a server level audit in my SQL Server 20212 v11.0.5058. The create script fo…

  phil_mw60

  2 replies

  9 years, 3 months ago

  By: phil_mw60

• x64 SQL 2012 Express on x64 machine

  Greetings all. Some of my team just got new 64 bit machines, so we installed 64 bit SQL Server 201…

  Greg Snidow

  3 replies

  9 years, 3 months ago

  By: Chris Harshman

• Make Varchar the Default instead of NVarchar

  When I use ETL or SELECT * INTO TableName to automatically create and populate a table, SQL Server…

  afindley

  7 replies

  9 years, 3 months ago

  By: Thom A

• SSRS Report Developed in VS2015 would not work in SQL Server 2012 Report Server

  Please see attached error. This comes up when I used VS2015 to develop ssrs report and deployed suc…

  mw_sql_developer

  4 replies

  9 years, 3 months ago

  By: Thom A

• Filter on database name for sqlserver.sp_statement_completed, sqlserver.sql_statement_completed extended events

  Hi, In SQL Server 2012, is there any way to apply filter based on database name for events sqlserve…

  praveen_vejandla

  2 replies

  9 years, 3 months ago

  By: praveen_vejandla

• Save results as...

  In SQL manage studio result panel, right click the result, select "Save results as...", I can save …

  adonetok

  1 replies

  9 years, 3 months ago

  By: Eirikur Eiriksson

• Error Handling and Check Constraints

  I am new to writing Stored Procedures and having been reading up on Error Handling e.g. Throw and R…

  patelxx

  3 replies

  9 years, 3 months ago

  By: Kidd311

• Deny access to a table

  Hi All, Ahh permissions how I loof thee! Right so, we want to deny access so only sysadmins have ac…

  Kazmerelda

  3 replies

  9 years, 3 months ago

  By: Kidd311

• Unable to view a User's Effective Permissions

  I have a Database user that is a Windows Type mapped to a SQL Login which is mapped to an Active Di…

  planetmatt

  4 replies

  9 years, 3 months ago

  By: planetmatt

• Free eBook from PacktPub: Microsoft SQL Server 2012 Performance Tuning Cookbook - TODAY ONLY!!!

  PacktPub, a well known but smaller publisher, provides a free eBook every day. I believe it is a lo…

  Gary Varga

  2 replies

  9 years, 3 months ago

  By: Gary Varga

• how to search records in a table and identify which records do not exisits based on 2 conditions and then insert the missing records from another table

  how to search records in a table and identify which records do not exist based on 2 conditions and …

  knight944

  13 replies

  9 years, 3 months ago

  By: pietlinden

• Weird DBCC finding when restoring master database for disaster recovery test

  We had an interesting finding today when performing a disaster recovery restore test on the master …

  Sql_In_Seattle

  2 replies

  9 years, 3 months ago

  By: Sql_In_Seattle

• Sorting and Adding to a table based on conditions

  I need to sort through Table1 and look through each distinct MAIN_ID. In looking at each MAIN_ID I …

  knight944

  10 replies

  9 years, 3 months ago

  By: knight944

• Transaction log size up to 1.5 GB in 3 hours

  Dear Members We have implemented SP with Filestreaming + RBS I came and found the transaction log f…

  hurricaneDBA

  29 replies

  9 years, 3 months ago

  By: Ray Herring