SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• counter for insert

  I need to do an insert. create your ID column as identity column : but this column is not an idenit…

  peerless

  9 replies

  14 years, 9 months ago

  By: Sean Lange

• SQL SEVRER 2000 error when using data stage

  I have a question,I am using data stage to get data from sql server 2000 and one of my query is be…

  wenkat_j

  2 replies

  14 years, 9 months ago

  By: Michael L John

• sql script

  Given the output table: TABLE [dbo].[tblFinancialContact]( [FinancialContactID] [int] NOT NULL, [Pr…

  peerless

  3 replies

  14 years, 9 months ago

  By: jcrawf02

• need to change the table

  need to delete the columns in the table if they exist CREATE TABLE [dbo].[tblServiceProvider]( [Pro…

  peerless

  5 replies

  14 years, 9 months ago

  By: peerless

• start MSDTC with a command

  Is there any command to start MSDTC service? Thanks.

  sql_2005_fan

  3 replies

  14 years, 9 months ago

  By: luckysql.kinda

• hexadecimal value 0x07, is an invalid character.

  Hi All, I have a link of http://www.idealist.org/feeds/volop_en.xml.bz2, from this link to download…

  Jingzhihu

  1 replies

  14 years, 9 months ago

  By: Orlando Colamatteo

• Moving a DB from one HDD to another

  Hi all, Im currently moving a lot of DBs from 1 server to another, shortly after this for reasons …

  Staggerlee

  8 replies

  14 years, 9 months ago

  By: Anathn

• Help - cross tab / pivot - updating data

  Hi, I have data stored in a couple of columns in my database. For example - item_type and item_valu…

  vipul2020

  4 replies

  14 years, 9 months ago

  By: LutzM

• Linked Servers

  Hi I dont know, weather this is valid question or not? So when we establish the linked servers, we …

  bvsc

  1 replies

  14 years, 9 months ago

  By: Lowell

• Remove Spaces Between Columns In Results To Text

  Hi I'm trying to send results as email using the following command EXEC MASTER.DBO.XP_SENDMAIL @Rec…

  theunique1011

  2 replies

  14 years, 9 months ago

  By: Orlando Colamatteo

• How to debug a stored proc that accepts table-valued parameters

  We recently transitioned to SQL Server 2008 and I'm trying to take advantage of the table-valued pa…

  gcresse

  2 replies

  14 years, 9 months ago

  By: gcresse

• SQL 2008 linked server to postgreSQL db failure

  Hi everyone, Anyone have success in accessing a postgreSQL db over a 2008 SQL linked server? I've b…

  coenzyme77

  1 replies

  14 years, 9 months ago

  By: Lowell

• Error Message: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

  |Hi, We have a series of reports that run on our reporting server but lately we have been getting t…

  JayK

  2 replies

  14 years, 9 months ago

  By: Anathn

• Big Search Query

  I have one BIG search query which is using near by 30 joins to get the expected output. First few t…

  Abhijit More

  1 replies

  14 years, 9 months ago

  By: Grant Fritchey

• Save multiple resultsets from stored procedure into temp objects

  Is there any way to store multiple resultsets returing from one stored procedure into temporary obj…

  Tarun Jaggi

  6 replies

  14 years, 9 months ago

  By: Tarun Jaggi