SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Sql Server 2008 Generate Script Process

  Hi, I have a questions with regards to using Sql Server 2008 to automatically script out sql server…

  Chris Kitchen

  4 replies

  13 years, 1 months ago

  By: Chris Kitchen

• Issue: Index creation is not running in parallel

  I have a customer who has a SQL Server 2008 R2 Enterprise Edition clustered instance. The instance …

  okbangas

  26 replies

  13 years, 1 months ago

  By: Jannie-186227

• Implementing CDC on All tables of the database

  Hi, Could any one help me out with script that enables CDC on all the tables of a database. Thanks

  rohaandba

  1 replies

  13 years, 1 months ago

  By: Sean Lange

• Join on 2 tables where values are different

  Hi everyone I have 2 tables in SQL and i would like to join them together however the fields I wish…

  ByronOne

  12 replies

  13 years, 1 months ago

  By: ByronOne

• Slow Cascade Stored Procedure & Hang

  Table Image : http://tinypic.com/r/1075g6v/6 So I have this query which searches id by id and calcu…

  venkyzrocks

  10 replies

  13 years, 1 months ago

  By: venkyzrocks

• Initial (MB) vs Autogrowth

  I have a database that was set with an initial size of close to 10 gigs. I am down to 2% free space…

  Rob Phillips

  16 replies

  13 years, 1 months ago

  By: Rob Phillips

• SQL Server Agent account for job

  Hello - I have a developer that wants to set up a job to run ActiveX Script. They can't see anythin…

  NJDave

  9 replies

  13 years, 1 months ago

  By: NJDave

• Output Parameter in Stored PRocedure

  Hi all, I have created a sp in which I want to extract last identity value after doing insertion...…

  kapil_kk

  6 replies

  13 years, 1 months ago

  By: kapil_kk

• T-SQL help

  Hello I need one help I have list of dates from those date I need to display all dates with schoolI…

  yogi123

  5 replies

  13 years, 1 months ago

  By: Sean Lange

• Transaction Log Backup Always Generates Job Failed Message

  Hi everyone, I am having problems getting my daily transaction log backups to work on a maintenance…

  lostie37

  1 replies

  13 years, 1 months ago

  By: Lynn Pettis

• ANSI settings

  Hi All, There is an application that uses DSN. The connection type is ODBC. In the DSN the ANSI set…

  Igor Micev

  5 replies

  13 years, 1 months ago

  By: Igor Micev

• Subscriptions - Failure sending mail. 'Include Link' works, 'Include Report' does not.

  Hi Everyone I'm hoping you can help me, I've followed most links on the net and decided to post. SQ…

  amcveagh

  4 replies

  13 years, 1 months ago

  By: mssqlsrv

• Splitting the rows -- distributing on logic

  Hi Experts , here is sample table and data create table #sample ( Invtidvarchar(255) ,[Final …

  Nagaram

  9 replies

  13 years, 1 months ago

  By: Nagaram

• Replication - missing records and large Msrepl_commands table

  Hi We have run into a problem with missing data in our subscriber when using replication even thoug…

  Kwisatz78

  1 replies

  13 years, 1 months ago

  By: Kwisatz78

• Restore Change Data Capture database without KEEP_CDC option

  Hello, Suppose you have a database that you need to restore on another server. This database has S…

  Jason Bunn

  1 replies

  13 years, 1 months ago

  By: wagner19722005