SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• XML Schema and Deadlocks

  This is an interesting error that we are getting on some machines when we push our databases out us…

  JKSQL

  1 replies

  13 years, 8 months ago

  By: RBarryYoung

• Replication failing with error "Column name or number of supplied values does not match table definition."

  Hi all, I have created a pull transactional replication where the replication was running fine unti…

  ryan_xh

  8 replies

  13 years, 8 months ago

  By: ryan_xh

• Derived column

  i have column value something like below. {784A4579-8689-438E-ADAA-9DCBC8A88AE7} I just need "784A4…

  komal145

  7 replies

  13 years, 8 months ago

  By: dan-572483

• all about BI,sql

  Hello, I am new to this forum, and really appreciate the responsiveness from my first post. Here’s …

  salmita

  2 replies

  13 years, 8 months ago

  By: Miles Neale

• Best way to truncate a log in simple mode ?

  Hi, I have a 60Gb log file i need to truncate on a DB running in simple mode - what is the easiest …

  mjwlufc

  16 replies

  13 years, 8 months ago

  By: emile.milne

• ssrs can you deploy the same report to multiple locations with different params

  Hi can you deploy the same report to multiple locations with different default params? I have one r…

  erics44

  3 replies

  13 years, 8 months ago

  By: Gazareth

• SSIS Export to csv--Excel Template with "Refresh Data" help

  I hope this forum is the correct place for my question. I'm using SSIS to export a very wide set of…

  lduvall

  1 replies

  13 years, 8 months ago

  By: sandeep rawat

• Trigger to split one column and insert into another table

  Hi, I need a trigger on below condition, am having a table called "Tracker", msg_text is a column i…

  Minnu

  1 replies

  13 years, 8 months ago

  By: RP_DBA

• execute a procedure in another one

  hi i am trying unsuccessfully to execute the following procedure in another one 1- USE [RECLACSR-DB…

  marclas

  3 replies

  13 years, 8 months ago

  By: Lokesh Vij

• SQL Trace - simple SELECT shows writes

  Hi there! As the subject says, when I read a trace file and the SQL:BatchCompleted event, the Write…

  GordonLiddy

  5 replies

  13 years, 8 months ago

  By: GordonLiddy

• Extract 5 digit and 3 digit numerics

  I have a table like this- Sno Text 1 Batch 58701, Sub -000 . 2 Batch 16260, Sub 0…

  Kumar SQL

  3 replies

  13 years, 8 months ago

  By: Dwain Camps

• Certificate-Signed Stored Procedure: CREATE PROC script doesn't include this

  I've signed a couple of stored procs with certificates, based on this excellent article[/url] by Jo…

  Rich Mechaber

  5 replies

  13 years, 8 months ago

  By: RBarryYoung

• OPENQUERY Slow

  If I execute the following it takes over 30 minutes to execute: SELECT COUNT(*) FROM OPENQUERY(LSC…

  Welsh Corgi

  5 replies

  13 years, 8 months ago

  By: Jared

• Adventure Works DW 2008R2

  Hi all, I am working through Bill Pearson's tutorial Stairway to MDX - STEP 1: Getting Started with…

  winston.snyder

  7 replies

  13 years, 8 months ago

  By: Koen Verbeeck

• Exporting data from a sql server table to text file- data transformation

  Hi All, I need to export some data from SQL Server (2008 R2) table to a text file. There are a few …

  suman.mullapudi

  3 replies

  13 years, 8 months ago

  By: suman.mullapudi