SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Upgrade 2005 Express to 2008 Std

  I need to upgrade our current SQL Express 2005 database to SQL Server Standard 2008 due to the 4 gi…

  jpatt07

  1 replies

  15 years, 12 months ago

  By: Sedat Salman

• View access of table in different database

  I am running a 2008 Enterprise edition. Here is what I want to do. I have 2 databases. The first …

  Leonard Rutkowski

  2 replies

  15 years, 12 months ago

  By: Sedat Salman

• Looking a function to declare a table variable

  I need to declare a table variable from another existing table. If I use "Script table as" will cre…

  adonetok

  1 replies

  15 years, 12 months ago

  By: Ron McCullough

• 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, 12 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, 12 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, 12 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, 12 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, 12 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, 12 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, 12 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, 12 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, 12 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, 12 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, 12 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, 12 months ago

  By: Michael Valentine Jones