SQL Server 2005 General Discussion

• Topics

  Started by

  Posts

  Last post

• Update one column of a table with data from another table

  I have two tables which are different with the exception of a single field (column name = "Location…

  k-dub

  11 replies

  12 years, 6 months ago

  By: Hans K

• Creating a format file to import XML data

  Hello gurus and geniuses Please forgive me starting yet another thread on this subject. I have sear…

  jsilverthorne

  1 replies

  12 years, 6 months ago

  By: Tavis Reddick

• Conflicting Version number and Build Number on @@Version

  Morning everyone. I installed 2005 (X64) SP3 & 4 on a server over the weekend. An odd thing ca…

  Mark Kinnear

  3 replies

  12 years, 6 months ago

  By: Mark Kinnear

• SQL Server 2005 Database Mail - Mail configuration information could not be read from the database.

  I'm trying to setup Database Mail and send a test message, but it's not working. I've done several …

  mstock

  1 replies

  12 years, 6 months ago

  By: Sean Lange

• DataTransfer

  Hi All, I have 13 databases say portfolio databases named (a, b, c, d,....m) I need to transfer few…

  Deepthy

  1 replies

  12 years, 6 months ago

  By: SQL_NuB

• SSMS Startup

  Hi There, How can I connect to default server automatically when I open SSMS? It always show me "Co…

  houman.fathi

  1 replies

  12 years, 6 months ago

  By: Vishal.Gajjar

• email multiple query results to multiple staff

  Hello all, The scene: There are 3 people who are all responsible for a number of specific jobs to t…

  WiRL

  5 replies

  12 years, 6 months ago

  By: Lowell

• compare data row by row

  I have a request and I'm unable to use 3rd party tools such as RedGate. I'll be creating a database…

  SQL_NuB

  4 replies

  12 years, 6 months ago

  By: Lynn Pettis

• How to add percentage(%) symbol in stored procedure

  Hi All, I want to know how to add percentage symbol(%) to my final sql statment column names in sto…

  sql4us

  1 replies

  12 years, 6 months ago

  By: Sean Lange

• Reducing Initial LDF/MDF size

  Hello, I have a database (version 9.0.4060) that has an initial log size set to 322GB. I would lik…

  mikehunsaker

  6 replies

  12 years, 6 months ago

  By: SqlSavy

• SQL Subtraction - Seperate rows

  Hi I currently use the following statement: SELECT * FROM Month1_Month2_Diff_Detail OR…

  kevin_batchelor

  9 replies

  12 years, 6 months ago

  By: kravitej9

• SQL Express 2005 instance is not starting up

  Hi all, We get this error when the sql express 2005 instance starts "Could not allocate space for o…

  kalaivanisrec

  8 replies

  12 years, 6 months ago

  By: kalaivanisrec

• Can't Connect to SQL Server 2005

  I have a network with two Windows Server boxes. One is a 64bit machine and the other is a 32bit ma…

  mrtrich99

  2 replies

  12 years, 6 months ago

  By: mrtrich99

• Issue with OSQL

  Hi Friends, Requirement : i have a table which contains around 40 columns of which name is a colum…

  Compassionate

  8 replies

  12 years, 6 months ago

  By: Orlando Colamatteo

• update a server by another server

  hi, i am new with sql i am still learning, my assignment is to create an ssis to update a server, E…

  kgeeel240

  1 replies

  12 years, 6 months ago

  By: Sean Lange