SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• ODBC Error updating a recordset (rst.Update)

  I am getting an error (number -2147217887, error message "ODBC--call failed.") when I try to execut…

  jpserra3

  4 replies

  10 years, 10 months ago

  By: sgmunson

• Powershell Syntax

  Hi guys I raised a similar thread on this some time ago and have a new problem with doing a restore…

  mitzyturbo

  5 replies

  10 years, 10 months ago

  By: mitzyturbo

• unzip using Execute Process task success but getting error message in the e-mail

  Exec Prcoess task with source : \\ftp destination :\\ftp\unzip work directory \\ftp\unzip executabl…

  gsdineshasm

  6 replies

  10 years, 10 months ago

  By: gsdineshasm

• Replication Failures & reasons

  How to find out the replication failures are related to hardware or database related?

  ramana3327

  1 replies

  10 years, 10 months ago

  By: BLOB EATER

• Query execution plan

  Hi Guys, Is it possible to check query execution plan of a store procedure from create script (befo…

  salamlemon

  8 replies

  10 years, 10 months ago

  By: ChrisM@Work

• SQL Server Backup with SAN backup

  Hi, We have got a mixed environment where we have production , dev and test servers. What we have b…

  HBhagat

  5 replies

  10 years, 10 months ago

  By: Ken McKelvey

• SQL Server agent job was not running last night.

  Hi, I am using SQL Server 2008 R2. I am using one job to transfer the data from one table to an…

  manik_anu

  4 replies

  10 years, 10 months ago

  By: manik_anu

• db_name() return type : nvarchar(128)

  Hi Experts, When I'm running the below script in sharepoint, it fails to run as it is not able to b…

  SQL_Hunt

  2 replies

  10 years, 10 months ago

  By: Dohsan

• Schema changes with transactional replication

  How do we know our schema changes will propagate to subscriber without breaking the replication? Is…

  ramana3327

  2 replies

  10 years, 10 months ago

  By: ramana3327

• Confused about what function to create

  Hello, I'm no expert in SQL, I dabble here and there. I need to create a function which takes two b…

  .Netter

  5 replies

  10 years, 10 months ago

  By: ScottPletcher

• Hepling with query getting the most recent record

  I've been trying various ways to accomplish this and I think I've reached a mental brick wall. If …

  LeeFAR

  4 replies

  10 years, 10 months ago

  By: LeeFAR

• Using left and charindex to parse string , getting rid of rest of data

  I'm confused, as I am trying to erase some erroneous bad data in my table. The description column h…

  archyya

  2 replies

  10 years, 10 months ago

  By: archyya

• Question regarding database architecture

  Hi all, Not really an SQL Server 2008-specific question, but couldn't think of a better forum to pl…

  kramaswamy

  9 replies

  10 years, 10 months ago

  By: TomThomson

• deadlock error msg 1205

  Hi Experts, To get deadlock victim alert do we need to turn on deadlock trace flags or if I create …

  SQL_Hunt

  4 replies

  10 years, 10 months ago

  By: SQL_Hunt

• Reorgzanizing all failed - disabled indexes

  Hi, We have a maintenance plan that reorganize all indexes in a database. We disabled one of the in…

  ramana3327

  1 replies

  10 years, 10 months ago

  By: Ed Wagner