SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• database went offline

  I found a database offline This was the message in event viewer Event ID: 5084 Setting databas…

  didier41

  5 replies

  14 years ago

  By: Thomas Stringer

• Need help for SSIS TASK

  Please suggest me some article for ForEachLoop for SSIS Thanks

  Jay Pete

  2 replies

  14 years ago

  By: Orlando Colamatteo

• 2008 sql server x64 problems with x32 excel

  When I try to 'open' @xls files, they return an Error code -2146827284 I cannot retrieve any xls in…

  achen9291

  1 replies

  14 years ago

  By: Matthew Darwin

• return null value sum field when no data is available

  this query return null when no data found why? select SUM([TedadTarhModiriatTafzili])as TedadTarhM…

  vahid.arr

  6 replies

  14 years ago

  By: Sean Lange

• Get related fields from record containing MAX()

  I have trouble believing this isn't possible, but searches all over the net have uncovered nothing …

  pdanes

  19 replies

  14 years ago

  By: ColdCoffee

• Where Statement affects Index?

  Hi Friends, I am here to discuss the general topics of index.... One of my colleague says if we add…

  Charmer

  10 replies

  14 years ago

  By: Charmer

• How to change to sql authentication with sa and password to login?

  When I install SQL2008 R2 using window authentication. How to change to sql authentication with sa …

  adonetok

  5 replies

  14 years ago

  By: adonetok

• Column Conversion Using SSIS

  Hi all, I am relatively new to SSIS. I have constructed a package that loads data from an oracle da…

  dimitris giannopoulos

  7 replies

  14 years ago

  By: Phil Parkin

• query

  I have a table with two column out put date is like this... mnemonicId customerID 1402 14…

  sachince61

  8 replies

  14 years ago

  By: sachince61

• password issue

  hi all, i am working on password manage ment project, there is a login page on my application, whe…

  pnpsql

  2 replies

  14 years ago

  By: Gail Shaw

• BCP exported image is not valid

  I have exported various images from Image type column through bcp. The resultant files show valid s…

  Atif

  2 replies

  14 years ago

  By: Jeff Moden

• How to delete temp log information

  Hi, I have 200 millions of records in one table .I want to load it into set of tables based on t…

  SriSudha

  3 replies

  14 years ago

  By: Orlando Colamatteo

• XP_Cmdshell 'Access is denied'

  Hi All, xp_cmdshell 'dir \\Server001\e$' - running in Server2 xp_cmdshell 'dir \\Server002\e$' - ru…

  ravisamigo

  3 replies

  14 years ago

  By: Orlando Colamatteo

• mapping 2000 send mail parameters to 2008

  This is a stored proc that is mapped to xp_smtp_sendmail(sql2000) on another server. ALTER PROCEDU…

  manny_emm

  2 replies

  14 years ago

  By: manny_emm

• Admin rights - not able to access

  Hi, I'm the member of 'Administrator group' but not able to access the drive from one server to ano…

  ravisamigo

  1 replies

  14 years ago

  By: jerry-621596