SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Dynamic query problem

  I have a query like : Select @param = sum(scale) From table1 This works fine but if I have the foll…

  ramadesai108

  6 replies

  14 years, 5 months ago

  By: R_S

• Challenging table join problem

  Hi All, I have a table with the ID (int) and ScalePoints (float) columns called Points. I have …

  ramadesai108

  19 replies

  14 years, 5 months ago

  By: R_S

• SET IDENTITY_INSERT tableName ON isn't turning ON

  I have a couple of tables in a SSIS package data load that have identity attributes. I have added …

  larry.powell

  4 replies

  14 years, 5 months ago

  By: larry.powell

• OLE Automation programming:

  I have been trying to use the sp_oacreate with a linked server pointing to a second instance of an …

  John Esraelo-498130

  1 replies

  14 years, 5 months ago

  By: John Esraelo-498130

• SQL Script

  Hi, I am looking for a script that will search through the whole database for a particular name in …

  TST1

  6 replies

  14 years, 5 months ago

  By: Paul Bradshaw

• what if DAC is not enabled?

  If i have an issue accessing my database server, and the DAC is disabled, what are the options avai…

  winston Smith

  3 replies

  14 years, 5 months ago

  By: HowardW

• TESTINg against destiantion

  Is there any way that I can include My update staement , in my select? I know its weird quesion , …

  komal145

  2 replies

  14 years, 5 months ago

  By: ChrisM@Work

• SQL Services not starting automatically after windows CU3 rollout

  Hi, Has anyone noticed this being an issue after the Lync 2010 cu3 was installed? If so, any info i…

  brekher

  2 replies

  14 years, 5 months ago

  By: brekher

• Retrieve the Message part of a stored proc?

  I know how to retrieve data from a stored procedure using VBA in MS Access, but is there a way to r…

  voyager_87

  4 replies

  14 years, 5 months ago

  By: voyager_87

• Multiple inserts with ref. integrity within a transaction

  Good day all; I have to insert data periodically which will effect multiple tables. These tables in…

  kazim.raza

  6 replies

  14 years, 5 months ago

  By: Rich Mechaber

• SQL Server 2008 R2 - mirroring setup question...

  Hey gang! My org recently setup a clustered server. The infrastructure guy installed SQL Server 20…

  Larry Kruse

  7 replies

  14 years, 5 months ago

  By: Ralph Thomas

• Please can I get the best way to re srite this script using set based theory ...many thanks

  Please can I get the best way to re srite this script using set based theory ...many thanks CREATE …

  pespes009

  1 replies

  14 years, 5 months ago

  By: steveb.

• SQL script handover process

  Hi I hope someone could provide me some feedback on this issue. On day to day basis I (the DBA) int…

  andy.l

  1 replies

  14 years, 5 months ago

  By: Devendrakumar

• ssrs report builder

  hi, when i try to open any .rdl file in my report bulider its show this error... how to slove this …

  sql Anand

  1 replies

  14 years, 5 months ago

  By: bkubicek

• Problem with SQL server browser. Help needed

  Hello everybody. Need help from gurus. My setup: SQL Express 2008 R2 on Win 7 Professional. My pr…

  stimanov

  15 replies

  14 years, 5 months ago

  By: stimanov