SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Charindex,substring.....

  I have a string column very long with multiple underscores in between. My requirement is to only s…

  peacesells

  3 replies

  13 years, 1 months ago

  By: mister.magoo

• Ways to replicate

  Hello, I have a live db that users need to access it for reporting purposes. What is the best way …

  zouzou

  9 replies

  13 years, 1 months ago

  By: Alan Burstein

• Setting rowcount also limits the available databases in the database drop down...

  All, When setting the rowcount in a query in SQL Server Management Studio, the count of databases …

  aochss

  2 replies

  13 years, 1 months ago

  By: Orlando Colamatteo

• OLE DB provider 'VFPOLEDB' cannot be used for distributed queries because the provider is configured to run in single-threaded apartment mode.

  hello all. I want to use vfpoledb provider in sql server 2008 and windows server 2008 and download …

  elham_azizi_62

  3 replies

  13 years, 1 months ago

  By: Fabrizio Faleni

• BULK Question

  I export some data from a query into a text file. Then I create a temporary table and bulk insert …

  TJT

  5 replies

  13 years, 1 months ago

  By: TJT

• Extended Events

  I only recently discovered Extended Events. Why? I don't know! I jumped in and learned how to use…

  xxxxxxxxxxx

  17 replies

  13 years, 1 months ago

  By: Grant Fritchey

• Dynamic Bulk Insert executing as background task?

  Question.. the following code: set @strSQL = 'bulk insert MYServer..[' + @tablename + '] from ''\\…

  Erin Ramsay

  2 replies

  13 years, 1 months ago

  By: Erin Ramsay

• How to Pivot table?

  SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[sales_r…

  vanapandi

  5 replies

  13 years, 1 months ago

  By: Sean Lange

• Test connection succesfull with Import Export Wizard but fails in BIDS 2012 - Oracle to SQL

  Hello All, Test connection succesfull with Import Export Wizard but fails in SSIS Pkg in BIDS 2012 …

  SQListic

  4 replies

  13 years, 1 months ago

  By: McSQL

• update still difficult??

  I have a table which has three columns create table employees ( ID int NOT NULL PRIMARY KEY NAME…

  WonderPra

  24 replies

  13 years, 1 months ago

  By: WonderPra

• Capture Data Change

  I'm trying to use CDC for auditing certain tables, the problem I find is it doesn't capture the use…

  Bobby Glover

  7 replies

  13 years, 1 months ago

  By: Bobby Glover

• table Joins and overby clause

  Hi, Please find below query, tab1 - Col1 int, Col2 varchar2(30) tab2 - Col1 int, col2 varchar2(30) …

  sanandh87

  4 replies

  13 years, 1 months ago

  By: ln74077

• secondary database is sink

  secondary database in logshipping is sink how can i resume ?

  ramyours2003

  3 replies

  13 years, 1 months ago

  By: george sibbald

• update a column based on Ideal

  hi, when the table is ideal or not access in sql server for some time say for 3 hours then i need t…

  yuvipoy

  3 replies

  13 years, 1 months ago

  By: McSQL

• Upgrading SQL Server

  Hi DBA We are upgrading SQL Server 2005 Box to 2012(Side by Side), for planning new server hardwa…

  SQListic

  2 replies

  13 years, 1 months ago

  By: david.alcock