SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Cleanup History has an extra output message. Unable to understand how it is appearing. Please help

  /* Oldest Day till I want to Purge[30 days of Old Data] : 03-17-2015 Running Cleanuphistory Procedu…

  SQL_Hunt

  6 replies

  11 years ago

  By: Jeff Moden

• correction in query required

  dear all, i have following query... ------ create table create table test222(sid bigint, scode nvar…

  peterausger

  9 replies

  11 years ago

  By: peterausger

• Update Stats Error. Only throws error, if the databases are with different comparability mode.

  Error: Error 16958, Severity 16, State 3, Procedure usp_updateStats_DBS_best, Line 76 Could not co…

  SQL_Hunt

  1 replies

  11 years ago

  By: spaghettidba

• Rebuild / Reorg Index General Question?

  If you rebuild CLuster Index, by theory it also rebuilds all Non Cluster Indexes. Then why do we ne…

  SQL_Hunt

  1 replies

  11 years ago

  By: Jeff Moden

• How do i get records in one row

  IdIncident IDIncident Description 2853459140511 2861733118512 2861733118601 2869113140511…

  gjuarez

  15 replies

  11 years ago

  By: gjuarez

• Add carriage return to a full address field

  Hi all, I'm pulling individual address fields into my script, some of which are null. I would like…

  ams00601

  5 replies

  11 years ago

  By: Alan Burstein

• Synonym performance in cross-server scenarios vs. OPENQUERY

  I'm using SQL Server 2008R2. I am developing a database which requires access to data from other s…

  CanuckBuck

  1 replies

  11 years ago

  By: spaghettidba

• Copy/move problems with detached databases

  arrghhh Details: Sql2008 R2 Windows 2008 R2 VM Need to move files to different drive Detatched succ…

  jay-h

  7 replies

  11 years ago

  By: sql-lover

• stored procedure text string replace

  We have a legacy database that have hundreds of stored procedures. The previous programmar uses a s…

  sqlfriend

  2 replies

  11 years ago

  By: Alan Burstein

• SSRS Report

  Hello, I have created a simple phone list using SSRS. I am using three columns and wanted to know …

  Meatloaf

  1 replies

  11 years ago

  By: Meatloaf

• Quick question about indexes.

  I have an index on a date field but, the datatype is nvarchar. If I convert to datetime in my where…

  NineIron

  7 replies

  11 years ago

  By: ScottPletcher

• Error while re-building indexes

  Hello I am getting below mentioned error while executing maintenance plan on my SQL server which I …

  SAMDEV

  2 replies

  11 years ago

  By: Grant Fritchey

• How to use colors in my HTML heading and also printing colors to the failure/DBCC CHECKDB error?

  Hi, I need to print in RED if there's atleast 1 or more consistency error and need a heading color …

  SQL_Hunt

  1 replies

  11 years ago

  By: joshdbguy

• SQL Errorlog Error

  Hi, Found the below error in SQL Errorlog. There are no error before this message, is there somethi…

  SQL_Hunt

  1 replies

  11 years ago

  By: joshdbguy

• unable to deallocate cursor properly (A cursor with the name 'tnames_cursor' does not exist.). Help needed.

  USE [DB_ADMIN] GO SET ANSI_NULLS ON GO SET ANSI_PADDING ON GO SET ANSI_WARNINGS ON GO SET CONCAT_NU…

  SQL_Hunt

  4 replies

  11 years ago

  By: ScottPletcher