SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• TRANSACATIN REPLICATION

  hello to all sql experts good day! i would like to ask some procedure/s…

  jolan.mahinay

  1 replies

  15 years, 5 months ago

  By: winash

• weird behavior in SSMS - backslash (\) displays as (#) in query editor

  I'm experiencing some weird behavior in SSMS for SS2008. When I create a new query and type the ba…

  sqlguy-736318

  2 replies

  15 years, 5 months ago

  By: grahamc

• SQL Server 2008 - CItrix environment

  I am able to connect the sql 2008 remotely through Windows login. But i am not able to log on throu…

  SSRfromChennai

  5 replies

  15 years, 5 months ago

  By: SSRfromChennai

• SQL Server 2008 - 2008 R2 Reports compatibility

  I would like to know if reports developed using SSRS 2008 R2 can be modified in SQL Server 2008? Th…

  vvsut

  3 replies

  15 years, 5 months ago

  By: WayneS

• Large Table Design

  I have table that currently has 40,000,000 rows (206 GB data space, 6.9 index space). This table h…

  jackimo

  28 replies

  15 years, 5 months ago

  By: PaulB-TheOneAndOnly

• Create XML Fragment for each row of data

  I have been struggling the past few days in getting this working. I'm trying to create an XML fragm…

  jjbear11

  3 replies

  15 years, 5 months ago

  By: LutzM

• Can a Foreign Key be linked to the Primary Key in two different tables?

  Hi, I'm running into a situation where I need a field in one table (Foreign Key) to be pulled from …

  samalex

  3 replies

  15 years, 5 months ago

  By: PaulB-TheOneAndOnly

• MS SQL Server Indexes

  Hello All, It is advised not to have more indexes on a table as it reduces the performance; I have …

  PatelVinayKumar

  4 replies

  15 years, 5 months ago

  By: Ninja's_RGR'us

• CLR SQL unloading and recreating Assemblies

  Has anyone else experienced issues with SQL CLR assemblies constantly being unloaded and created? …

  berokke1

  2 replies

  15 years, 5 months ago

  By: berokke1

• SQL Agent permissions

  Good day, In our environment every developer has a backup. I'm looking for a way to configure permi…

  Henry_Lee

  6 replies

  15 years, 5 months ago

  By: Geoff A

• Advantages On Upgrading to SQL 2008 - Specific to my environment

  We are planning to upgrade to 2008 from 2005. I have read few articles on the new features. Mention…

  curious_sqldba

  4 replies

  15 years, 5 months ago

  By: curious_sqldba

• Script SQL 2008 databases

  Hi All I used SQLpubwiz to script all databases into a SQL file, when i tried to use the …

  CrazyMan

  4 replies

  15 years, 5 months ago

  By: CrazyMan

• New Profiler Trace - but there are no Events listed in the UI

  Within SQL Server Profiler I click on File | Templates | New Template. The "Select Server Type" dro…

  Alex-815008

  3 replies

  15 years, 5 months ago

  By: sgirard 10189

• Query plan changes by usage of variables instead of values, Why?

  Hi, I have the below query: SELECT sms.SenderRef , LEN(sms.SenderRef) , LEFT(sms.SenderRef, 12)…

  sporoy

  2 replies

  15 years, 5 months ago

  By: sporoy

• Export SQL query from Execute SQL in SSIS

  Hi, I am new to SSIS and I was wondering if it was possible to export a SQL query using Execute SQ…

  anthony.hart

  2 replies

  15 years, 5 months ago

  By: anthony.hart