SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• To Get ERD

  How Can I get the ERD of a database created (with new tables) in Sql Server 2008 using SSMS

  rohaandba

  2 replies

  14 years, 10 months ago

  By: Steve Jones - SSC Editor

• Problem with an XML file in SSIS

  I'm trying to use SSIS to read an XML file and put it into a database, but I'm having problems. Ev…

  pryach

  1 replies

  14 years, 10 months ago

  By: pryach

• Header Row in CSV to be Seperated with no commas

  Hi All, I've been asked to create an export that has a header row with numerous bits of data in (fo…

  clarmatt73

  9 replies

  14 years, 10 months ago

  By: clarmatt73

• Even Subquery is incorrect Main query runs why?

  Hi, If i run the below query it is getting executed but it should throw error since id column is n…

  parthi-1705

  5 replies

  14 years, 10 months ago

  By: Gail Shaw

• Is_For_Replication for Foreign Key is required for a table not been part of replication?

  Hi, Is_For_Replication for Foreign Key is required for a table that not been part of replication? I…

  Latheesh NK

  2 replies

  14 years, 10 months ago

  By: Ian Scarlett

• Listing Tables in a given SQL Query

  Hi, I want to take list of tables and columns in a given SQL Query using a procedure. Thanks I…

  k_arumugam82

  5 replies

  14 years, 10 months ago

  By: Abhijit More

• MS certification exams

  Hi, I am having voucher from my boss where to verify the voucher number. http://www.prometric…

  parthi-1705

  1 replies

  14 years, 10 months ago

  By: Koen Verbeeck

• Fragmented indexes (of Change Data Capture tables)

  We are using CDC to log changes. Inserts on the cdc tables happen quite frequently, resulting in mi…

  smart_research

  6 replies

  14 years, 10 months ago

  By: Latheesh NK

• An INSERT / UPDATE Trigger in a replicated Environment

  Hi, I have just developed a trigger that will fire when a row is inserted into a primary table and …

  JayK

  1 replies

  14 years, 10 months ago

  By: karepa

• Designing Database Architecture - What Does this Mean?

  I work with SQL databases on a high level... meaning I run queries and stored procedures, and back…

  vadon97

  9 replies

  14 years, 10 months ago

  By: Gail Shaw

• the auto increament ID not in order

  Hi All, Just a simple question, I've a table with id column [id] [int] IDENTITY(1,1) NOT NULL so wh…

  dlam 18073

  8 replies

  14 years, 10 months ago

  By: Mike - CI

• Getting row duplications based on conditions

  Hi all, please i need some help, i have this table that has a sample data like this: insert into tb…

  timotech

  11 replies

  14 years, 10 months ago

  By: timotech

• Difference between #temp temporary tables and @temp table variables

  There is a bit of a debate going on in our office over the difference, if any, between a #temp tabl…

  jerry-621596

  15 replies

  14 years, 10 months ago

  By: mtillman-921105

• Using In Statement in Case Statement

  Please can someone help to point out what i'm doing wrong here: Select o.location, o.boardnumber, o…

  timotech

  8 replies

  14 years, 10 months ago

  By: timotech

• Pro-Active SQL Monitoring

  Hi We have a clustered environment and the important database is mirrored. It is a highly transacti…

  aMSDeveloper

  4 replies

  14 years, 10 months ago

  By: aMSDeveloper