SQL Server 2005 General Discussion

• Topics

  Started by

  Posts

  Last post

• Bulk Insert

  Hi Guys I need to do an insert from a txt file into a table in sql server 2005. However the table c…

  guestuser31

  6 replies

  16 years ago

  By: JustANumber

• Job Activity Monitor Report?

  Hi All, Is there a way to get an automated report/snapshot of Job Activity Monitor every morning? …

  maxedout420

  2 replies

  16 years ago

  By: Silverfox

• Query to display a single status value

  I have a query in which I retrieve GroupId,Number Status.So are 3 types of status - NPL,SPL,PL When…

  rekha_sara

  8 replies

  16 years ago

  By: Nabha

• Help with a SELECT UPDATE query!!

  Hi all. I use SQL Server 2005 and I can't figure out this SQL statement. I have a table with 4 fie…

  rconway-574047

  3 replies

  16 years ago

  By: TimothyAWiseman

• SqlBulkCopy - skipping column

  I have an asp.net form (C#), that is reading an excel file and doing an SqlBulkCopy into my staging…

  SQL_NuB

  1 replies

  16 years ago

  By: SQL_NuB

• Split column values up into different columns

  Hi Guys I have a column which has data a,b,c,d,e,f I need to split the data after every comma to pu…

  guestuser31

  1 replies

  16 years ago

  By: Dave Ballantyne

• Creating blocks on purpose for testing

  Hello, Could someone suggest a strategy, or some sample code, for creating blocking on purpose - fo…

  webrunner

  4 replies

  16 years ago

  By: webrunner

• SQL 2005 Image Field

  I have a DB with a table TableA which has a column NOTE(image,Null). The properties of this column …

  prithvi-1147092

  2 replies

  16 years ago

  By: prithvi-1147092

• SQL SERver 2005 installation on windows xp

  hi, i am getting the follwing error while trying to install standard edition on windows xp professi…

  sharon-644450

  2 replies

  16 years ago

  By: Nabha

• Update Set with multiple embedded select

  Hi folks, I get the feeling I am overlooking the obvious and ending up tying myself in knot trying …

  steve.walls

  2 replies

  16 years ago

  By: steve.walls

• Best method to add non nullable column(s) in a very large table

  Hi guys, I was wondering what is the best way of adding a new non nullable column(s) to a wide and …

  Ignas Chilewa

  7 replies

  16 years ago

  By: Paul White

• which is the better way to improve performance

  Hi all, In my database, there is transaction table with two million records inserting every day. S…

  ManoharV

  14 replies

  16 years ago

  By: Johan Bijnens

• date problem

  hi experts in my table i have a column with name Date and id Date id 2009-7-…

  venukancharla.k

  1 replies

  16 years ago

  By: Nabha

• Srinking Database for LogShipping

  Hi All, I have Database with 500 tables initially, now i have separated 500 tables in to two differ…

  trayalacheruvu

  1 replies

  16 years ago

  By: trayalacheruvu

• null value in unique constraint

  Hi,I have a question that I can't find the answer anywhere...I know that in sql2005 the unique cons…

  x198yn

  2 replies

  16 years ago

  By: Paul White