SQL Server 2005 General Discussion

• Topics

  Started by

  Posts

  Last post

• Cross DB Dependency,Including ones from Link server.

  I have couple of proc 2 proc in my db which have a linked server and use data from a linked server,…

  bhushanvinay

  2 replies

  15 years, 1 months ago

  By: bhushanvinay

• Abnormal growth of temp db

  I can see abnormal growth of temp db during a update query: UPDATE tlstagingdb.dbo.tbltlxyz SET lIm…

  Ganeshkumar005

  2 replies

  15 years, 1 months ago

  By: Jeff Moden

• ADODB.Recordset Delete method causes ''Could not find server'' error

  Hi I get a strange error while calling Delete method on ADODB.Recordset. Microsoft OLE DB Provider …

  Kuba J

  4 replies

  15 years, 1 months ago

  By: Kuba J

• Maintenance Plan - Send Mail

  Hi All, I am stumped. I have a query which runs fine on it's own. It generates data. I have made…

  GekGurly

  3 replies

  15 years, 1 months ago

  By: homebrew01

• defining query to use an existing index

  Hi Guys, Yesterday, in an interview, i was asked an question, that suppose i have a query that uses…

  ganu.mumbai

  5 replies

  15 years, 1 months ago

  By: alen teplitsky

• Merging rows of data in SQL

  Hello , Does anyone know if its posisble to merge 2 or more rows of data using SQL if the data if a…

  pwalter83

  4 replies

  15 years, 1 months ago

  By: pwalter83

• Courses for SQL Server DBAs

  Hi, I'm a SQL Server DBA. I have been doing some research on how to increase my knowledge level in …

  m--S3qU3L

  3 replies

  15 years, 1 months ago

  By: Grant Fritchey

• SQL Server Agent Scheduled Jobs - Cannot find DLL when invoking executable program

  Hi, I am testing database migration from SQL Server 2000 to SQL Server 2005. It's SQL Server 2005 6…

  David-G

  3 replies

  15 years, 1 months ago

  By: SQLDCH

• UTF8 XML parsing error - "illegal xml character" while parsing £

  XML parsing: line 1, character 105, illegal xml character I have a UTF 8 XML where I am passing £ a…

  Praxo

  1 replies

  15 years, 1 months ago

  By: bmwendwa

• Resptre failed for server 'my_server_name\sqlexpress'

  I create a new database name (mynewSQL2005) and use *.bak file to restore into my new database. I g…

  moongeegee

  1 replies

  15 years, 1 months ago

  By: ABAS101

• Outer Join Syntax Clarification Needed

  Hi Everyone, Would someone please be kind enough to explain to me how does the syntax work for an o…

  Veronica Loria

  6 replies

  15 years, 1 months ago

  By: mRainey

• [DBNETLIB][ConnectionRead (recv()).]General network error

  Hi, I have a SSIS task that run on the same server where my database is. The task do: -Truncate a …

  Rem70Rem

  2 replies

  15 years, 1 months ago

  By: Elly Odell

• how to deincrease size of logfile

  I used DBCC SHRINKFILE to truncate logfile after use insert, update,... but the data is too big bec…

  haithanhqb

  3 replies

  15 years, 1 months ago

  By: M&M

• Order one column alphabetically while keeping a Total Line Footer at Bottom of Table

  Hello, I've written this SQL , running it in Access 2003, which produces the information I need, i…

  OP_HELP

  2 replies

  15 years, 1 months ago

  By: Dwayne Dibley

• Extract 3 months worth of data

  Greetings again dearest helpers. I need some huge favor. I am asked to extract 3 months worth of da…

  simflex-897410

  7 replies

  15 years, 1 months ago

  By: lilywhites