Administering

• Topics

  Started by

  Posts

  Last post

• How to Create Linked Server for a MySQL database using SQL Server Management Studio

  It took me about a day to figure this out, so I thought I'd try to save someone else the pain... Cr…

  Jim Dillon-291542

  128 replies

  8 years, 10 months ago

  By: kramaswamy

• Default Index Fill Factor

  So me and my counter part (him being around this game much longer than I) have noticed and read in …

  DBA_Dom

  12 replies

  8 years, 10 months ago

  By: bdefreitas

• Rebuild Index Task fails

  Hi Folks, The scheduled reindexing job has failed with the below error: Source: Rebuild Index …

  babu.gunalan

  20 replies

  8 years, 10 months ago

  By: richlion2

• DBCC PAGE Not Returning Data Due to Arithmetic Overflow Error

  I have a SQL Server 2005 instance where DBCC CHECKDB detected error 2570 - a data purity error. Th…

  lmarkum

  2 replies

  8 years, 10 months ago

  By: lmarkum

• error: during upgrade database raised exception 945 severity 14 state 2

  I am getting this error after a detach re-attach to move the data and log files. I can not get the …

  Chrissy321

  5 replies

  8 years, 10 months ago

  By: DK@SQL

• Login Trigger

  I am a real newbie to SQL Server. I have a requirement to limit a user's concurrent sessions so I d…

  beverly.a.selby

  7 replies

  8 years, 11 months ago

  By: jasona.work

• Database Mail process shutting down

  Hi Everyone I'm setting up maintenance jobs to backup data and to notify me. The Database mail serv…

  Petrus Geyser

  7 replies

  8 years, 11 months ago

  By: Chris Harshman

• reindex maintenance plan failed in sql 2008 (An item with the same key has already been added)

  Executed as user: DAQMSDBS01\SYSTEM. Microsoft (R) SQL Server Execute Package Utility Version 10.5…

  21.naved

  13 replies

  8 years, 11 months ago

  By: Gail Shaw

• SQL server Import and Export Wizard Error

  Hello, I have problem with import and export wizard. There are advabnced information: =============…

  tomas.dobremysl

  8 replies

  8 years, 11 months ago

  By: bharani.sbk

• Check Database Integrity uisng maintenance

  My Database Integrity job that i created through a maintenance is failing without giving a clear e…

  kapfundestanley

  20 replies

  8 years, 11 months ago

  By: TheSQLGuru

• Transaction log is not truncated even after log backup in FULL recovery model

  Hi All, I have backed up the log file using SQL Server 2012 SP1 backup option. In the wizard option…

  Narine M

  5 replies

  9 years ago

  By: Jeff Moden

• How to find SELECT<whitespace>* or SELECT<alias>.* in Code for a view using sys tables

  So we have been having replication/build failures due to views with SELECT *. The exercise below sh…

  SQLOzzie

  1 replies

  9 years ago

  By: SQLOzzie

• very high CX packet waits

  i have noticed very high CXPacket waits on one of our dataware house server. All these queries are …

  curious_sqldba

  8 replies

  9 years ago

  By: GK01

• Msg 102, Level 15, State 1, Line 1 Incorrect syntax near '-'.

  If I have connected a linked server whose name is: cic-nic-2 When I running query : select * from c…

  forsqlserver

  10 replies

  9 years ago

  By: Lynn Pettis

• A .NET Framework error occurred during execution of user defined routine or aggregate

  I am trying to execute a script in SQL Server 2005 against a database, getting below error. PLease …

  HBK_4700

  2 replies

  9 years ago

  By: JohnNash