SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Need help with SQL queries.

  Hello, SQL is not my strong point, Im more of a UI developer, unfortunately the DBA is away for the…

  .Netter

  3 replies

  12 years ago

  By: ScottPletcher

• SQL Server instance rebuild/recovery

  All, Is it possible to rebuild and recover SQL cluster instance if cluster drives hosting system da…

  Parthipan-244146

  3 replies

  12 years ago

  By: Perry Whittle

• passing strings in expression

  Hi using the axpression =ToString.Substring(19, 15) in a text box the text box displays "Project_M…

  erics44

  1 replies

  12 years ago

  By: erics44

• SSIS loop with query of keys as variable

  I am trying to do a loop insert to a flat file destination that I have done with raw SQL before, (O…

  rjimshaffer

  1 replies

  12 years ago

  By: rjimshaffer

• Energy sumary Reports

  Hi Guys. I need your help to do a query. I have a table with the following values​​: TimeStamp …

  Andre Paschoal

  3 replies

  12 years ago

  By: Xedni

• TSQL formatting doesn't match source code

  Hey all, Opening a given .sql objects in any tool besides SSMS results in the expected formatting t…

  Adam Bean

  4 replies

  12 years ago

  By: Adam Bean

• Quick health check / environment synopsis

  Hello all, I am looking for alternatives to packaged software to get a quick overview of a given SQ…

  Adam Bean

  6 replies

  12 years ago

  By: Adam Bean

• Help needed in capturing change data

  I have a table table1 that I truncate and enter new and existing records everyday from source table…

  amar_kaur16

  1 replies

  12 years ago

  By: aaron.reese

• Help with Mirroring 2 databases (no witness)

  I'm trying to mirror a database to a secondary instance which is on the same domain. I have alredy …

  oskargunn

  28 replies

  12 years ago

  By: Perry Whittle

• Import from Excel to SQL using SSIS

  Hi, I am trying to import 8 lac data from excel to SQL server using SSIS package, but it is not abl…

  devananddhudat31

  5 replies

  12 years ago

  By: Koen Verbeeck

• Unable to dynamically add multiple excel files into SQL Server 2008

  Dear forum members, I have several hundreds of excel files that I must transfer data to SQL Server …

  Ashish Dutt

  1 replies

  12 years ago

  By: Stuart Davies

• SQL Server backup failing with error code 0xC0024104 only at particular time

  Hi, I have a Sharepoint databases - 2 instances running on the server Windows 2008 R2 Enterprise SP…

  viduvs

  4 replies

  12 years ago

  By: viduvs

• Remove Characters before Character Index

  I have a column of data that has this /Product_Images/small/1/10032.png , I tried using RIGHT with …

  cory 76184

  4 replies

  12 years ago

  By: cory 76184

• How to calculate two new aliases columns into one?

  What I'm trying to do is calculate the difference between the aliases DaysAged and new. Can this b…

  hermanator

  1 replies

  12 years ago

  By: ScottPletcher

• Reducing size of datatype involved in index fails where as increasing size work

  This question is related to my question in SO Database events that will cause deletion of index For…

  IT researcher

  2 replies

  12 years ago

  By: Matt Miller (4)