SQL Server 2005 General Discussion

• Topics

  Started by

  Posts

  Last post

• extraction of an query with sql for xml path to xml file

  Hi, I use SQL SERVER 2005, I want to extract query result using "for xml path (''), type" to a xml…

  kotearon

  1 replies

  14 years, 11 months ago

  By: kotearon

• Need help on query

  Hi all.. here my second post, thank's for helping me solve my problem before. I've a problem on thi…

  cutecrazyguy

  4 replies

  14 years, 11 months ago

  By: Grant Fritchey

• sp_send_dbmail

  Hello, I am working on sp_send_dbmail, when i am executing a query and attaching the same. Below is…

  Nageswara Reddy.Lakka

  13 replies

  14 years, 11 months ago

  By: saif.qazi0532

• SQL 2005 Schedulers deadlocked on ASYNC_NETWORK_IO

  Hi All, Running SQL 2005 SP1 on Windows Server 2003,  Dual core 4 cpu, 16gb memory, 4 San part…

  MAO-158301

  3 replies

  14 years, 11 months ago

  By: glen.grunden

• Need to find schema difference between two databases

  Hi all, I need the assistance for the following criteria. Could any one help/suggest me? Need to fi…

  Bagath

  7 replies

  14 years, 11 months ago

  By: Bagath

• SQL Server 2005 32 Bit Version on Windows Server 2008 R2 x64

  Can't seem to find an answer. If we install a Windows Server 2008 R2 x64 bit server, can I install…

  Roger Abram

  4 replies

  14 years, 11 months ago

  By: Meet George Jetson

• The multi-part identifier could not be bound

  We are switching servers, and upgrading our SQL, from 7.0 to 2005. I'm having a problem with table…

  exg 62348

  4 replies

  14 years, 11 months ago

  By: exg 62348

• AWE Error

  Hi I have a badly treated SQL server running a useless software package - the software has been str…

  craighenderson

  2 replies

  14 years, 11 months ago

  By: craighenderson

• image vs varbinary(max)

  I maintain an application which was developed back in 2000 and it was developed against SQLServer 2…

  noumanjee

  1 replies

  14 years, 11 months ago

  By: Oliiii

• Rebuild Index Task fails in Maintenance Plan

  Hi Friends, I am new to SQL Server Administration. I have created the Daily Maintenance plan as bel…

  Senthil-437023

  7 replies

  14 years, 11 months ago

  By: Senthil-437023

• MSXML 6 Service Pack 2 (KB954459) failed to install

  While trying to install sql server 2005 client utility tools, MSXML 6 Service Pack 2 (KB954459) fai…

  sharon.smith 67000

  1 replies

  14 years, 11 months ago

  By: Adiga

• replacing Group By with row_number()

  Hello, I have an indexed view and I query this view to get counts on how many products each seller …

  elayevskiy

  2 replies

  14 years, 11 months ago

  By: elayevskiy

• Kick off SQL Job once file arrives

  We have flat files sent over nightly from our ERP system, which are used in our morning datamart lo…

  Karen Yorgy

  3 replies

  14 years, 11 months ago

  By: bsheets 73864

• specifying a text qualifier when outputing to file

  Hi, How is it possible to specify a text qualifier when outputing the contents of a query to file t…

  Nazir Jooman

  3 replies

  14 years, 11 months ago

  By: winash

• problem with 'Ad Hoc Distributed Queries'

  Hello eveyone, I have the following procedure: Insert into CanadaReport (Process,SubProcess,Refe…

  moramoga

  1 replies

  14 years, 11 months ago

  By: moramoga