SQL 2012 - General

• Topics

  Started by

  Posts

  Last post

• Unable to start SQLAgent - MSDB is Read-Only

  I am unable to start the SQLAgent service. It is reporting that MSDB is read-only. I have checked i…

  Vyper426

  22 replies

  10 years ago

  By: EdVassie

• Use of Distributed Transaction Coordinator

  Hi, we have a stored procedure that queries a linked server and copies some data over to the local …

  PHXHoward

  1 replies

  10 years ago

  By: SeniorITGuy

• memory issue

  I have a sql server 2012 sp2. Dbcc checkDB job has been failing and getting the following error mes…

  Grace09

  2 replies

  10 years ago

  By: Grace09

• Free eBook today: SQL Server 2012 with PowerShell V3 Cookbook

  https://www.packtpub.com/packt/offers/free-learning Gaz -- Stop your grinnin' and drop your linen..…

  Gary Varga

  26 replies

  10 years ago

  By: Gary Varga

• Bit of a "Newbie" question. Compare and join databases.

  Hello all, greetings from a cold-winter Sweden. I have a problem that i need help with, tried to se…

  stefan 97267

  15 replies

  10 years ago

  By: Wayne West

• Star schema question

  Hi friends, We are in the development phase of generating new reports(using 3rd party) tool from t…

  newbieuser

  3 replies

  10 years ago

  By: newbieuser

• Group authentication oddity

  Very confused with some security behavior I'm seeing. I've restored a database from SQL 2008 to SQL…

  wmt

  2 replies

  10 years ago

  By: wmt

• sys.dm_db_index_usage_stats user_updates higher for a non-clustered index than the PK

  I'm trying to understand the output of sys.dm_db_index_usage_stats for a couple of tables on a SQL …

  ianharris2

  2 replies

  10 years ago

  By: ianharris2

• Which will be better composite index or single indexes?

  Hello, One of my db table has three naming columns apart of other columns as follows: FirstName Las…

  GroverVivek

  4 replies

  10 years ago

  By: Grant Fritchey

• Cannot drop the table 'TABLE' because at least part of the table resides on an offline filegroup.

  Hello all, I am checking to see if this is even something that can be done. I have a non-prod db th…

  Leeland

  8 replies

  10 years ago

  By: Leeland

• Linked server query for database names to insert if a table exists in the database

  Hi All, I am really struggling with the following requirement, I thought it would be quite simple..…

  acrutchley

  1 replies

  10 years ago

  By: acrutchley

• SQL server 2012 MSDN Licenses

  Hi Experts, How to know if we have used MSDN media to install our SQL server 2012 in non-production…

  Bipsy

  3 replies

  10 years ago

  By: Lowell

• How can I get the Graphical plan from XML

  I wrote an Extended Events that is helping me to capture the execution plan of an store procedure t…

  sql-lover

  2 replies

  10 years ago

  By: Jacob Wilkins

• Access Granted for : CREATE USER [Domain1\UserName] FOR LOGIN [Domain1\UserName]

  Hi All I have a question about the User Access for a Database. My Scenario is as below I have a dat…

  anju04n6

  6 replies

  10 years ago

  By: anju04n6

• using converted var char date time field to return records in a date

  I have date and time stored in the following format: mm-dd-yyyy hh:mm:ss I only need the date part,…

  macdca

  19 replies

  10 years ago

  By: LinksUp