SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• SYNONYM in MS Access

  I saw this briefly mentioned in a a blog and posted a comment there, but I'm also posting it here a…

  fmurphy

  1 replies

  14 years, 6 months ago

  By: Devendrakumar

• why data base deveoper can't be called as software engineer ?

  Hi all why data base developer can't be called as software engineer ?

  ravi@sql

  2 replies

  14 years, 6 months ago

  By: okbangas

• SSMS Scripting out tables/indexes is useless

  I have a number of partitioned tables and indexes, on various filegroups. In SSMS i scripted the ob…

  winston Smith

  3 replies

  14 years, 6 months ago

  By: winston Smith

• fetching rowcount in ssis

  How to fetch rowcounts for matched and nomatched outputs of lookup in SSIS?

  kirti.malukani

  3 replies

  14 years, 6 months ago

  By: steveb.

• Need help to split Multiple Columns into One column..

  Hi, I have a Query Result like following id Name Mark1 Mark 2 Mark3 Mark4 mark 5 -----------------…

  panneer.adms

  1 replies

  14 years, 6 months ago

  By: spaghettidba

• SQL Server 2008 R2 Full Text search ContainsTable NOT working properly

  There might be some understanding issue, I have a table with two columns (id and Title). I have app…

  Shamshad Ali

  3 replies

  14 years, 6 months ago

  By: EdVassie

• Insert data obtained from temp table

  Can i use the results obtained through a temp table to insert data into another table?I am getting …

  duggal.priyanka06

  2 replies

  14 years, 6 months ago

  By: Jayanth_Kurup

• sql script to export tables as insert statements?

  I always seem to forget how to export data as insert scripts from the database. Is there some type…

  sqlguy-736318

  5 replies

  14 years, 6 months ago

  By: Jayanth_Kurup

• Having Sharepoint on a multi instance SQL Server

  Hello, I wondered if anyone could give me a little advice, I have a server that already has 3 intan…

  Duran

  3 replies

  14 years, 6 months ago

  By: EdVassie

• How to dynamically execute SQL stored as text in a table

  I have a table containing SQL statements stored in text columns, I want to write a S.P. that finds …

  martinchantler

  6 replies

  14 years, 6 months ago

  By: martinchantler

• HELP REQUIRED!!! SSIS CHALLENGE

  Hello All, I am having a challenge with SSIS to generate txt Files for a where clause i.e when the …

  pespes009

  7 replies

  14 years, 6 months ago

  By: pespes009

• same variable as input & output parameter in Execute SQL task

  [font="Tahoma"] Hello Friends, I am using Execute SQL task for initializing the Start Date & E…

  MuraliKrishnan1980

  4 replies

  14 years, 6 months ago

  By: MuraliKrishnan1980

• Using table hint in SLQ SERVER 2008 R2

  Hi Guys, We have SQL SERVER 2008 R2, and also we have an old transactional Stored procedure that is…

  Aspet Golestanian Namagerdi

  3 replies

  14 years, 6 months ago

  By: Performance Guard (Shehap)

• Two Different Servers JOIN (limited permissions)

  I have permission to run queries on two different servers. If I need to preserve data I just send …

  texpic

  2 replies

  14 years, 6 months ago

  By: tfifield

• SET ARITHABORT must be ON for XML. Why?

  Hello All, SELECT failed because the following SET options have incorrect settings: 'ARITHABORT'. V…

  ben.brugman

  3 replies

  14 years, 6 months ago

  By: GSquared