SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Best Authentication Mode to use

  Apologies in advance if this question has already been answered, but I have been doing some reading…

  Sliverlight

  11 replies

  15 years, 7 months ago

  By: Steve Jones - SSC Editor

• Trigger For Delete - Multiple Row Value

  hi, i have a question, how to read 'value from deleted' from multiple row in trigger for delete? se…

  ard_dicted

  17 replies

  15 years, 7 months ago

  By: martinimaurilio

• Date comparison

  I have a table from where i need to retrieve data when datecol < todays date how to do?? I am wr…

  priyappated-812940

  3 replies

  15 years, 7 months ago

  By: priyappated-812940

• Solution-level variable in SQL RS

  Hi all I have a recurrent problem... I have many Reporting Services solutions which all look at the…

  nick-1043370

  2 replies

  15 years, 7 months ago

  By: Nagesh S-432384

• Are there any gotchas with TDE on a Windows Server 2008 server (i.e., Microsoft failover clustering)

  I am trying to use TDE (Transparent Data Encryption) for the first time on SQL Server 2008 R1 with …

  shew

  2 replies

  15 years, 7 months ago

  By: shew

• Help needed in setting collation for the SQL Server

  Hi All, I have two tasks to do. 1. Installing the SQL Server 2008 Enterprise edition. 2. Migrate th…

  mohan.pariveda

  4 replies

  15 years, 7 months ago

  By: dmoldovan

• Double Quote Text Identifiers and SSIS

  This is an old one but has anyone had any luck with importing csv files that have double quote text…

  bridgt01

  4 replies

  15 years, 7 months ago

  By: jeffismyname22

• Return the resultSet in XMl format

  Hi Guys, I have Database in SQL SERVER 2008.In this datbase I have Message table,which has the foll…

  Aspet Golestanian Namagerdi

  1 replies

  15 years, 7 months ago

  By: Nagesh S-432384

• Designing table structure for tracking library data

  Please help me to desgin table structure for tracking data I have centralized library project in wh…

  htkroshan

  2 replies

  15 years, 7 months ago

  By: htkroshan

• Procedure Stats

  Hi all, I'm hoping that somebody may be able to explain an oddity I have spotted. According to BOL …

  RichardDouglas

  12 replies

  15 years, 7 months ago

  By: Gail Shaw

• Databse Performance Issue

  I made a Stored Procedure as Process with Indexes but when I Executed it on my Local PC it takes 5…

  imran_ghainsh

  3 replies

  15 years, 7 months ago

  By: Steve Jones - SSC Editor

• Moving databases

  Hello, I have to move 10 databases from a colo facility in Virginia to one in Nashville, TN. The d…

  BTW

  18 replies

  15 years, 7 months ago

  By: Michael Valentine Jones

• Query Selectivity Computation

  Hi friends, I m executing different queries with different parameter values from my application. Ho…

  gaurangtalwadkar

  6 replies

  15 years, 7 months ago

  By: Lowell

• SQL Query Error

  I want to list films with the actor who has received the most awards appeared in? SELECT Film.FilmI…

  goredema

  3 replies

  15 years, 7 months ago

  By: Gail Shaw

• A sample question

  I find there are many indexes named by 'IX_' in the AdeventureWork provided by Microsoft. And what…

  kinzent

  1 replies

  15 years, 7 months ago

  By: Gail Shaw