SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• 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

  11 years, 3 months 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

  11 years, 3 months 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

  11 years, 3 months 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

  11 years, 3 months 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

  11 years, 3 months 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

  11 years, 3 months 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

  11 years, 3 months 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

  11 years, 3 months 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

  11 years, 3 months 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

  11 years, 3 months 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

  11 years, 3 months 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

  11 years, 3 months 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

  11 years, 3 months ago

  By: Matt Miller (4)

• Transaction Log lots of free Space

  Hi I have a 3rd party vendors DB on full recovery with regualr full backups and tran log backups. I…

  terry999

  6 replies

  11 years, 3 months ago

  By: Lynn Pettis

• View column that checks if table's int column is null, enters a boolean value in the view column instead of the int value

  Have a view that I need to add a column to which checks the value of another table's column which i…

  php_guy

  8 replies

  11 years, 3 months ago

  By: php_guy