SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• BEGIN/COMMIT TRANSACTION question

  I am attempting to prune out data from some tables that have millions of rows of data (which who wa…

  MyDoggieJessie

  3 replies

  14 years, 10 months ago

  By: MyDoggieJessie

• If a database contains Fact and Dimension tables, do we call that database as datawarehouse?

  Hello all, I am bit confused... I know we develop OLAP using Fact and Dimension tables. Do we call …

  Rookie R

  10 replies

  14 years, 10 months ago

  By: Rookie R

• database context in SQL Server Management Studio

  I'm on a new gig, and lately I'm having an issue in SSMS where, after having changed the database d…

  sqltung

  5 replies

  14 years, 10 months ago

  By: Grant Fritchey

• Procedure To Get Primary Key Columns Names, Ordinal Position and DataType From System Tables BAsed On Table Name

  I am trying to find a way to get all 3 details and I am hitting a wall. I am using this t-sql 2 get…

  William Krupinsky JR

  3 replies

  14 years, 10 months ago

  By: William Krupinsky JR

• Cross Database Privileges for Application Role

  Hi everyone, I wish to check whether granting of privileges of different databases can be assigned …

  dias__84

  1 replies

  14 years, 10 months ago

  By: Orlando Colamatteo

• Insert and select on a table at the same time

  Hi, I have a job A which inserts data into a table and another job B which selects data from the sa…

  Pink123

  7 replies

  14 years, 10 months ago

  By: seth delconte

• cumulative updates

  Are Cumulative Updates really cumulative? I have SQL Server 2008 R2. If there are bugs that can be …

  didier41

  1 replies

  14 years, 10 months ago

  By: mazzz

• Is this a Single Resource Deadlock?

  I was wondering if someone could give me some pointers as to how I should go about investigating wh…

  Alex Webber

  17 replies

  14 years, 10 months ago

  By: Alex Webber

• Having problem starting SQL Server Express

  Hi I am using Microsoft SQL Server Express 2008. It is running on Windows XP Pro, with 10Gig hard d…

  Ish Fad

  3 replies

  14 years, 10 months ago

  By: Gaurav Gosain-395499

• 2005 to 2008 R2 upgrade issues

  Hi All, We recently upgraded you SQL Server cluster from 2005 x64 Standard to 2008 x64 R2 Enterpri…

  Kris Sledge

  9 replies

  14 years, 10 months ago

  By: miranwara

• Mirroring with SQL 2008 Standard

  I'm currently looking at mirroring and have set up a mirror on 2 servers with out automatic failove…

  mark.jones

  5 replies

  14 years, 10 months ago

  By: Alex Webber

• BI Tool vendors in Brazil

  I am seeking a pre-built BI stack that uses SQL Server 2008 technologies including Reporting Servic…

  DSpaceNine

  1 replies

  14 years, 10 months ago

  By: Søren

• database trigger

  business rule: whenever my c#.net applications insert, update or delete an order, it will also auto…

  phamm

  3 replies

  14 years, 10 months ago

  By: Kingston Dhasian

• Please help= Need help on changing the cluster instance service account password

  Can some one please provide me the step by step procedure or site. I have the following steps pleas…

  hydbadrose

  1 replies

  14 years, 10 months ago

  By: Gaurav Gosain-395499

• Possible to have ALTER TRACE permission without being in sysadmin role???

  I had sent a request to my web host that houses my SQL Server 2008 database. The request was to be…

  Thomas Stringer

  1 replies

  14 years, 10 months ago

  By: Gail Shaw