SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• time difference in hh.mm

  I have one computed column Shorthours. In this computed column i want to display the result in hh.m…

  pnasz

  4 replies

  15 years, 8 months ago

  By: Jeff Moden

• Unable to deploy from Database project when CDC is enabled

  We are using Visual Studio database project for database development. We recently enabled CDC on c…

  Randy Emerson

  1 replies

  15 years, 8 months ago

  By: GSquared

• Using a common seed generation for multiple tables.

  Hi, I'm new to SQL Server 2008, and I like to seek your help in achieving the following. We are try…

  Randy Emerson

  12 replies

  15 years, 8 months ago

  By: Randy Emerson

• Selecting value(s) from a field that will equal a selected value

  Hello. I apologize if the question is not in a proper format. I am trying to find a way (Via SQL o…

  lacelle

  1 replies

  15 years, 8 months ago

  By: WayneS

• Getting latest date from columns

  Hi all, I'm wondering what is the best way to get the latest datetime from several columns. The que…

  torpkev

  2 replies

  15 years, 8 months ago

  By: torpkev

• Database migrated from 2000 to 2008 R2

  I restored a sql server 2000 database to a sql server 2008R2 instance and it went throught the upgr…

  DBABC

  2 replies

  15 years, 8 months ago

  By: DBABC

• Track table row deletion

  What is the best way to track the user who deletes any records in a specified table? User informati…

  sukino.li

  6 replies

  15 years, 8 months ago

  By: sukino.li

• ERROR_MESSAGE() returns different message then the one shown in the message tab in MSQL Management Studio

  Hello guys I'm hitting a wall here, i have a certain procedure1 call a procedure2 on a linked serve…

  skerjanc.matej

  3 replies

  15 years, 8 months ago

  By: skerjanc.matej

• import data from excel file to sql server database

  plz..........help any one .....how to import data from excel file to sql server database

  gupta.sreekanth

  2 replies

  15 years, 8 months ago

  By: Mike John

• Merging data from another system into mssql

  Hi I am looking for some advice or best practices on merging data from a separate system into a mss…

  all4miller

  2 replies

  15 years, 8 months ago

  By: all4miller

• Querying 8GB table is taking too long - need to just query last 3 months of data

  Hi, We have an issue running a reports in that the query can take up to 4:30 minutes to run. we iss…

  JayK

  3 replies

  15 years, 8 months ago

  By: JayK

• Accumulate Hours and Generate finish date

  Hi, I am wotking on work performed in a day create the day when it will finish. considering 8 hrs i…

  Sandeep Saretha

  2 replies

  15 years, 8 months ago

  By: Sandeep Saretha

• Split delimited column values into multiple rows

  I'm trying to use the query found here http://www.eggheadcafe.com/software/aspnet/31741612/split-co…

  Aaron Prohaska

  4 replies

  15 years, 8 months ago

  By: Evil Kraig F

• Last time a user was connected

  Is it possible to find out when a user was connected last time?

  DBABC

  3 replies

  15 years, 8 months ago

  By: Adiga

• Adding a count in cross tab data

  There is a table showing below: A--B--C--D--COUNT X--X---------2 ------X------1 ------X--X---2 X--X…

  adonetok

  1 replies

  15 years, 8 months ago

  By: LutzM