SQL Server 2005 General Discussion

• Topics

  Started by

  Posts

  Last post

• Optimal NTFS Cluster/Allocation Unit Size?

  As subject, setting up a light (all relative I know) usage SQL 2005 server and just created a VMDK …

  Paul Hutchings

  3 replies

  16 years, 12 months ago

  By: Paul Hutchings

• SET IDENTITY_INSERT ON

  CREATE TABLE dbo.T1l( ID INT IDENTITY NOT NULL PRIMARY KEY, Name VARCHAR(40) NOT NULL ) GO CR…

  lav-888385

  2 replies

  16 years, 12 months ago

  By: Steve Jones - SSC Editor

• Backup Plan

  I was wondering if someone could tell me how to overwrite existing SQL backup files within your mai…

  Mike Menser

  2 replies

  16 years, 12 months ago

  By: Steve Jones - SSC Editor

• Data and Logs on Same Partition?

  Hi everyone, My past experience was to always put the database and log files on different partition…

  craigl5678

  2 replies

  17 years ago

  By: RBarryYoung

• sqlmaint.exe failed

  Hi Every one, I frequently got this error "sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). Th…

  jai_sl2000

  2 replies

  17 years ago

  By: Mohit K. Gupta

• Linked Server in SQL Server 2005

  Hi all, I am new to this forum and I am looking for some help regarding SQL Server Stored Procedure…

  shri.gangula

  2 replies

  17 years ago

  By: shri.gangula

• Isues with Identity columns? Char as primary key

  Hello, I've begun a new project and my predecessor used a char(10) field as the primary key in all …

  jxg548

  3 replies

  17 years ago

  By: Jeff Moden

• How to write codes that display sub-colum names under main column header name

  Hello ALL, Say I have written codes that create the column header field name such as BOMCleared, CT…

  josephptran2002

  2 replies

  17 years ago

  By: Jeff Moden

• Full Text Search - Thesaurus help (is there an already "pre-filled" thesaurus?)

  We have implemented Full Text Search on our system. The only thing is missing is the Thesaurus. T…

  zangief44

  1 replies

  17 years ago

  By: Gift Peddie

• Error install sql on cluster - unable to validate domain group

  I am attempting to setup a sql 2005 cluster, I have gotten as far as the Domain Groups for Clustere…

  Chris Golla

  1 replies

  17 years ago

  By: Richard Fryar

• use of Curser to purge data+sql server 2005

  Hi, i want to purge data from one of table.. i want to retain ony 1 year data .. i want to purge al…

  snehal.gamaji.career

  12 replies

  17 years ago

  By: Lynn Pettis

• host_name() on cluster returns different value in DB Mail

  Cluster Environment, SQL 2005, SP3: select host_name() returns the actual physical host name. (Ju…

  2 Tim 3:16

  6 replies

  17 years ago

  By: 2 Tim 3:16

• expected tables in tempdb

  May I ask this here? Our different applications (stored proc) normally remove temp tables in the co…

  ykffc

  12 replies

  17 years ago

  By: Gail Shaw

• can anyone see anything wrong with this query?

  I have a query that looks like this: Declare @sql nvarchar(MAX) set @sql = ' SELECT x.SaleYear,…

  SQL_NuB

  32 replies

  17 years ago

  By: john.botibol

• SQL Exercises for PUBS and Northwind SQL Sevrer database

  Hi, I am new to SQL Server and have recently bought SQL Server 2005 programming by Rob Viera. But …

  jaideepc99

  4 replies

  17 years ago

  By: Grant Fritchey